This post shares Fusion ERP Analytics sample content as part of Oracle Fusion Data Intelligence (FDI), a family of prebuilt, cloud-native analytics applications for Oracle Fusion Cloud Applications. These sample artifacts are intended to demonstrate potential use cases, accelerate implementation efforts, and provide examples of how customers can extend and customize FDI content to meet their business needs. To explore additional reusable sample content, visit the FDI Content Library.
Content Description: AI-enabled AP Aging Analysis helps accounts payable and treasury teams see what the organization owes suppliers and what is overdue, through natural language interactions that make analytics more intuitive and accessible.
Users can ask questions conversationally and instantly see total outstanding and overdue payables, how balances are spread across aging buckets, which suppliers carry the most exposure, what is due in the next 30 days, and how balances have moved over recent periods. Supplier and installment risk deciles highlight where late payment is most likely. This workbook enables analysis by Supplier, Supplier Type, Business Unit, Legal Entity, Ledger, Aging Bucket, Payment Terms, Payment Method and Time. This analysis uses Ledger Currency.
Application: ERP
Fusion Module: Payables
Target Persona: Accounts Payable Manager, Payables Specialist, Treasury Manager, Controller, CFO
Subject Areas: Financials – AP Aging
Business Use Case/Questions:
● Who are the top 10 suppliers by overdue amount?
● What is the total outstanding payables balance for <Business Unit>?
● How many invoices are overdue for the current period?
● How much is due in the next 30 days?
● What percentage of the payables balance is overdue?
● What is the aging amount by aging bucket for the current period?
● Which suppliers have balances aged over 3 months?
● Show aging amount and invoice count by supplier and aging bucket for <Business Unit>
● Show total outstanding and overdue amounts by business unit
● What is the overdue amount by payment terms?
● How did the payables balance move this period (opening, activity, closing)?
● Show overdue amount for the trailing 6 periods
● Which suppliers are in the highest supplier risk decile?
● Show the outstanding amount by schedule risk decile
Best Practices:
● Balances are point-in-time for each fiscal period. When no period is named, the AI Agent uses the current period and does not sum balances across periods — this is expected behavior.
● All amounts are in ledger currency. The Ledger Name dashboard filter is passed to the AI Agent, so select the ledger first to scope agent responses.
● Aging buckets are calculated on a schedule date basis. Keep a single Aging Period Name (for example, Monthly Aging Periods) selected to avoid double counting across aging definitions.
● The AI Agent answers from payables aging data only and declines questions on payments made, discounts taken, invoice holds or Days Payables Outstanding — this is expected behavior.
Pre-Requisites:
- Fusion Data Intelligence Release: 26.R2 or higher
- Ensure the relevant FDI application and functional areas are activated in your FDI instance
- Application: Fusion ERP Analytics
- Functional Area: Payables
- User has permissions to import workbooks and agents
Download and Installation Steps: Available in the FDI Content Library.
We’d love to get your feedback and business use cases to help build a more sample FDI content.
