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 |
|---|---|---|---|
| User Role and Access Details | This Oracle Fusion HCM report provides a consolidated view of workers and their system access details, including usernames, assigned roles, business units, departments, role effective dates, and account status. | User Managment |   |
| ESS Job Execution and Request History Report | This Oracle Fusion report provides ESS job request history including job metadata, execution time, submission details, request status, and error messages for monitoring and troubleshooting scheduled processes. | Fusion Common Queries | |
| Employee Salary Change and Compensation Details Report | This Oracle Fusion report provides detailed employee compensation information including salary changes, job, position, salary range, and adjustment metrics for effective HR and payroll management. | HCM Payroll | |
| Item Master Report | This Oracle Fusion report provides a complete overview of item master data including item type, approval status, work definition, cost, safety stock, and lifecycle phase for efficient supply chain management. | SCM Inventory | |
| Item Trading Partner Mapping Report | This Oracle Fusion report provides item trading partner mapping including supplier and customer item numbers, relationship status, and trading partner details for improved supply chain management. | SCM Inventory | |
| Bill of Materials Structure | This Oracle Fusion report provides a multi-level Bill of Materials (BOM) explosion including component hierarchy, quantities, planning factors, and work definition details for manufacturing and engineering analysis. | SCM Inventory | |
 Shipment Movement Request Report | This query provides end-to-end visibility of shipment, delivery, and inventory movement data in Oracle Fusion. It combines shipping, inventory, and transaction details into a single report for better operational tracking. | SCM Inventory |  |
| Employee Master Details | This query returns worker master information from Oracle Fusion HCM. It combines employee personal details, demographic details, contact details, assignment details, manager details, department, location, position, job, grade, action, action reason, and cost center information in one report. | HCM Core HR | |
| Employee Performance Goals and Review Period Details | This query returns employee-wise performance goal details from Oracle Fusion HCM Talent Management. It combines worker assignment details, department, position, grade, manager, goal name, goal description, category, subcategory, review period, weighting, priority, goal status, and measurement name. Oracle documents that review periods connect goal plans and performance documents, and managers can assign performance goals to team members within a review period. | HCM User Managment | |
| Corporate Item details | This query returns corporate item master enrichment details from Oracle Fusion SCM. It combines item master data with category/catalog assignment, engineering change order references, make-buy status, MOQ, lead time, list price, and substitute or superseded item relationships. Oracle documents that catalogs and categories are used to classify items, item relationships can include related item and substitute/supersession relationships, and change orders are used to process changes to item attributes, structures, packs, associations, and revisions. | SCM Inventory | |
