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.
- GL Account Analysis subject area
- GL Account Analysis Foundations
- Configurable Account Analysis (limited availability feature prior to platform release 23.R3)
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.
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.
Modify Configurable Account Analysis Subject Area Definition
Modify the Configurable Account Analysis subject area definition to update the journal sources and attributes.
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
- 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
- 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
- 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.