Oracle Fusion Data Intelligence

Home› Oracle Analytics› Oracle Analytics Forums› Oracle Fusion Data Intelligence› Oracle Fusion Data Intelligence

Categories

Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture

Data Aggregation Issue with GL Data in FDI

Received Response
14
Views
1
Comments
mchavez
mchavez Rank 1 - Community Starter
in Oracle Fusion Data Intelligence

We have created a GL subledger report in FDI that retrieves journal information. However, the data appears aggregated, and we cannot view detailed entries.

For example:

  • In BIP, a single journal line generates 356 distinct rows, each with a unique aeHeaderId.
  • In FDI, the same journal line shows only one aggregated line.

The challenge:

  • We are unable to include aeHeaderId for custom journal sources in FDI.

Question:
Is there a way to bring aeHeaderId into FDI for custom journal sources or otherwise replicate the detailed view that BIP provides?

Tagged:

Answers

  • RVohra
    RVohra Rank 6 - Analytics & AI Lead
    • If FDI is using a pre-built view or a standard query, consider creating a custom SQL view or query that returns the detailed rows, including the aeHeaderId, for the custom journal sources.
    • You can create a custom SQL query in FDI that pulls the data at the journal line level rather than aggregating it, and specifically include the aeHeaderId field in the SELECT statement.