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 |
|---|---|---|---|
| Employee User Account Details | This query returns the employee person number and the linked Oracle HCM username from the user account record. It joins the worker record with the HCM user account table and keeps only currently effective person records. Oracle documents that HCM user accounts are managed from the Manage User Account page and that usernames are created and maintained as part of HCM user account management. | HCM Core HR |   |
| Employee Primary Assignment Line Manager Details | This query returns the current line manager for an employee’s primary assignment in Oracle Fusion HCM. It uses current effective-dated assignment, supervisor, and person-name records, and keeps only primary employee assignments. Oracle documents that assignments include manager information, that supervisor relationships are stored in PER_ASSIGNMENT_SUPERVISORS_F, and that an assignment must have at least one line manager. | HCM Core HR | |
| Unprocessed AP Invoice Interface Details | This query returns invoice header records from the Oracle Fusion Payables open interface table for invoices that are not yet processed. Oracle documents that AP_INVOICES_INTERFACE stores invoice header information for import into Payables base tables, and the Import Payables Invoices process creates invoices from these interface records. | Finance Account Payable (AP) | |
| AR Applied Receipt Details | This query extracts applied receipt details from Oracle Fusion Receivables. It combines customer, invoice, receipt, batch, receipt accounting date, applied amount, discounts, and invoice batch source details for receipt application analysis and reconciliation. Oracle’s Applied Receipts Register is specifically intended to review receipt applications by customer and receipt batch, which aligns closely with this query’s business purpose. | Finance Account Receivables (AR) | |
| Fixed Asset Depreciation Details | This query returns fixed asset depreciation details from Oracle Fusion Assets. It reports asset number, major and minor category, project number, expense account, natural account, ledger currency, fiscal year, period, and depreciation amount for asset depreciation analysis and reporting. | Finance Fixed Assets (FA) | |
| Sales Order Booking Revenue Details | This query returns submitted sales order booking details from Oracle Fusion Order Management. It reports territory, sales order number, line number, fulfillment line ID, item number, submitted date, net revenue, quantity, and item type for booking analysis and reporting. Oracle documents that the Order Management work area is used to create and manage sales orders and to review order and fulfillment details. | SCM Order Management | |
| Customer Invoice Payment | Reports cash collected for customer invoices—showing customer & account, invoice number/date, payment (GL close) date, credit analyst, and amount applied. | SCM Order Management | |
| Inventory On Hand details report | Shows on-hand quantity by item, organization (code/name), subinventory, and locator, with date received and create/update transaction IDs—useful to validate stock. | SCM Inventory | |
 Customer Contract Line Details | This query extracts customer contract header and line details from Oracle Fusion Enterprise Contracts. It helps track contract number, customer account, service part, entitlement classification, contract dates, renewal details, billing frequency, quantity, and booked amount for reporting and analytics. | SCM Contracts |  |
| GL Journal Activity | Shows detailed GL journal activity lines with ledger, source/category, batch/journal, period, legal entity, COA segments, accounting date, currency, accounted DR/CR, creator/approver, approval status, and filters for ledger, source, posted status, period, and account range—ideal for close and audit. | Finance General Ledger (GL) | |
