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
Hi, I'm new to OTBI & FDI and need your help. Is it possible to do a report to identify missing default expense account in FDI or OTBI? Thanks for your help.
Hi Team We are using SCM- Maintenance subject areas for reporting . We enabled the Asset related DFFs (CSE_ASSETS_B) under Data Configuration successfully but the Asset DFFs are not reflecting under Descriptive Flexfield Folder . We do not see any Asset folder even under the Descriptive Flexfield folder . Please advise if…
We made some changes in the Fusion UI, and those changes were reflected correctly in OTBI but not in FDI. To refresh the data in FDI, the Oracle support team advised me to reload the relevant functional area (Absence Management). I navigated to Application Administration → Human Capital Management, selected Absence…
Data are synchronized with Oracle HCM and I can see PN 2470, which was terminated in the past. If I add any assignment information I find no records, why?
In an analysis/report, when the Bottom Up Manager details are selected from the hierarchy, the Top Position Person record drops out. This is due to the fact that this top level position does not have a record in the Fusion table : PER_MANAGER_HRCHY_CF which is the source to load OAX$OAC.DW_MANAGER_CF_DH . The requirement…
