Categories
- All Categories
- Oracle Analytics and AI Learning Hub
- 34 Oracle Analytics and AI Sharing Center
- 22 Oracle Analytics and AI Lounge
- 276 Oracle Analytics and AI News
- 47 Oracle Analytics and AI Videos
- 16.1K Oracle Analytics and AI Forums
- 6.3K Oracle Analytics and AI Idea Labs
- Oracle Analytics and AI User Groups
- 99 Oracle Analytics and AI Trainings
- 16 Oracle Analytics and AI Challenge
- Find Partners
- For Partners
Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture
Expose GL Subledger Link Identifier into Financial - GL Detailed transaction for drill down into AHA
Soumen S
Rank 2 - Community Beginner
We need to drill down from GL Detailed transaction to ARE Subledgers Lines (AHA) and relationship is 1: M. One GL Detailed Line can have multiple ARE subledger aggregated into its balances. ERP column GL_SL_LINK_ID in XLA_AE_LINE and GL_LINES table maintains relationship and ERP allows functionality of drill down from GL Line to Subledger Line.
We have details available in Configurable Account Analysis however we need column exposed in Financial - GL Detailed transaction and Individua AHA subjects area that allows drill down between 2.
2 Use case provided -
Use Case # 1 – We can link GL to ARE subledger Lines when relationship is 1:1
Use Case # 2 – We can’t link GL to ARE subledger Lines when relationship is 1:M
3