Categories
- All Categories
- Oracle Analytics Learning Hub
- 33 Oracle Analytics Sharing Center
- 22 Oracle Analytics Lounge
- 256 Oracle Analytics News
- 45 Oracle Analytics Videos
- 16.1K Oracle Analytics Forums
- 6.3K Oracle Analytics Idea Labs
- Oracle Analytics User Groups
- 97 Oracle Analytics Trainings
- 16 Oracle Analytics and AI Challenge
- Find Partners
- For Partners
Data Aggregation Issue with GL Data in FDI
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?
Answers
-
- 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.
0 -
Have you tried deploying Configurable Account Analysis?
Fusion ERP Analytics – How to get started on Configurable Account Analysis (CAA) feature — Oracle
0 -
Hi, yes we have tried CAA to expose AEHeaderID. However, for custom Journal sources, the data is aggregated and not broken down into journal entries.
0 -
"We need application ID and aeHeaderID for Deep link as in BIP. For custom journals the application ID and aeHeaderID columns doesn't have any data.
We have verified the data in OAX$OAC.DW_FA_GL_ACCOUNT_ANALYSIS_CF.Please suggest, if we can refer any other tables which has subledger accounting data.
0 -
This needs some expertise from Oracle Product Team. I hope you already sought help from Oracle Support.
0
