This table requires activation of Manufacturing functional area. This fact table stores Manufacturing Work Order Operations 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 | ||||
| WORK_CENTER_ID | NUMBER | 38 | 0 | Indicates the work center where this operation is executed. | DW_MFG_WORK_CENTERS_D | WORK_CENTER_ID | |
| WORK_AREA_ID | NUMBER | 38 | 0 | Indicates the work area where this operation is executed. | DW_MFG_WORK_AREAS_D | WORK_AREA_ID | |
| COUNT_WO_OPERATION_ID | NUMBER | Count of Work Order Operations | |||||
| SUM_PERFORMANCE_RATIO | NUMBER | Sum of performance ratio for Operations | |||||
| SUM_FIRST_PASS_YIELD | NUMBER | Sum of First Pass Yield for operations |
#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.