Oracle Fusion ERP Analytics

Home› Oracle Analytics› Oracle Analytics Forums› Oracle Fusion Data Intelligence› Oracle Fusion ERP Analytics

Categories

Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture

Fusion ERP Analytics – How to get started on Configurable Account Analysis (CAA) feature

945
Views
9
Comments
Sushil Dhoot-Oracle
Sushil Dhoot-Oracle Mod
edited March 17 in Oracle Fusion ERP Analytics

Summary :

This post provides a subject area template and a prebuilt DV workbook content to get started on Configurable Account Analysis feature.

Prerequisites :

General Ledger, Account Payable and Account Receivable functional areas should be active to use this template.

It is important to note that when you are configuring CAA as a replacement to GL Account Analysis, you only need to select Payables and Receivables journal sources in CAA template.

Minimum product version should be 24.R2.P2 to use CAA bundles feature.

Content :

Configurable Account Analysis (CAA) is a cross finance self-service advanced capability for Oracle Fusion ERP Analytics.

It enables functional administrators to define a comprehensive account analysis template which can combine data across general ledger and multiple subledger sources.

Business users get the ability to do the end to end analysis for GL and subledger accounting data, drill down into account activity, analyze the transaction details on historic basis.

To know more about CAA, refer https://docs.oracle.com/en/cloud/saas/analytics/24r2/faiae/advanced-configurations.html

To enable CAA subject area feature and use prebuilt content, refer the steps in the document below,

CAA Subject Area Setup.pdf

Download links for the artifacts in this post:

CAA template subject area bundle :

(use Unarchiver or 7-zip utility to unzip the file)

(Use this updated bundle after 24.R2 platform release)

CAA_for_GL_Account_Analysis_21.5.aab.zip

Prebuilt DV workbook based on CAA template subject area :

New Configurable Account Analysis.dva

Snippets:

CAA subject area outline :

image.png

Note: CAA template can be conveniently modified at any stage to add subledger attributes for areas like Projects, Assets, Cost Accounting, Receipt Accounting, DFFs, etc. To know more about how to modify CAA subject area refer, https://docs.oracle.com/en/cloud/saas/analytics/24r2/faiae/advanced-configurations.html#GUID-0C52C00A-0464-45AA-867E-46F718AA2165

Prebuilt analysis :

image.png

Tagged:

Comments

  • Gautham B
    Gautham B Rank 1 - Community Starter

    Hi,

    getting below error.

    'Bundle validation failed. CAA Validation Failed. Application modules missing in target.'.

    We have published all offerings under ERP and enabled all featires.

    Can you please let us know what could be the issue?

    Thanks,

    Gautham

  • Francisco Mtz.
    Francisco Mtz. Rank 1 - Community Starter

    Hi Gautham B

    I hope you're doing well.

    We encountered the same error:
    "Package validation failed. CAA validation failed. Application modules are missing from the destination."

    I wanted to check if you were able to resolve this issue on your end. If so, could you kindly share the steps or solution you applied?

    Looking forward to your response.

    Thanks

    Regards

    Francisco

  • JohnW-Oracle
    JohnW-Oracle Rank 6 - Analytics Lead

    Hello @Gautham B and @Francisco Mtz.

    Sometimes this is just a UI issue. Could you check to see if the CAA subject area is available and reports are working for CAA?

    Regards,

    John

  • Bhaskar Konar
    Bhaskar Konar Rank 8 - Analytics Strategist

    Very informative & very helpful information.

    Thank you very much @Sushil Dhoot-Oracle! Much appreciated all your kind help.

    Cheers,

  • Molly P
    Molly P Rank 4 - Community Specialist

    Hi @JohnW-Oracle amd @Sushil Dhoot-Oracle

    Is there any solution for this error when importing the subject area bundle:

    'Bundle validation failed. CAA Validation Failed. Application modules missing in target.'

    I am having the same issue as @Gautham B above.

    Thanks,

    Molly

  • Krishna Prasad Kotti-Oracle
    Krishna Prasad Kotti-Oracle Mod
    edited March 13

    Hi Molly,

    Can you review the Functional areas that were activated and make sure they are same in Dev and Prod.

    Also check the DFF's (if selected in CAA template) are same in Dev and prod.

  • Molly P
    Molly P Rank 4 - Community Specialist

    Hi @Krishna Prasad Kotti-Oracle

    The same functional areas are activated in dev and prod, but I inactivated Account Analysis in dev as part of the steps to enable CAA. Therefore dev does differ from prod as I'm testing this feature in dev first.

    I cannot tell if DFFs are selected in the CAA template. I got the file from this post, how can I check? Also there are some supplier DFFs in dev that are not in prod because we haven't migrated them to production.

    Do these conditions need to be met in order for this to work? How are we expected to test it first in dev?

    Thanks, Molly

  • Krishna Prasad Kotti-Oracle
    Krishna Prasad Kotti-Oracle Mod

    Hi Molly

    I kindly request you to log a Service request and work with the support Team. They can review the setups and provide you with the guidance.

  • Sushil Dhoot-Oracle
    Sushil Dhoot-Oracle Mod

    @Molly P @Gautham B - Please retry configuring the CAA template using the updated bundle below. This should resolve the error you were facing.

    Thanks for using idea labs for your query.

    CAA_for_GL_Account_Analysis_21.5.aab.zip