The Oracle Fusion Query Vault
A Treasure Trove of Oracle Fusion Queries - Ready for Live Reporting in
BI Publisher or BI Connector with Power BI or Tableau.
| Report Name | Description |  Modules | Download |
|---|---|---|---|
 GL Reconciliation Report | Summarizes GL balances by ledger, currency, period, and full COA (with segment descriptions): begin balance, period activity, and ending balance—ideal for account reconciliation. | Finance General Ledger (GL) |   |
| AR Aging Summary Report | Customer-level AR aging summary showing outstanding vs total invoice amounts across Current, 0–30 … >360 day buckets, with customer status, account number, credit limit, and client group. Supports aging by Invoice Date or Due Date. | Finance Account Receivables (AR) | |
| AP Aging Detailed Report | Detailed AP aging of open payables by Invoice Date or Due Date with configurable bucket ranges (e.g., 0–30/31–60…). Includes invoice/vendor/site, BU/Legal Entity, currency, amount remaining, prepayment advances, and MSME fields. | Finance Account Payable (AP) | |
| AR Aging Detailed Report | Customer-level AR aging with outstanding amounts bucketed by Invoice Date or Due Date (Current, 0–30 … >360). Includes BU, receipt method, transaction type, and other filters. | Finance Account Receivables (AR) | |
| Supplier Balance Report | Vendor ledger view for Oracle Fusion Payables showing each supplier’s invoices, prepayments, and payments with debit/credit, PAN/UTR, site, BU, currency, and running balance for a selected date range. | Finance Account Payable (AP) | |
| AP Accrual Report | View purchase receipt accruals in Oracle Fusion Payables—item, supplier, PO, quantity, and unit price—while calculating inventory value, PPV, and freight absorption with ASN/waybill and expected receipt dates. | Finance Account Payable (AP) | |
| AR Register Report | List AR invoices with invoice/GL dates, customer & sites, BU, amounts, tax rate, GL code, payment terms, status, and credit reasons. | Finance Account Receivables (AR) | |
| Cash Receipt Summary | Summarize AR cash receipts with amounts, unapplied/on-account balances, currency, BU/legal entity, customer, receipt method, GL/receipt dates, and application details. | Finance Account Receivables (AR) | |
| FA Register Report | Oracle Fusion Fixed Assets Register showing asset book, category, cost, net book value, depreciation (reserve/YTD/current/adjustments), GL accounts, location/LOB, custodian, project links, and USD-converted values by period. | Finance Fixed Assets (FA) | |
| Cost Rollforward Detail | Detailed Oracle Fixed Assets Cost Rollforward showing beginning cost, additions, adjustments, transfers, reclasses, retirements, depreciation and ending cost summarized by asset, category, company, department and cost account for a selected period range. | Finance Fixed Assets (FA) | |
