Version : IIQ 8.4p2
Can someone please share on your experience on enabling “Data access” aggregations on ERP cloud. Would like to understand if there is going to performance impact as quoted in the documentation - Data Access Aggregation Settings.
Our requirement is E2E automation of Oracle Roles and data access for end users using RBAC. hence this is a vital field for our strategy.
Hi @rsoma welcome to the community 
Based on my limited experience with Oracle ERP Cloud, yes enabling DAOs aggregation does introduce extra load… I think because it’s exposing all the DAOs (BUs, Ledgers, etc.) through additional REST calls per role.
But again point to note the impact really depends on your tenant size and how many roles/DAOs each user has, from my limited experience, it’s still safe to enable as long as you design the schedule properly…
keep full aggregations less frequent (mid-night or so), rely on delta (if possible), and avoid overlapping runs/tasks for the same application.
If you can share estimated user volume and number of Oracle roles per user, maybe I can imagine with you the impact
Thanks for the response, Mustafa. The current user base is expected to be around 800 users, each with at least two ERP roles, along with data access attributes for the end-user.
Thanks for the details, @rsoma
With ~800 users and at least 2 ERP roles each, you’re still in a very safe zone.
In practice, performance issues usually start at much higher volumes (10k+ users and heavier Financials/data access configurations).
If i’m putting my feet in your shoes, I’d go ahead and enable Data Access, keep full aggregation on a nightly schedule, and use delta for day-to-day changes, that should be more than enough for your current scale.
Have a nice and great one and wishing you a great experience with your integration!
Regards,
Mustafa