Advanced Configurations

10 Advanced Configurations

Configurable Account Analysis

Configurable Account Analysis (CAA) is a cross finance self-service advanced capability in Oracle Fusion Analytics Warehouse that enables functional administrators to define the comprehensive account analysis template combining data across general ledger and multiple subledger sources right from the initial extract date.

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. As a functional administrator, you can configure the account analysis template to build the account analysis reports in Oracle Fusion ERP Analytics. This is a one-time configuration that enables setting up bespoke account analysis subject area. You can make additions and changes to this subject area by modifying the template definition.

Important Considerations While Using Configurable Account Analysis

While using Configurable Account Analysis (CAA), note these:

To opt out of the Configurable Account Analysis feature, use Delete option available on the CAA template setup. This removes the CAA data extracts and CAA subject area from Oracle Fusion Analytics Warehouse. On the Enable Features page, under the Generally Available Features tab, disable Configurable Account Analysis.
You can define a single CAA template with maximum of 200 columns. For any changes, refer to Modify Configurable Account Analysis Subject Area Definition.
You can deploy the CAA template definition in another instance using the Data Config Bundle. While creating the data config bundle, under Custom Data Configurations, select your CAA application. See Create a Bundle.
CAA supports curated list of attributes available for user selection. Adding attributes through semantic model extensions, data augmentation isn't a supported functionality in the current version of CAA. Additional attributes like descriptive flexfield is part of the feature roadmap.
CAA is a cross finance feature where user gets the ability to combine accounting details from multiple subledger sources. Cross subject area analysis combining CAA with other subject areas isn't a recommended usage.

Prerequisites to Setting up Configurable Account Analysis

Ensure that these prerequisites are in place:

Prior to configuring the account analysis template application release, ensure that you’ve activated the General Ledger functional area and subledger-specific functional areas. See Activate a Data Pipeline for a Functional Area.
This feature is supported for minimum application release version 23.R3.P2.

Enable Configurable Account Analysis

Prior to configuring the account analysis template to build the account analysis reports in Oracle Fusion ERP Analytics, you must enable it.

You can't use the Configurable Account Analysis feature in parallel with other existing account analysis features. See Configurable Account Analysis Transition Steps. These steps are applicable if you had already enabled either or a combination of the following features:

GL Account Analysis subject area
GL Account Analysis Foundations
Configurable Account Analysis (limited availability feature prior to platform release 23.R3)

Sign in to your service as a functional administrator.
In Oracle Fusion Analytics Warehouse Console, click Enable Features, and then click Generally Available Features.
Under the Generally Available Features tab, select the toggle to enable Configurable Account Analysis.

Set Up Configurable Account Analysis Subject Area

Set up the Configurable Account Analysis subject area to build the account analysis reports in Oracle Fusion ERP Analytics.

The ability to extend journal sources drives what sources need subledger accounting and originating transaction details. Option to select enrichment attributes is available only for those journal sources where functional area is available in Oracle Fusion Analytics Warehouse.

Extend Journal Sources Configuration Options	View Journal Details	View Subledger Accounting Details	View Transaction Details
For the selected journal source corresponding functional area is enabled	Yes	Yes	Yes
For the selected journal source corresponding functional area isn't enabled or not supported	Yes	Yes	No
For the non-selected journal sources, GL only journal sources, custom journal sources	Yes	No	No

Note:

"Extend Journal Sources" configuration doesn't restrict journals data.

After you publish the configurable account analysis template, Oracle Fusion Analytics Warehouse extracts the data along with the additional attributes to the Configurable Account Analysis subject area. This subject area is available for users based on the access through the General Ledger Account Analysis duty role.

Sign in to your service as a functional administrator.
In Oracle Fusion Analytics Warehouse Console, click Reporting Configuration under Application Administration.
On the Reporting Configuration page, under the Advanced tab, click Configurable Account Analysis and then click Create.
In Create an Account Analysis Subject Area, in New Subject Area Name, enter a name for the subject area such as Configurable Account Analysis and provide a brief explanation in Description.

Note:
Avoid using prebuilt subject area names like "Financials - GL Account Analysis" as it isn't supported.
Under Extend Journal Source, select the journal sources like Payables, Receivables, Project Accounting, Assets, Cost Accounting, as applicable and then click Next.
From the list of attributes available in the template, select the required attributes for reporting and click Next.
On the Configurable Account Analysis page, click the Actions menu for the account analysis subject area template that you created, and click Publish.

Modify Configurable Account Analysis Subject Area Definition

Modify the Configurable Account Analysis subject area definition to update the journal sources and attributes.

Sign in to your service as a functional administrator.
In Oracle Fusion Analytics Warehouse Console, click Reporting Configuration under Application Administration.
On the Reporting Configuration page, under the Advanced tab, navigate to the Configurable Account Analysis template that you already set up and click Edit.
On the Configurable Account Analysis page, click the Actions menu for the account analysis subject area template that you edited, and click Publish.
To reset, deactivate, or refresh data for a CAA application, click Data Configurations on the Console, click Custom Data Configurations, and then click the Reset or Deactivate, or Refresh Data option for the applicable CAA application.

Configurable Account Analysis Transition Steps

Learn how to transition from a previously enabled version of Configurable Account Analysis (CAA) to the current version.

For the instances where you enabled CAA (Limited Availability) feature prior to release 23.R3

With the auto upgrade to 23.R3 platform release, the existing CAA reports continue to function as it is, however, the CAA setup template is no longer available in Advanced Reporting Configurations and the CAA subject area won't be available in the list of subject areas till the upgrade to 23.R3.P2 application release is complete. With the 23.R3 platform release, the limited availability version of CAA won't be supported by Oracle. The recommendation is to transition to the generally available version of CAA using the following steps:

Save the visualization projects created using CAA (Limited Availability) feature as a backup.
Upgrade to the 23.R3.P2 application release.
Deactivate the Account Reconciliation functional area to stop the pipeline jobs for this feature.
On the Enable Features page, under the Generally Available Features tab, enable Configurable Account Analysis.
Navigate to the CAA template that's already setup, select Edit, review the extend journal sources selection, Save, and then Publish the CAA template. Edit and republishing the template transitions to the generally available version of CAA (mandatory). After you republish the CAA template, the CAA reports will continue to function as earlier. The CAA set up template and CAA subject area will be available.

For the instances where you enabled the Account Analysis Foundations (Preview) feature prior to release 23.R3

With the auto upgrade to 23.R3 platform release, Account Analysis Foundations is no longer available on the Enable Features page for activation. The recommendation is to transition to the generally available version of CAA using the following steps:

Upgrade to the 23.R3.P2 application release.
Deactivate the Account Analysis Foundations functional area to stop the pipeline jobs for this feature. After deactivating, the existing reports will continue to be accessible. The Account Analysis Foundations subject area won't be available in the list of subject areas.
On the Enable Features page, under the Generally Available Features tab, enable Configurable Account Analysis. After enabling the CAA feature, you can't reactivate the Account Analysis Foundations functional area.
Configure the CAA template and define visualization analysis based on the CAA subject area. See Set Up Configurable Account Analysis Subject Area.

For the instances where you enabled the GL Account Analysis subject area

The GL Account Analysis subject area will be deprecated in future releases. The recommendation is to transition to the generally available version of CAA using the following steps:

Upgrade to the 23.R3.P2 application release.
Deactivate the Account Reconciliation functional area to stop the incremental data loads for the GL Account Analysis subject area. After deactivation, you can't reactivate the Account Reconciliation functional area. The GL Account Analysis subject area won't be available in the list of subject areas. The existing visualization analyses will still show data as long as data warehouse isn't reset, but incremental data won't be loaded.
On the Enable Features page, under the Generally Available Features tab, enable Configurable Account Analysis.
Configure the CAA template and define visualization analysis based on the CAA subject area. See Set Up Configurable Account Analysis Subject Area.
The existing visualization reports set up using the GL Account Analysis subject area aren't redirected to CAA. You must manually set them up using the CAA subject area.