While working on Oracle fusion SaaS, there will be times you may need to customize standard BI Publisher report for your customer needs. Customizing the BIP report process is uniform across ERP Cloud, HCM Cloud, or CX Cloud.
While modifying the rtf template is relatively easier but when it comes to modify the Data model, sometimes we see it getting very complex.
In this post we will see and example of modifying an Invoice print template in fusion
The invoice print report can be run from the invoice screen as well as from the Scheduled process program.
To Run ,
Login with receivables user > Navigator > Receivables > billing
query the receivables transaction number > Click on transaction number hyperlink > View Image.
The ESS job name is Print Receivables Transaction which in turn call child processes
Print Receivables Transactions: Invoices.
How to customize standard BI Publisher reports in Oracle Fusion?
Time to do 4 hours
To Identify the BIP Report go to Functional setup manager > Manage Enterprise Scheduler Job Definitions and Job Sets for Financial, Supply Chain Management, and Related Applications> Query the report name “Print Receivables Transactions: Invoices” and get the xdo file name . (here defaultInvoice.xdo)
Navigate to the catalog folder here Shared Folders /Financials / Receivables / bill Presentment
Do the changes in report and save in same path of ‘CUSTOM’ folder.
For Data model change you need to do the same thing, Copy the data model of standard report and place in the same path of custom folder. After placing in custom folder the Data model becomes editable else it won’t allow to edit.
Also download the Layout template for local editing in BIP Desktop
While editing the data model you may be asked to enter parameter value to test the Report DM.
Enter the values
To get the parameter value syou should run the ESS job and see the output of the program in parameters. All the argument values would be visible.
In the Completion report of ESS job you can see the XML Data available for download as well. This xml can be used to test the modified RTF in local BI Publisher Desktop MS Word version.
Test the report locally with the xml data downloaded from previous step
Once you have the Report tested locally , Upload to the custom folder in fusion SaaS. Make sure you are using the right user with BI administrator roles.
Another frequent requirement is to add an image in a BIP report from Fusion UCM . For this check out this post
You can Run the ESS job and see the option to download xml in the ESS request screen.
You need to create a duplicate Data model and put in Custom folder where it will allow to Edit. The Data models are in readonly in standard folders
It’s a time-consuming process, you need to get the SQL and run it against the database using trial and error for now.
See more Fusion Apps Tech posts
If you are preparing for BIP interview do check out Interview questions on BIP
Oracle documentation on customization of BI Publisher Reports