This table requires activation of Manufacturing functional area. This fact table stores Manufacturing Work Orders Aggregates
Module:
SYSTEM_GEN_PK
| Name | Datatype | Length | Precision | Not Null | Comments | Referred Table | Referred Column |
|---|---|---|---|---|---|---|---|
| SYSTEM_GEN_PK | VARCHAR2 | 512 | True | Generated Primary Key for Internal Use Only | |||
| SOURCE_RECORD_ID | VARCHAR2 | 512 | This column is for Oracle Internal use only. System Generated | ||||
| WORK_ORDER_DATE_CAL_MONTH_ID | NUMBER | 38 | 0 | Calendar Month for WORK_ORDER_DATE | DW_MONTH_D | CAL_MONTH_ID | |
| INVENTORY_ITEM_ID | NUMBER | 38 | 0 | Refers to the top level, final assembly, subassembly, or model item which belongs to the given organization #1 | DW_INVENTORY_ITEM_D | INVENTORY_ITEM_ID | |
| ORGANIZATION_ID | NUMBER | 38 | 0 | The organization identifier that represents the manufacturing plant | DW_INTERNAL_ORG_D | ORGANIZATION_ID | |
| BUSINESS_UNIT_ID | NUMBER | 38 | 0 | Business unit for the manufacturing plant | DW_BUSINESS_UNIT_D | BUSINESS_UNIT_ID | |
| LEDGER_ID | NUMBER | 38 | 0 | Ledger associated to the business unit | DW_LEDGER_D | LEDGER_ID | |
| LEGAL_ENTITY_ID | NUMBER | 38 | 0 | Legal entity for the manufacturing plant | DW_LEGAL_ENTITY_D | LEGAL_ENTITY_ID | |
| WORK_METHOD_ID | NUMBER | 38 | 0 | Represents the work method identifier for this work order. The work method indicates the type of work being executed within the Fusion Manufacturing application. | DW_MFG_WORK_METHODS_TL | WORK_METHOD_ID | |
| WORK_METHOD_CODE | VARCHAR2 | 32 | Work method code | ||||
| PUOM_CODE | VARCHAR2 | 16 | Primary UOM code | DW_UNIT_OF_MEASURE_D_TL | UOM_CODE | ||
| COUNT_WORK_ORDERS | NUMBER | Count of Work Orders (Except Cancelled Orders) | |||||
| COUNT_UNRELEASED_WORK_ORDERS | NUMBER | Count of Unreleased Work Orders | |||||
| COUNT_RELEASED_WORK_ORDERS | NUMBER | Count of Released Work Orders | |||||
| COUNT_PENDING_WORK_ORDERS | NUMBER | Count of Pending Work Orders (Except Cancelled,Completed & Closed) | |||||
| COUNT_COMPLETED_WORK_ORDERS | NUMBER | Count of Completed Work Orders (Completed & Closed) | |||||
| COUNT_ON_TIME_WORK_ORDERS | NUMBER | Count of Work Orders Completed on Time | |||||
| COUNT_PERFECT_WORK_ORDERS | NUMBER | Count of Perfect Work Orders | |||||
| SUM_PUOM_PLANNED_START_QUANTITY | NUMBER | Planned quantity in Primary UOM | |||||
| SUM_PUOM_SCRAPPED_QUANTITY | NUMBER | Scrapped quantity in Primary UOM | |||||
| SUM_PUOM_REJECTED_QUANTITY | NUMBER | Rejected Quantity in Primary UOM | |||||
| SUM_PUOM_COMPLETED_QUANTITY | NUMBER | Completed Quantity in Primary UOM | |||||
| SUM_PUOM_COMPLETED_WO_PLANNED_QTY | NUMBER | Planned Quantity in Primary UOM for Completed Work Orders (Completed & Closed) | |||||
| SUM_PUOM_BEHIND_PLAN_WEIGHTED_QTY | NUMBER | Behind plan weighted quantity in Primary UOM | |||||
| AVG_WORK_ORDER_DELAY_DAYS | NUMBER | Avg Work Order Delay in Days |
#1 In these cases in addition to the inventory item id column, ORGANIZATION_ID column should also be used for join with DW_INVENTORY_ITEM_D
Copyright © 2019, 2026, Oracle and/or its affiliates.