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 |
|---|---|---|---|
| Sales Order Shipment Details Report | This query extracts shipment line and delivery details for sales orders in Oracle Fusion. It reports shipment ID, delivery name, waybill, packing slip, pick wave, sales order, customer, item, shipment dates, fulfillment line status, released status, quantities, and WMS integration details for shipping analysis and operational tracking. Oracle’s shipping work area includes tasks to manage shipments and shipment lines. | SCM Order Management |   |
| Inventory Material Transaction Details | This query extracts detailed inventory material transaction data from Oracle Fusion Inventory Management. It reports transaction type, transaction action, source type, transaction date, quantity, item, organization, locator, subinventory, waybill, transaction reference, purchase order number, sales order number, and source order number for operational tracking and reconciliation. Oracle documents that INV_MATERIAL_TXNS stores a record of every material transaction or cost update performed in Inventory. | SCM Inventory | |
| Employee Primary Assignment Status Details | This query returns the current primary employee assignment status from Oracle Fusion HCM. It uses current effective-dated person and assignment records, keeps only primary employee assignments, and returns the user-facing assignment status. Oracle documents that assignment status determines whether an assignment is active, inactive, or suspended, and user statuses are defined through the Manage Assignment Status task. | HCM Core HR | |
| Employee Primary Assignment Business Unit Details | This query returns the current business unit for an employee’s primary assignment in Oracle Fusion HCM. It uses current effective-dated person, assignment, and business unit records, and keeps only primary employee assignments. Oracle’s HCM documentation describes business units as enterprise units that support business functions, and HCM reporting documentation treats business unit as a worker assignment attribute. | HCM Core HR | |
| Employee Primary Assignment Department Details | This query returns the current department for an employee’s primary assignment in Oracle Fusion HCM. It uses current effective-dated person, assignment, and department records, and keeps only primary employee assignments. Oracle’s HCM documentation describes departments as workforce structures and explains that employment-related quick actions are used to manage assignments. | HCM Core HR | |
| Employee Primary Assignment Grade Details | This query returns the current grade for an employee’s primary assignment in Oracle Fusion HCM. It uses current effective-dated person, assignment, and grade records, and keeps only primary employee assignments. Oracle states that a grade is an attribute of a person’s assignment, and grades are maintained from the Grades page. | HCM Core HR | |
| Employee Primary Assignment Job Details | This query returns the current job for an employee’s primary assignment in Oracle Fusion HCM. It uses current effective-dated person, assignment, and job records, and keeps only primary employee assignments. Oracle’s HCM documentation shows employment information on the Employment Info page and documents job setup under Workforce Structures using the Job Details task. | HCM Core HR | |
| Employee Primary Assignment Legal Employer Details | This query returns the current legal employer for an employee’s primary assignment in Oracle Fusion HCM. It uses current effective-dated person, assignment, and legal-employer organization records, and keeps only primary employee assignments. Oracle defines a legal employer as a legal entity that employs workers, and notes that legal employer information is captured for worker assignments and used for reporting. | HCM Core HR | |
| Employee Primary Assignment Location Details | This query returns the current work location for an employee’s primary assignment in Oracle Fusion HCM. It uses current effective-dated person, assignment, and location records, and keeps only primary employee assignments. Oracle documents that an assignment includes location information, and Oracle also documents that locations are created and managed from the Workforce Structures area. | HCM Core HR | |
| Employee Primary Assignment Position Details | This query returns the current position for an employee’s primary assignment in Oracle Fusion HCM. It uses current effective-dated person, assignment, and position records, and keeps only primary employee assignments. Oracle documents positions as part of Workforce Structures, and also documents that assignments are stored in PER_ALL_ASSIGNMENTS_M, which differentiates assignment records including employee assignments. | HCM Core HR | |
