Primary and Secondary Ledger links in Oracle Fusion

Ram ANeni

Hi Experts - Looking for your suggestions and inputs to get the link between Primary and Secondary Ledger subledger links in FDI. Thanks in advance.

Ashish-Oracle

@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

Sumanth V -Oracle

@Ram ANeni -

Link the Primary and Secondary Ledgers in Fusion Data Intelligence (FDI) using the appropriate subject areas and attributes in Oracle Financials Cloud.

1. Use the "Financials - Balances Real Time" subject area. This contains data for both Primary and Secondary Ledgers.
2. Utilize a pivot table to display financial balances for both Primary and Secondary Ledgers side by side.

Hope this helps!

Ram ANeni

Hi @Sumanth V -Oracle , Thanks for your inputs.

I'll verify and let you know if any further question.

Thanks

Ram

Ram ANeni

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.

Ram ANeni

https://community.oracle.com/products/oracleanalytics/discussion/comment/63904#Comment_63904

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

Ashish-Oracle

@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