Requirement: At the time of running the BI report, Business needs to enable security so the user can access only those data with respect to assigned security roles and access.
Solution:
When we designed oracle BIP report logic we can enable security when we declare GL parameter logic. We can use below security-based ledger LOV query to handle business security issues.
GL Ledger Security based LOV query:
SELECT NAME,LEDGER_ID FROM
GL_LEDGERS WHERE
LEDGER_ID IN
(
SELECT ASA.LEDGER_ID FROM
GL_ACCESS_SET_ASSIGNMENTS ASA, GL_ACCESS_SETS GS, FUSION.FUN_USER_ROLE_DATA_ASGNMNTS URDA
WHERE
ASA.ACCESS_SET_ID=GS.ACCESS_SET_ID
AND URDA.USER_GUID=FND_GLOBAL.USER_GUID
AND GS.ACCESS_SET_ID=URDA.ACCESS_SET_ID
)