How to Customize Standard BI Publisher Report

Customize Standard BI Publisher Report

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

Ex. On How to Customize Standard BI Publisher Report [Print Receivables Transactions]

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.

image 34 Customize Standard BI Publisher Report 1

How to customize standard BI Publisher reports in Oracle Fusion?

Time to do 4 hours

  1. Identify the BI Publisher Report

    image 24 Customize Standard BI Publisher Report 2

    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)

  2. Go to BI Admin and Edit the Report

    image 26 Customize Standard BI Publisher Report 3

    Navigate to the catalog folder here Shared Folders /Financials / Receivables / bill Presentment

  3. Do the Changes to Report

    Do the changes in report and save in same path of ‘CUSTOM’ folder.
    /Custom/Financials/Receivables/Bill Presentment/DefaultInvoice.xdo

  4. If Data Model Change is required

    image 28 Customize Standard BI Publisher Report 4

    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

  5. Edit and Test the Data Model

    image 29 Customize Standard BI Publisher Report 5

    While editing the data model you may be asked to enter parameter value to test the Report DM.
    Enter the values

  6. How to Get the parameter values for the previous step

    image 30 Customize Standard BI Publisher Report 6

    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.

  7. Get the XML of the Report

    image 31 Customize Standard BI Publisher Report 7

    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.

  8. Test the Report Locally

    image 32 Customize Standard BI Publisher Report 8

    Test the report locally with the xml data downloaded from previous step

  9. Upload to Fusion in Custom Folder

    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

FAQs on BIP Report Customization

How to Get the XML data of a Standard BIP Report?

You can Run the ESS job and see the option to download xml in the ESS request screen.

How to Edit the BIP Data model?

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

How to fill the lexical parameters while testing the Data model?

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

Useful links

BIP-Best-Practices-for-SaaS-Environments

Oracle documentation on customization of BI Publisher Reports

wpsadmin
We will be happy to hear your thoughts

Leave a reply

Ads Blocker Image Powered by Code Help Pro

Ads Blocker Detected!!!

We have detected that you are using extensions to block ads. Please support us by disabling these ads blocker.

Powered By
Best Wordpress Adblock Detecting Plugin | CHP Adblock
Cloud Technologies Blog
Logo
Compare items
  • Total (0)
Compare
0
Shopping cart