how to create a bip report in ARCS/EPM easily

Summary:

A custom BI Publisher report needs to be developed, data model, or approved extract/integration is required. Oracle Fusion does not provide one standard XLA field containing a pre-calculated YTD balance by subledger source. The YTD amount must be calculated from subledger accounting transactions using XLA data, while non-subledger GL activity such as revaluation and manual spreadsheet journals must be obtained from General Ledger data.
 
 
The sample provided demonstrates that the report can be designed to fully explain the GL balance:

Source	YTD balance
Payables	-72,916.85
Receivables	-22,354.52
Cash Management	0.00
Revenue Management	-45,000.00
Revaluation	-54.12
Manual – Spreadsheet	-210,461.20
Total	-350,786.69

Recommended Approach:
Developing a source-level reconciliation extract that combines: