This table requires activation of Manufacturing functional area. This fact table stores Manufacturing Operation Resources 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 | |
| HRS_UOM_CODE | VARCHAR2 | 16 | Represents the Hour UOM defined under profile options in Fusion. | DW_UNIT_OF_MEASURE_D_TL | UOM_CODE | ||
| SUM_HRS_UOM_REQUIRED_USAGE | NUMBER | Sum of Required Usage | |||||
| SUM_HRS_UOM_ACTUAL_RESOURCE_USAGE | NUMBER | Sum of Actual usage |
#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.