ExamFinch.com My Study

Study guide

8.5 Accounts Payable Analysis and Reporting: Landing Pages, Dashboards, Aging Periods and Key Reports

Practice this exam

Oracle Fusion Cloud Financials Payables and Expenses 2026 Implementation Professional Exam

Track your progress as you read

Finished sections get a check mark.

1 Chapter 1: Exam Overview, Enterprise Structures & Security

1.1 Exam Facts, Hands-On Format & How to Use This Guide 1.2 Enterprise and Financial Reporting Structures & the Data Security Model 1.3 Business Units and Reference Data Sets

2 Chapter 2: Master Data, Taxes & Cash Management Setup

2.1 Supplier Master Data: Profile, Addresses, Sites and Site Assignments 2.2 Supplier Controls: Registration, Income Tax Details, Site Holds and Third-Party Payments 2.3 Bank Account Master Data: Banks, Branches, Internal Accounts and Security 2.4 Transaction Tax Setup for Procure-to-Pay 2.5 Configuring Cash Management for Payables: Statements, Reconciliation Rules and Clearing

3 Chapter 3: Supplier Invoices — Options, Entry & Matching

3.1 Invoice Options and Common Options for Payables and Procurement 3.2 Supplier Invoice Processing: Invoice Types, Components and Distribution Sets 3.3 Matching Invoices to Purchase Orders, Receipts and Consumption Advice

4 Chapter 4: Supplier Invoices — Tolerances, Holds & Approvals

4.1 Invoice Validation, Invoice Tolerances, Holds and Releases 4.2 Invoice Approval Rules: Workflow, Spreadsheet Rules and Approval Actions 4.3 Prepayments, Recurring Invoices, Credit and Debit Memos

5 Chapter 5: Invoice Automation, AI & Subledger Accounting

5.1 AI in the Supplier Invoices Process: IDR, Document IO, the Payables Agent and Intelligent Defaulting 5.2 Importing Invoices: File-Based Data Import, Import Payables Invoices and Corrections 5.3 Setting Up Subledger Accounting for Payables

6 Chapter 6: Payments — Configuration

6.1 Payment Options, Payment Methods, Defaulting Rules and Payment Terms 6.2 Payment Process Profiles, Formats, Payment Systems and Transmission 6.3 Disbursement System Options, Payment Security and Payment Approval Rules

7 Chapter 7: Payments — Processing, Withholding, Accounting & AI

7.1 The Payment Process and Payment Process Request Templates 7.2 Completing Payments: Printing, Electronic Confirmation, Bank Acknowledgments, Single Payments, Stops and Voids 7.3 Withholding Tax Setup and US 1099 Reporting 7.4 Payment Accounting: Issue and Clearing, Gains and Losses, Discounts, Cross-Currency Payments and Bills Payable 7.5 AI in the Payments Process: the Payments Agent, Discount Intelligence, Virtual Cards and Fraud Controls

8 Chapter 8: Accounts Payable Balances & Period Close

8.1 Payables Calendars and Payables Accounting Period Statuses 8.2 Payables to General Ledger Reconciliation 8.3 The Payables Period Close Process: Unaccounted Transactions, Sweep and Close Exceptions 8.4 Balancing, Accruals and Year-End Activities in Payables 8.5 Accounts Payable Analysis and Reporting: Landing Pages, Dashboards, Aging Periods and Key Reports

9 Chapter 9: Expenses — Processing, Setup & Policies

9.1 Expenses Processing: From Expense Entry to Reimbursement 9.2 Expenses System Options, Expense Report Templates and Expense Types 9.3 Managing Expense Policies: Categories, Rate Determinants and Enforcement 9.4 Mileage and Per Diem Policies, Oracle Maps and Cumulative Mileage 9.5 Conversion Rate Policies, Receipt Requirements and Payment Hold Rules

10 Chapter 10: Expenses — Approvals, Cards, Advances, Audit & Travel

10.1 Configuring Expense Approval Rules in the BPM Worklist 10.2 Configuring Corporate Card Programs: Payment Options, Transaction Files and Accounting 10.3 Managing Cash Advances: Policies, Approval, Accounting and Application 10.4 Managing Audit Rules, the Expense Audit and Reimbursement 10.5 Configuring Travel Integration: Travel Partners, Itineraries and Trip Expense Reports

11 Chapter 11: AI, Mobile, Automation & Redwood

11.1 AI, Mobile and Automation in Expenses: Expense Assistant, Email Receipts and Touchless Expenses 11.2 Enabling Redwood Capabilities and Their Impact on Existing Configurations

8.5 Accounts Payable Analysis and Reporting: Landing Pages, Dashboards, Aging Periods and Key Reports

Key Takeaways Explain This Topic AI

Aging periods are defined on the Create Aging Periods page, and the Payables Invoice Aging Report shows invoices due in the four time periods you define.

Before running aging reports, create the aging periods and run Apply Missing Conversion Rates; foreign-currency invoices without rates show no amounts.

The Supplier Balance Aging Report only includes invoices that are accounted and transferred to the general ledger, so it agrees with the Payables Trial Balance.

The Payables Key Indicators Report needs a General Purpose Payables calendar and compares current activity, the state of the application and invoice entry by user.

The Payables Cash Requirement Report forecasts cash needed for a payment process request template, using its pay-through date and payment date.

Last updated: October 2026

The published objectives are Understand the Accounts Payable Analysis, Reporting, and Period Close process and Manage Aging Periods . Analysis tells you what is owed, how old it is, and what needs attention before the close.

Landing pages and the Payables Dashboard

The Invoices landing page shows infotiles for the work queue. The Scanned tile counts incomplete and not-validated scanned invoices grouped by age (0–7, 8–14 and 15+ days), and the Recent tile counts validated invoices. From the page you can:

  • Release holds;
  • run Create Recurring Invoices ;
  • open Correct Import Errors ;

run validation and other common actions.

The Payments landing page shows payment process requests and files needing attention. Its Requiring Attention tab includes requests waiting for payment approval. It also lists Supplier Sites on Payment Hold .

The Payables Dashboard gives a quick view of the AP position and pending work:

  • holds you can release;
  • stop payment requests, with a Void Payment button in that section;

for reconciliation, the Business Unit filter applies to the Payables column and the Account filter to the Accounting column.

For self-service analysis, Oracle Transactional Business Intelligence (OTBI) provides real-time subject areas. Examples Oracle uses in its reports:

  • Payables Invoices – Transactions Real Time ;
  • Payables Invoices – Trial Balance Real Time ;

Subledger Accounting – Payables Summary Reconciliation Real Time , behind the Payables to Ledger Reconciliation report.

Aging periods

Aging reports group open installments into aging buckets . You define them on the Create Aging Periods page:

an aging period name , chosen as a report parameter;

the time periods (buckets) , each with a day range relative to the installment due date.

The Payables Invoice Aging Report shows invoices due within the four time periods defined for the aging period. A typical setup has buckets for current, 1–30, 31–60 and over 60 days past due.

Before running aging reports:

Create the aging periods on Create Aging Periods.

Run Apply Missing Conversion Rates . Foreign-currency invoices without rates won't show amounts . With multiple currencies, the report converts to the ledger currency.

Payables Invoice Aging Report parameters

  • Parameter Effect
  • Business Unit Required scope
  • Sort Invoices By Invoice type or trading partner
  • Include Invoice Detail Yes lists each invoice; No summarizes per supplier
  • Include Supplier Site Detail Yes lists sites; No lists supplier names
  • Minimum / Maximum Amount Due Filters by amount
  • Invoice Type For example Standard or Credit memo; leave blank for all
  • Supplier or Party One supplier
  • Aging Period The aging period from Create Aging Periods

Oracle notes that the report only covers suppliers where you hold the primary liability . Run for a third-party (remit-to) party, it returns no data.

Supplier Balance Aging Report

The Supplier Balance Aging Report also uses the aging periods, but it works as of any date and only includes invoices accounted and transferred to the general ledger . Its balances therefore match the trial balance . Run Create Accounting with transfer first. Its Unallocated Amount column flags data to investigate:

  • amounts outside the defined buckets;
  • invoice and installment outstanding amounts with opposite signs;

payments larger than the invoice, for example when distributions have different accounting dates and the invoice was paid between them.

Other key Payables reports

  • Report Purpose Notes
  • Payables Trial Balance Open liability by supplier as of a date Basis for reconciliation (section 8.2)

Payables Key Indicators Current Activity (this period compared with the previous one), State of the Application (a snapshot at period end) and Invoice Activity by entry user Needs a General Purpose calendar from Manage Payables Calendars. Run weekly or monthly for productivity, quarterly for trends.

Payables Cash Requirement Forecasts the cash needed for a PPR Based on a PPR template and the payment business units you can access. Parameters include pay-through date and payment date. Run it before each PPR, or for the next two or three to forecast.

Payables Negative Supplier Balance Suppliers whose balance is negative, with the transactions behind it Can reveal missing standard invoices or advances never invoiced. Uses the Trial Balance and Transactions real-time subject areas.

Payables Matching Hold Detail and Matching Detail Matching holds and how invoices matched POs and receipts Supports hold resolution

  • Payables Invoice Audit Listing Invoices entered, for audit sampling
  • Payables Payment Register and Selected Installments Payments made, and installments selected by a PPR
  • Update Matured Bills Payable Status Matures bills payable whose maturity date has arrived A close step
  • Agentic analysis: Payables Period Close Workspace

Oracle's AI feature list shows a Payables Period Close Workspace as an agentic application in update 26D. It is part of Oracle's direction to bring close exceptions, reconciliation and AI-driven guidance into one workspace. Treat it as an extension of the same reports and processes. Oracle's close checklist (section 8.3) still defines what must be complete before a period can close.

How analysis feeds the close

A practical weekly rhythm:

Use landing-page tiles and the Dashboard to clear holds and incomplete scanned invoices.

Run the Cash Requirement report against the next PPR template.

At month end, run Invoice Aging and Supplier Balance Aging for the liability profile.

Then complete the close and reconciliation in sections 8.2 and 8.3.

Loading diagram...