Categories
- All Categories
- 15 Oracle Analytics Sharing Center
- 16 Oracle Analytics Lounge
- 215 Oracle Analytics News
- 43 Oracle Analytics Videos
- 15.7K Oracle Analytics Forums
- 6.1K Oracle Analytics Idea Labs
- Oracle Analytics User Groups
- 79 Oracle Analytics Trainings
- 15 Oracle Analytics Data Visualizations Challenge
- Find Partners
- For Partners
Primary and Secondary Ledger links in Oracle Fusion

Hi Experts - Looking for your suggestions and inputs to get the link between Primary and Secondary Ledger subledger links in FDI. Thanks in advance.
Best Answer
-
@Ram ANeni You can leverage the Configurable Account Analysis feature in FDI to get the data across Ledgers and Subledgers.
Business user friendly configurations options allows setting up user defined account analysis template in order to enrich general ledger information with originating subledger transaction details through selection of enrichment attributes for the relevant journal sources.
Refer: Configurable Account Analysis
0
Answers
-
Link the Primary and Secondary Ledgers in Fusion Data Intelligence (FDI) using the appropriate subject areas and attributes in Oracle Financials Cloud.
- Use the "Financials - Balances Real Time" subject area. This contains data for both Primary and Secondary Ledgers.
- Utilize a pivot table to display financial balances for both Primary and Secondary Ledgers side by side.
Hope this helps!
0 -
Hi @Sumanth V -Oracle , Thanks for your inputs.
I'll verify and let you know if any further question.
Thanks
Ram
0 -
Hi @Sumanth V -Oracle , Thanks for your inputs. I'm good with balances across ledgers.
The customer enabled two ledgers in Fusion and the journals (Spreadsheet/Subledger) posted to both ledgers at the same time.
We have requirement to show the General Ledger Journals lines having Primary Ledger GL Account and Secondary Ledger GL Account side by side for every transaction whether it's from GL and subledgers.
Appreciate your inputs.
0 -
Hi Ashish, Thanks for your inputs. I'll have to check this and get back to you in case of any question. One question is there any way to let me know what columns used in order to populate the subledger details using configurable account analysis.
Thanks
Ram
0 -
@Ram ANeni To know the functional areas that are required to use the Configurable Account Analysis (CAA) feature with the details of columns in CAA and associated journal source, see,
Configurable Account Analysis Template - List of Columns
0