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 |
|---|---|---|---|
 Cost Rollforward Summary | The Cost Rollforward Summary Report in Oracle Fusion provides a consolidated view of asset balances. It summarizes beginning cost, additions, adjustments, transfers, reclassifications, retirements, ending cost, and depreciation across categories, companies, and departments. | Finance Fixed Assets (FA) |   |
| Budget vs Actuals | The Budget vs Actuals Report in Oracle Fusion Projects provides a detailed comparison of approved budgets against actual project expenditures, commitments, and invoices. It helps monitor financial control and project performance. | Finance Project | |
| Inventory Onhand Quantity Report | Real-time on-hand stock by item, organization, lot, and subinventory. Sums primary & secondary quantities with filters for organization code and item number. | SCM Inventory |  |
| Transfer Orders data Report | Line-level view of inter-org transfer orders by item, showing UOM, status, requested/shipped/received/delivered quantities, shipment and receipt details, with filters for organization and item. | SCM Order Management | |
| Customer Balance Report | Consolidated AR Customer Balance Report for Oracle Fusion—combines invoices, receipts (applied/unapplied), credit/debit memos and adjustments to show debits, credits, and net balance by customer, site, and BU across a date range. | Finance Account Receivables (AR) | |
| AP Aging Summary Report | Summarize outstanding payables by supplier and dynamic aging buckets (30/60/90/120+), with options to age by invoice date or due date and include prepayments—built for Oracle Fusion Payables. | Finance Account Payable (AP) | |
| Trial Balance Report | Trial Balance Report for Oracle Fusion GL showing ending balances by company, line of business, account and segments, filtered by open period, ledger, currency, and account. | Finance General Ledger (GL) | |
| PO PR Receipt Request Details | This query provides end-to-end visibility from requisition to purchase order receipt. It helps track received, available, and invoiced quantities along with supplier, accounting, and project details for procurement reconciliation. | Finance Account Payable (AP) | |
| Inactive Employee Report | This report lists employees who are no longer active in the organization. It captures termination date, reason, position, department, and last approved salary details for HR analysis and compliance. | HCM Core HR | |
| Overdue AP Invoices Report | This report highlights approved Payables invoices that remain unpaid past their due date. It supports accounts payable follow-up, cash flow monitoring, and vendor payment prioritization. | Finance Account Payable (AP) | |
