Setting up Ledger Correlation using 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 GoldenGate replication, and requires GoldenGate configuration on your source systems. For information about setting up GoldenGate on EBS and Fusion Applications, see: Configuring Oracle GoldenGate to Integrate the E-Business Suite General Ledger with Fusion Accounting Hub, My Oracle Support Document 1324692.1.

After setting up the required 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, Fusion Middleware Metadata Repository Builder's Guide for Oracle Business Intelligence Enterprise Edition.