Categories
- All Categories
- 75 Oracle Analytics News
- 7 Oracle Analytics Videos
- 14K Oracle Analytics Forums
- 5.2K Oracle Analytics Idea Labs
- Oracle Analytics User Groups
- 40 Oracle Analytics Trainings
- 59 Oracle Analytics Data Visualizations
- 2 Oracle Analytics Data Visualizations Challenge
- 3 Oracle Analytics Career
- 4 Oracle Analytics Industry
- 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