Setting up Ledger Correlation using Oracle GoldenGate

Reconcile ledger information available in your Oracle E-Business Suite and Oracle Fusion Applications using Oracle GoldenGate.

If you are analyzing data sourced from Oracle E-Business Suite and Oracle Fusion Applications and are using the Fusion GL Accounting feature, then you can drill in analyses from Fusion GL balances to related detailed EBS ledger information. This ledger correlation is supported by Oracle GoldenGate replication, and requires Oracle GoldenGate configuration on your source systems.

After setting up the required Oracle GoldenGate configurations on the sources, you need to expose the following Presentation columns in the applicable reports to support drilling:

Target GL Account ID for GL Account of subject area Financials – GL Balance Sheet.
Target Ledger ID for Ledger
Target Fiscal Period ID for Time
Dim – Ledger.Source ID (Data Source Num ID)

For information about working with Presentation columns, see Creating and Maintaining the Presentation Layer, Metadata Repository Builder's Guide for Oracle Business Intelligence Enterprise Edition.