Using BIP for Interactive Reconciliation Reports

Written by Bidisha Silveira

I'm going to give a little more detail on how the Interactive Financial reports David described here were put together. In 4 simple steps (with pictures!)

Step 1:

The Reconciliation Data Extract background program is submitted which collects all the data and generates an xml file

Step 2:

To view the reconciliation data we use a page built in OAFramework. The BI Publisher region to view the formatted report is embedded in this page.

When you click submit the xml file generated from Step 1 along with details of the layout template and the type of output required (eg Excel or html or pdf) is passed to the BI Publisher engine. The BI Publisher engine processes this information and displays the formatted output on the current page.



Now you are ready to go. The first report displays the summary of the Payables and

Intercompany Reconciliation Reports just got Interactive

In R12 the Advanced Global Intercompany System was introduced and one of the main goals was to make the reconciliation process more efficient. Intercompany is often the top barrier to a fast period close, because you have to be sure you eliminated it all to zero, so your parent company does not report a profit from trading internally. Fail to do this and you might go to jail, I have no legal training but when it comes to accounting irregularity I understand claiming it was an honest mistake is not much of a defense.