Oracle Fusion Data Intelligence Idea Lab

Home› Oracle Analytics› Oracle Analytics Idea Labs› Oracle Fusion Data Intelligence Idea Lab

Categories

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

Include Item Expense Account as the GL Account Combination in Financials - AP Invoices subject area

Delivered
47
Views
5
Comments
Molly P
Molly P Rank 5 - Community Champion
in Oracle Fusion Data Intelligence Idea Lab

Right now, when we select the "GL Account Combination" field from Financials - AP Invoices subject area, the natural account segment value is a liability account. We would expect this subject area to have the item expense account from the invoice line as the default account combination, as that is what users see in the fusion payables UI. Please include the item expense account combination as a field for all invoices (regardless of accounting status).

Tagged:
2
2 votes

Delivered · Last Updated

Consider using AP Expenses Subject Area or Configurable Account Analysis (CAA) where you should be able to see both Liability and Expense Account combination.

Comments

  • Jamie Anderson-Oracle
    Jamie Anderson-Oracle Admin
    edited May 10, 2024 1:53PM

    Hey Molly - check out the "GL Account Combination" field in the Financials - AP Expense subject area - you may need to play around with how the workbook is currently configured, but I think that's what you're looking for. Get back to us to let us know either way!

    Thanks

  • Paul Bordage-Oracle
    Paul Bordage-Oracle Rank 2 - Community Beginner

    Hello,

    This information of the GL counterpart account can be found in the Procurement-Spend subject area with the field "Natural Account Name" :

    image.png

    Another possibility is to activate the new subject area Configurable Account Analysis : https://docs.oracle.com/en/cloud/saas/analytics/24r1/faiae/advanced-configurations.html#GUID-17677689-FE42-459C-A3EC-1532C1FC7918

    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.

  • Molly P
    Molly P Rank 5 - Community Champion

    @Jamie Anderson-Oracle

    Hello,

    It is correct in this subject area, but we thought a subject area called "Invoice Details" might have line details as well. If it could be added, it would make for easier reporting. Thank you for the workaround.

  • Molly P
    Molly P Rank 5 - Community Champion

    @Paul Bordage-Oracle

    Thanks Paul, the natural account segment brings in the same information. It's liability account and not expense account.

    I will look into activating Configurable Account Analysis subject area as this is something I haven't heard of before. Thanks for the info!

  • Paul Bordage-Oracle
    Paul Bordage-Oracle Rank 2 - Community Beginner

    Hi @Molly P for information it works for me for the expense account :)

    image.png image.png