How to resolve BIP Report Excel Output column shrinkage issue

How to resolve BIP Report Excel Output column shrinkage issue

 

Issue Description:

I have designed RTF report and at time of generating report output in excel format, In output table column automatically shrink, Which will not be accepted as per standard practice because the user will not resize the table column when they use on daily basis.

 

I am getting output like this format which is not as per the standard.

Resolution:

For solving this table column shrinkage issue we have to set RTF table property.

This is my RTF file format.

Step1:

Now select the table and  right-click and select table property.

Select Table > Right Click > Select Table Property

Step2:

Select the column tab > Enter Preferred width: 15% > Ok.

 

Step4:

Now save the RTF file and upload your template and check. Now excel output will come in proper format.

 

 

 

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

)