Oracle Fusion Manufacturing Tables: Work Orders, Work Definitions and Join Keys
Oracle Fusion Manufacturing keeps its data in two families of tables: WIS tables for work definitions and WIE tables for work orders. This reference lists the main ones with join keys for BI Publisher reports.
| Table | Area | What it holds | Key and join columns |
|---|---|---|---|
WIS_WORK_DEFINITIONS | Work definition | Header of a work definition, the manufacturing routing and bill of materials for an item in an organization | WORK_DEFINITION_ID, INVENTORY_ITEM_ID, ORGANIZATION_ID |
WIS_WORK_DEFINITION_VERSIONS | Work definition | Versions of a work definition with effective dates | WORK_DEFINITION_ID, VERSION_NUMBER |
WIS_OPERATIONS_B | Work definition | Operations defined in a work definition version | OPERATION_ID, WORK_DEFINITION_ID, OPERATION_SEQUENCE_NUMBER |
WIS_OPERATION_MATERIALS | Work definition | Component materials needed at each operation | OPERATION_ID, INVENTORY_ITEM_ID |
WIS_OPERATION_RESOURCES | Work definition | Labor and machine resources used at each operation | OPERATION_ID, RESOURCE_ID |
WIE_WORK_ORDERS_B | Work order | Work order header: item, quantity, status and planned dates | WORK_ORDER_ID, WORK_ORDER_NUMBER, ORGANIZATION_ID, INVENTORY_ITEM_ID |
WIE_WO_OPERATIONS_B | Work order | Operations on a work order, copied from the work definition and executed | WO_OPERATION_ID, WORK_ORDER_ID |
WIE_WO_OPERATION_MATERIALS | Work order | Required and issued component quantities per work order operation | WO_OPERATION_ID, INVENTORY_ITEM_ID |
WIE_WO_OPERATION_RESOURCES | Work order | Planned and actual resource usage per work order operation | WO_OPERATION_ID, RESOURCE_ID |
EGP_SYSTEM_ITEMS_B | Item and organization | Item master by organization, join to resolve item numbers | INVENTORY_ITEM_ID, ORGANIZATION_ID |
EGP_SYSTEM_ITEMS_TL | Item and organization | Translated item descriptions, filter on LANGUAGE | INVENTORY_ITEM_ID, ORGANIZATION_ID, LANGUAGE |
INV_ORG_PARAMETERS | Item and organization | Inventory organization setup, including organization code and master organization | ORGANIZATION_ID, ORGANIZATION_CODE, MASTER_ORGANIZATION_ID |
INV_MATERIAL_TXNS | Inventory | Inventory transactions including work order issues and completions | TRANSACTION_ID, INVENTORY_ITEM_ID, ORGANIZATION_ID |
INV_ONHAND_QUANTITIES_DETAIL | Inventory | Current on-hand quantity by item, subinventory and lot | INVENTORY_ITEM_ID, ORGANIZATION_ID, SUBINVENTORY_CODE |
Table and column names can differ by release and update. Confirm each one in the Oracle Fusion Cloud SCM Tables and Views guide for your update, or in the BI Publisher data model, before relying on it in production reports.
Ask Fusion manufacturing questions in plain English
Optional: see how a private AI layer answers work order questions from your Fusion data.
Optional. The tool and every export work without this. No spam.
How to use this reference
Search by table name, module area or column. Start with the work order header, WIE_WORK_ORDERS_B, then join down to operations, materials and resources through the work order or operation IDs. Join to EGP_SYSTEM_ITEMS_B on both INVENTORY_ITEM_ID and ORGANIZATION_ID to get item numbers. Join to INV_ORG_PARAMETERS to show the organization code. Always include ORGANIZATION_ID in item joins, because an item exists once per organization and a one-column join duplicates rows.
Work definitions versus work orders
A work definition describes how an item is made: a versioned set of operations with materials and resources. A work order is the instance created for a quantity and date, and it copies the operations from the work definition when released. That distinction matters for reporting. If you want the standard recipe, query WIS tables. If you want what was planned and issued for a particular order, query WIE tables, since the work order can be changed after creation without altering the definition.
- Use WIS tables for routing and BOM structure
- Use WIE tables for order status, issued quantities and actual usage
- Check the version effective date when reading a work definition
Reporting tips for BI Publisher and OTBI
Prefer subject areas in OTBI for ad hoc work, since they apply security and handle translations for you. Use direct SQL in BI Publisher when you need exact joins or performance control, and run it against the Fusion data source with a data model rather than ad hoc queries in production. Filter on the _B and _TL pairs correctly, and filter translation tables by LANGUAGE equals USERENV language. Test your query with a small date range first, since manufacturing tables grow quickly.
Common mistakes
The most common errors are joining items on INVENTORY_ITEM_ID alone, forgetting the translation table language filter, and assuming a table or column from Oracle E-Business Suite exists in Fusion. EBS tables such as WIP_DISCRETE_JOBS do not exist in Fusion Cloud, so a migrated report needs rewriting against the WIE and WIS tables. Also confirm your role has access to the data, because Fusion applies data security to subject areas and many tables are not directly queryable in every environment.
Frequently Asked Questions
What is the work order table in Oracle Fusion?
The work order header is WIE_WORK_ORDERS_B, with operations, materials and resources in related WIE tables. Verify the exact table and column names for your Fusion update in the Tables and Views guide before using them in a report.
What is WIS_WORK_DEFINITIONS?
It holds the header of a work definition, which is the versioned routing and bill of materials for an item in a manufacturing organization. Operations, materials and resources sit in related WIS tables.
Is WIP_DISCRETE_JOBS in Oracle Fusion?
No. WIP_DISCRETE_JOBS is an Oracle E-Business Suite table. Fusion Cloud Manufacturing uses WIE work order tables and WIS work definition tables, so EBS reports must be redesigned.
How do I get item numbers in a manufacturing query?
Join to EGP_SYSTEM_ITEMS_B on both INVENTORY_ITEM_ID and ORGANIZATION_ID. Add EGP_SYSTEM_ITEMS_TL filtered by language for the description.
Netray can put a private natural-language layer over Oracle Fusion manufacturing data so planners can ask questions without writing BIP queries. It can run on-prem or in your private cloud.
Related Tools
Oracle Fusion Supplier and Organization Tables Reference
A reference for the Oracle Fusion supplier table, organization tables, and the FBDI interface and error tables used when supplier loads fail.
OracleOracle Fusion Table Names Reference for SCM and Financials
A searchable reference of widely used Oracle Fusion SCM and Financials table names with what each holds and the keys to join on.
OracleOracle Fusion SCM BI Publisher SQL Query Generator
Fill in organization, item and BU filters and get starter SQL for item, on-hand and open PO data models.
OracleOracle Fusion Manufacturing Work Definition Worksheet
Design routing operations before you key them in. Capture work centers, setup and run times, yield and the total time for an order quantity.
More Oracle tools
See all- Oracle Fusion FBDI Template Field Guide
- Oracle Fusion Item Class Design Worksheet
- Oracle Fusion Supply Planning Checklist
- Oracle Fusion BI Publisher Report Specification Template
- Oracle Fusion Quarterly Update Test Checklist
- Oracle Fusion Role Provisioning Worksheet
- Oracle Fusion Cloud SCM Fit Gap Worksheet
- Oracle Fusion Data Migration Mapping Worksheet
- Oracle Fusion Cutover Plan Worksheet
Keep exploring
Free tools
- Oracle Fusion BI Publisher Report Specification TemplateDocument a BI Publisher report before you build it: purpose, data model, parameters, layout, schedule and security in one template.
- Oracle Fusion Supplier and Organization Tables ReferenceA reference for the Oracle Fusion supplier table, organization tables, and the FBDI interface and error tables used when supplier loads fail.
- Oracle Fusion Suppliers Table Report SQL TemplateFill in a few fields to generate a BI Publisher SQL query that reports Oracle Fusion suppliers and their sites, with notes on supplier import templates.
ERP fixes and how-tos
- How to Create a Report in Oracle FusionCreate a report in Oracle Fusion Cloud with BI Publisher: data model, layout template, security and scheduling, plus when an OTBI analysis is the faster route.
- Oracle Fusion Manufacturing User Guide: Setup Order, Daily Use and Where the Official Docs and Training AreA practical guide to Oracle Fusion Manufacturing: setup order, work definitions, work orders, shop floor execution and where official docs and training live.
- Oracle Work Order Tables: WIP_ENTITIES, WIP_DISCRETE_JOBS and the REST RouteOracle work order tables explained: WIP_ENTITIES, WIP_DISCRETE_JOBS, operations and requirements, with a join query for EBS and the Fusion REST route.
Runs with your ERP
- Oracle Fusion Cloud Maintenance with Fusion ERP and SCMHow Oracle Fusion Cloud Maintenance handles work orders, preventive maintenance and warranty on Fusion SCM: data flows, setup, pitfalls and private AI ideas.
- Oracle Fusion Cloud Quality Management with Fusion SCMHow Oracle Fusion Cloud Quality Management logs nonconformance against WIP, receiving and supplier records and drives CAPA: flows, setup and pitfalls.
- Oracle IoT Production Monitoring with Fusion Cloud ManufacturingHow Oracle IoT Production Monitoring syncs resources and work orders with Fusion Manufacturing and writes back status and quantities: flows, setup, pitfalls.
AI on your ERP
- AI for Oracle Cloud SCM and Manufacturing, Grounded in Your Planning DataAdd grounded AI to Oracle Cloud SCM and Fusion Manufacturing: demand plans, work orders, and supplier data, answered on-prem or in a private cloud with full query visibility.
- Fusion Cloud ERP AI: OCI Generative AI Service vs. a Private LLMHow Fusion Cloud ERP AI supports GenAI implementation: OCI Generative AI Service for Fusion-only use cases, a private LLM for sensitive or cross-system data.
Integrations
- How to connect Power BI to Oracle Fusion Cloud ERPHow to connect Power BI to Oracle Fusion Cloud ERP: BICC to a warehouse, BI Publisher and REST options, manufacturing dashboards and natural-language Q&A.
- How to connect ChatGPT to Oracle Fusion Cloud ERPHow to use ChatGPT with Oracle Fusion Cloud ERP: custom GPT actions over REST, exports versus live access, enterprise data controls and private model options.
Software
- Oracle Fusion Cloud ERPOracle Fusion Cloud ERP explained: financials, procurement, manufacturing and SCM modules, REST APIs, FBDI and OTBI, limits, alternatives and AI fit.
- Oracle Supply Chain PlanningOracle Supply Chain Planning explained: demand, supply, replenishment and S&OP capabilities in Oracle Fusion Cloud, integrations, limits and alternatives.