Accounting Hub Reports with GL Journals

Suraj Shenoy K S

Once we enable the FAH subledgers data pipeline in FDI, how can we create a report which has columns from both the GL Journals subject area and the Accounting Hub Subledger subject area? Is there any way to traverse from GL Journal Line level to FAH subledger transaction.

Mallikarjuna Kuppauru-Oracle

Hi @Suraj Shenoy K S,

For FAH -

Data model for Fusion Accounting Hub gets dynamically generated when the Fusion Accounting Hub custom data configuration application is deployed and it consists of these tables:

• Balances fact: DW_FAH_SLA_BALANCE_CF table consists of the XLA balances data for balancing supporting references for all the sub-ledger applications along with GL segments. All the configured balancing supporting references are provided with the functional names and data type based on user configurations.
• Transactions fact: DW_FAH_SLA_<APPL_NAME>_CF table consists of the sub-ledger accounting data for each individual selected Fusion Accounting Hub application with de-normalized transactional details for headers and lines. XLA details and the corresponding supporting references both balance and non-balance type configured for an application are provided based on user configurations.
• Supporting References dimension tables: DW_FAH_<SR_NAME>_D provides the dimension details for all the configured supporting references.
• Translation tables: DW_FAH_APPLICATION_TL provide the translation details of all the sub-ledger applications.
• Application tables: DW_FAH_TABLE_COLUMN_GROUPS provides the details for the supporting references and transaction columns for the respective facts and their corresponding column groups.

Refer -

Advanced Configurations

Above are the available features/data & i am not able to see documentation is saying we can combine both GL Journals vs FAH Data as its an custom and dynamic subject area.

Regards,

Arjun

Suraj Shenoy K S

Thank you Arjun. In this blog (https://blogs.oracle.com/analytics/post/fusion-erp-analytics-adds-support-for-accounting-hub), there is a screenshot where FAH and GL columns are shown together in a single tabular view. In the dynamic subject area which got generated for our FAH app, we could not find GL Journal ID column in the FAH application subject area. Hence was curious if FAH data can be shown with GL journal information.