How To Determine The Attributes Of Data Role (Doc ID 2082580.1)

Last updated on DECEMBER 02, 2015

Applies to:

Oracle Fusion General Ledger Cloud Service - Version 11.1.9.2.0 and later
Oracle Fusion General Ledger - Version 11.1.9.2.0 and later
Information in this document applies to any platform.

Goal

For Fusion Apps, Financials pillar, for BI Publisher,
the customer requests a set of secured list views to be able to secure the
data by:
-> BU
-> Legder
-> Legal Entity
-> Asset Book
In Oracle EBS, we have used Profile
- Single Operating Unit -> We use the condition ORG_ID =
FND_PROFILE('ORG_ID')
- Multiple Org Access Control -> We use the standard function for checking
mo_global.check_access(ORG_ID) = 'Y'
Please kindly guide me in Oracle Fusion.
Example:
1. In the BIP Parameter -> How to restrict the list of values of Business
Unit base one the role of current user login
SEELCT NAME, ORGANIZATION_ID
FROM HR_OPERATING_UNITS
WHERE
1 = 1
<What condition here?>
ORDER BY NAME
2. In the main SQL Query -> How to query only the AR Transactions belong to
the Business Units which the current login user has been assigned.
SELECT TRX_NUMBER, ORG_ID
FROM RA_CUSTOMER_TRX_ALL
WHERE
1 = 1
<What condition here?>
ORDER BY TRX_NUMBER
 

Solution

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms