You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

Data Access by Legal Entity instead of Business Unit

Accepted answer
edited Nov 8, 2019 3:23AM in Financials – General 5 comments


How to assign data access to users by Legal Entity using custom Database Resource


A client has a requirement for billing managers to manage receivables activities by Legal Entity. Currently we have set up custom job roles that use Data Security Policies driven by Business Unit. However their are multiple LEs per BU, and the customer wants to restrict by LE, not BU. 

I know under 'Security Console > Administration > General > Manage Database Resources' you can create a custom Database Resource, which is clear. However, FUN_USER_ROLE_DATA_ASGNMNTS does not have a Legal Entity column, so you seemingly cannot assign Legal Entities to users via 'Manage Data Access for Users', so I don't know what to do with the custom Database Resource . Is there another way to assign potentially multiple Legal Entities to a user other than 'Manage Data Access for Users' (or derive it somehow), that I could then use as a Condition SQL Predicate in a custom Database Resource? A billing clerk could handle 2


Howdy, Stranger!

Log In

To view full details, sign in.


Don't have an account? Click here to get started!