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

)

How to pass multiple value in parameter with comma separator without using from and to parameter range logic. – Oracle Fusion

Requirement: User want to run the report for specific comma separator list of multiple values, User does not want use from and to range parameter logic.

Example: Parameter Value (Seq_id) : 123,345,456  

 

Solution:

At the time of defining a parameter, Please select checkbox – Text Field Contains Comma- Separated value.

Try to run the report and pass parameter like 123,345,678, Report will run normally as expected.