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 |
|---|---|---|---|
| Supplier Invoice Payment Register Details | Shows supplier payment details processed in Oracle Fusion Payables. Use it to review payment dates, amounts, methods, and suppliers for a selected period, supporting cash management, supplier inquiries, and audit review. | Finance Account Payable (AP) |   |
| AP Unaccounted Invoice Distribution Details | This query extracts unpaid or unposted AP invoice distribution details from Oracle Fusion Payables. It combines invoice header, invoice line, distribution, supplier, supplier site, PO reference, approval status, accounting amount, and operating unit information for reporting and reconciliation. | Finance Account Payable (AP) | |
| AR Invoice Summary Details | This query extracts summary-level AR invoice details from Oracle Fusion Receivables. It returns invoice number, invoice type, purchase order, customer, summarized line, tax, freight, total amount, currency, invoice status, and balance due for reporting and analysis | Finance Account Receivables (AR) | |
| AR Receipt Application Details | This query extracts AR receipt and receipt application details from Oracle Fusion Receivables. It reports business unit, accounting date, customer, receipt batch, receipt number, transaction number, receipt amount, applied amount, discounts, currency, accounted amount, and exception reason for reconciliation and receipt analysis. | Finance Account Receivables (AR) | |
| GL Journals Detail Report | This query extracts detailed General Ledger journal information from Oracle Fusion. It reports ledger, period, batch, journal, line, account segments, segment descriptions, source, category, posting details, approval details, currency, entered amount, accounted amount, and journal action history for reporting and audit analysis. | Finance General Ledger (GL) | |
| Project Expenditure Organization Details | This query extracts Oracle Fusion project expenditure organization setup details. It reports organization name, organization ID, classification code, organization status, and set name for expenditure organization setup and validation. A project expenditure organization is an organization classified to incur project expenditures. | Finance Project | |
| Project Expenditure Type Details | This query extracts Oracle Fusion Project Costing expenditure type setup details. It reports expenditure type name, active dates, expenditure type class, expenditure type ID, reference data set name, and DFF attribute for setup validation and reporting. Oracle describes expenditure types as classifications of cost used on project expenditure items, and the Manage Expenditure Types task is the setup page used to define and review them. | Finance Project | |
| Project Task | This query extracts chargeable financial project tasks from Oracle Fusion Project Financial Management. It returns project number, task number, and task organization for reporting and validation. Oracle documentation describes financial tasks as project tasks used in financial planning and project management flows. | Finance Project | |
| Sales Order Hold Details | This query extracts sales order hold details from Oracle Fusion Order Management. It reports hold name, hold creator, hold creation date, hold comments, hold release details, customer, order type, order status, and hold level at order or line level for operational review and reporting. Oracle documents hold management in the Order Management work area and describes applying and releasing holds on sales orders and fulfillment lines there. | SCM Order Management | |
 Sales Order Shipment Revenue Details | This query returns shipped and nonshippable sales order line details from Oracle Fusion Order Management. It shows territory, order number, line number, item number, shipped date, unallocated revenue, unallocated quantity, and whether the line is shippable or nonshippable. | SCM Order Management |  |
