Register today for Oracle CloudWorld. October 17th - 20th, Las Vegas

Register now

Hillel Cooperman, Senior VP of User Experience Design, has a message for you on Oracle CloudWorld

Watch now
Data Access by Legal Entity instead of Business Unit — Cloud Customer Connect
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
50
Views
5
Comments
edited Nov 8, 2019 3:23AM in Financials – General 5 comments

Summary

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

Content

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

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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