Oracle Analytics and AI

mchavez

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?

RVohra

• 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.