Fusion Accounting Hub Analytics

Fusion Accounting Hub Analytics empowers finance organizations to establish a comprehensive system of insights for accounting data. It's an add on SKU to Oracle Fusion ERP Analytics.

Accounting Hub Analytics enables you to discover meaningful correlations among balances, journals, and granular sub-ledger transaction details and supporting references. These correlations enable you to swiftly detect irregularities with end-to-end traceability.

Intelligent data pipelines source data from Oracle Fusion Accounting Hub, enabling automatic configuration of pipelines, data models, and analytics views. This data is drawn from Oracle Accounting Hub sub-ledger applications, enabling organizations to gain valuable insights from both operational and financial data.

Special Considerations

Transaction data availability in Oracle Fusion Data Intelligence is governed by the data retention policies of the Fusion Accounting Hub. The Accounting Hub Maintenance process in Fusion automatically purges processed transactions after the configured retention period. Therefore, only transactions retained in Fusion at the time of data extraction will be available in Oracle Fusion Data Intelligence For details on Accounting Hub data retention, see Accounting Hub Maintenance.

Prerequisites to Use Fusion Accounting Hub Analytics

Prior to using Fusion Accounting Hub Analytics, you must ensure that all the prerequisites are available.

Fusion Accounting Hub Analytics requires the following prerequisites:

The Oracle Fusion ERP Analytics SKU must be provisioned.
The General Ledger functional area must be activated.
Entitlements for the Accounting Hub Analytics SKU must be ready to use.

Configure Fusion Accounting Hub Analytics

As a functional administrator, configure Fusion Accounting Hub Analytics by specifying the Accounting Hub subledger applications that need to be available for analytics.

While configuring, you can see the accounting applications set up in the Fusion Accounting Hub source. Ensure that you select only the accounting hub applications set up in the Oracle Fusion Cloud Applications source with Supporting References and Journal Entry Rule Set assignment complete.

Sign in to your service as a functional administrator.
In Oracle Fusion Data Intelligence Console, click Data Configurations, and then click Custom Data Configurations.
Select Create and then select Fusion Accounting Hub.
On the Fusion Accounting Hub page, in Application Tag, enter a unique identifier for the application definition and then select the Accounting Hub subledger applications that need to be available for analytics.
Click Save and Exit to create the application definition with “Inactive” status.
On the Custom Data Configurations page, for the Fusion Accounting Hub configuration, click the Actions icon, and then click Edit to modify the Accounting Hub subledgers selection.
From the action options, click Generate to deploy the application definition that would submit the background processes.
After the Generate action is complete, select Deploy from the action options to create the Fusion Accounting Hub application related subject areas.

Accounting Hub Analytics Subject Areas

Accounting Hub - Application Transactions

Description

Using this subject area, you can analyze accounted transaction object details such as Transaction Headers and Lines for standalone operational insights or as a drill down from Supporting References, Ledger, GL Account, and Fiscal Period Combination.

Business Questions

This subject area can answer the following business questions:

How do I analyze source equivalent transactional data corresponding to the custom subledger application?
Can I drilldown to customer subledger applications transactions for a GL account combination?
Can I control access to custom subledger application data and assign it to the target functional user group?
How do I get detailed insights and access to transactional attribute information that isn't part of the accounting details for custom subledger applications?

Job-Specific Groups

The following existing job-specific groups secure access to this subject area:

Financial Analyst
General Accountant
General Accounting Manager

Duty Roles

The Accounting Hub Transaction Analysis Duty role secures access to this subject area.

Primary Navigation

Home: General Accounting

Time Reporting

Supports Transaction objects historic data.

Time dimension is linked to accounting date.

Transactional Grain

The grain is at the accounting distribution level.

Special Considerations

Subject areas are dynamically created corresponding to each individual Fusion Accounting Hub application selected. For example, if you select five Fusion Accounting Hub applications as part of configuration, the system would create five respective Transactions subject areas identifiable based on the application name.

Financials - Supporting Reference Balances

Description

This subject area provides the aggregated view of all management reporting dimensions defined as balance type supporting references for the subledger accounting.

Business Questions

This subject area can answer the following business questions:

What are the consolidated balances for individual supporting references across sources?
How do I track the balances and period activity for supporting references by journal sources?
How do I enrich the GL trial balance information by additional management reporting dimensions?
How do I track the historic trend and activity for balance type supporting references?

Job-Specific Groups

The following existing job-specific groups secure access to this subject area:

Financial Analyst
General Accountant
General Accounting Manager

Duty Roles

The Supporting Reference Balance Analysis Duty role secures access to this subject area.

Primary Navigation

Home: General Accounting

Time Reporting

Supports Transaction objects historic data.

Time dimension is linked to accounting date.

Transactional Grain

The grain is at the supporting references balances level.

Special Considerations

None

Frequently Asked Questions

Review these questions to understand the application:

What is the data refresh schedule for the Fusion Accounting Hub applications?

Data refreshes on a daily basis following the common warehouse refresh schedule.
Can I perform intraday refreshes for the Fusion Accounting Hub Analytics data?

You can perform intraday refreshes for the Fusion Accounting Hub Analytics data using the "Frequent Refresh Tables" preview feature. See Schedule Frequent Refreshes of Warehouse Tables (Preview) and Functional Areas Available for Frequent Data Refresh.
How to redo full reset and reload the of Fusion Accounting Hub data?

Use the Reset option to trigger full reset and reload the Fusion Accounting Hub data.
How do we add or remove the Fusion Accounting Hub applications' sources?

Use the Edit option to add or remove the Fusion Accounting Hub applications, followed by Generate and Deploy steps.
How to stop data pipelines for the Fusion Accounting Hub applications?

Use the Deactivate option to stop incremental data loads in Oracle Fusion Data Intelligence for the Fusion Accounting Hub applications. However, the subject area and visualizations would continue to be accessible with existing data in the datawarehouse.
How to opt out of the Fusion Accounting Hub application feature setup in Oracle Fusion Data Intelligence?
Complete these steps:
1. Use the Delete option to remove the Fusion Accounting Hub applications' definition setup in Oracle Fusion Data Intelligence.
2. Manually delete the visualizations because subject area and visualizations won't be accessible at this step.
3. Toggle off the Fusion Accounting Hub feature under the Preview Features tab on the Enable Features page.
What happens to Fusion Accounting Hub data loaded into Oracle Fusion Data Intelligence if those transactions are later purged from Fusion Applications?

Oracle Fusion Data Intelligence reflects data available in Fusion Applications at the time of load.

While loaded data remains in Oracle Fusion Data Intelligence, events like resets, reloads, source changes (such as adding applications and redeployments), or upgrades may impact data availability.

If transactions are purged from Fusion Applications, they might not reload into Oracle Fusion Data Intelligence after such events. Review your Fusion Applications retention settings and plan your extraction strategy accordingly to ensure critical data is preserved in Oracle Fusion Data Intelligence.

For details on Accounting Hub data retention, see Overview of Accounting Hub Maintenance.
How does the data model get generated for Fusion Accounting Hub in the data warehouse?
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.