Oracle ETEXT Template Report Output showing special Character ‘??’ or UTF-8 symbol in the report

Problem:

We face an issue when we extract Item details using etext template .txt file. We check that the following item includes a special character.

Original Item: DC24V M27×1.5-A

Output Report Item Text: DC24V M27ױ.5-B

Resolution:

When we design a RTF template at the time we need to define <OUTPUT CHARACTER SET> Property  ‘UTF-8’

After printing this Etext template you need to update on the application and try to run the report and check.

Now report giving property output as expected.

Output:

 

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

)