How to enable oracle fusion user level role based security in BIP reports.

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

)