Drilling Through to the SAP® General Ledger in Cloud EPM

After loading data into your Oracle Fusion Cloud Enterprise Performance Management from your source SAP General Ledger using Data Integration, you can drill through the source SAP system using a URL with parameters. Required parameters not loaded to the target application may be loaded into the workbench for reference when drilling. Based on how you defined drill details, you can drill through to the Data Integration landing page, to a custom URL like a deep link, or drill directly using the EPM Integration Agent.

Drill through is activated after you define the drill region. For more information, see: Using a Drill Region.

In the example below, you have a form where trial balance data from the general ledger for several entities, which was loaded into the Singapore entity using Data Integration data from an SAP GL:

To drill through to the source data in the form, right-click a drillable cell and select Drill Through to source.

The landing page shows the details that were loaded to the target Cloud EPM application.

The system displays the data row that comprises the amount from the selected cell. View mappings to see how data was mapped to the dimensions from the source GL across the chart of account segments.

You can view mappings to see how data was mapped to the dimensions from the source GL across the chart of account segments.

From here, you can drill through and open the source system. On the SAP General Ledger page, you can see the account details and validate the numbers displayed.

For additional information, see: Drill-Through to SAP.