Hi Experts - Looking for your suggestions and inputs to get the link between Primary and Secondary Ledger subledger links in FDI. Thanks in advance.
@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
https://docs.oracle.com/en/cloud/saas/analytics/24r4/faiae/advanced-configurations.html#GUID-2B6FB331-FB88-485E-9A8B-802F1B95B40E
@Ram ANeni -
Link the Primary and Secondary Ledgers in Fusion Data Intelligence (FDI) using the appropriate subject areas and attributes in Oracle Financials Cloud.
Hope this helps!
Hi @Sumanth V -Oracle , Thanks for your inputs.
I'll verify and let you know if any further question.
Thanks
Ram
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.
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.
@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
https://docs.oracle.com/en/cloud/saas/analytics/24r4/faiar/24R4_ERP_CAA_List_of_Columns.xlsx