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: This AI-enabled AP Payments analytics workbook provides on-time payment performance metrics and period-based
trend analysis.
Application: Fusion ERP Analytics
Fusion Module: Accounts Payable
Target Persona: Finance Manager, Accounts Payable Manager, Accounts Payable Specialist, Accounts Payable Invoice Supervisor, Controller
Subject Areas: Financials - AP Payments, Financials - AP Payments LSA
Business Use Case/Questions:
- What is the total payment amount by business unit for current fiscal year?
- List all suppliers by payment amount
- Show me the top 5 Supplier Payments?
- Show me the top 5 Payments by Supplier Site
- What is the payment distribution amount by account class for current fiscal year?
- Can you show overdue payments amount by vendor?
- What is the total payments amount by payment method?
- Which payment documents and amounts have been voided?
- What is the breakdown of payment distribution amount by GL account combination?
- How much discount was taken for this fiscal year.
- Can I get payment details with payment amounts, document numbers and invoices for last year in a table
- What is the total payment amount by Disbursement Bank Account for Payments that are not cleared? As a table
- How many paid payments were processed for each disbursement bank account?
- What is the average supplier payment days for each business unit?
- Which payment documents have the largest amounts for last 3 years?
- List all on-time and overdue payments for this year
- Show me the Supplier, invoice Number, payment amount that are paid?
- What is the amount of interest penalties paid for each supplier for last year?
- What are the On time payments count by supplier?
- Show payments amount processed last year by Disbursement Bank Account and Payment Currency
- Which suppliers have the highest total payments amount last year?
- What is the total amount of interest penalties paid for each supplier for last year?
- Show me the payments made in last year by supplier site country and supplier site city as a table
- How do the interest penalties paid breakdown across different business units last year?
- Which payment documents incurred the highest penalty amounts for last year?
- How many payments were processed in each payment currency?
- Can you provide a summary of discount taken by supplier site this year?
- Display monthly Trend of Overdue and On Time Payments
- What is the total payment amount by Balancing Segment/Natural Account for last 2 years? Include Balancing
Segment/Natural Account description. - Show me the number of cancelled payments
Pre-Requisites:
- Fusion Data Intelligence Release: 26.R2 or higher
- Ensure the relevant FDI application and functional area below is activated in your FDI instance
- Application: Fusion ERP Analytics
- Functional Area: Accounts Payable
Download: Available in the FDI Content Library.
We’d love to get your feedback and business use cases to help build more sample FDI content