This table requires activation of Manufacturing functional area. This fact table stores information about the various execution steps required for a given work order. These steps include the processes that are necessary to produce a given product.
Module:
WO_OPERATION_ID
Name | Datatype | Length | Precision | Not Null | Comments | Referred Table | Referred Column |
---|---|---|---|---|---|---|---|
WO_OPERATION_ID | NUMBER | 38 | 0 | True | The operation from which the primary product quantity is transacted. | DW_MFG_OPERATIONS_TL | WO_OPERATION_ID |
SOURCE_RECORD_ID | VARCHAR2 | 64 | System Generated | ||||
OPERATION_SEQ_NUMBER | NUMBER | Operation sequence number | |||||
WORK_ORDER_ID | NUMBER | 38 | 0 | Represents the uniquel identifier of the work order. | DW_MFG_WORK_ORDERS_TL | WORK_ORDER_ID | |
WORK_ORDER_NUMBER | VARCHAR2 | 128 | Represents the user-facing identifier of the work order. | ||||
INVENTORY_ITEM_ID | NUMBER | 38 | 0 | The primary product identifier defined on the work order. #1 | DW_INVENTORY_ITEM_D | INVENTORY_ITEM_ID | |
ORGANIZATION_ID | NUMBER | 38 | 0 | The organization identifier that represents the manufacturing plant to which this operation transaction is performed. | 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 Business Unit | DW_LEDGER_D | LEDGER_ID | |
FISCAL_PERIOD_TYPE | VARCHAR2 | 16 | Fiscal period type #2 | DW_FISCAL_DAY_D | FISCAL_PERIOD_TYPE | ||
FISCAL_PERIOD_SET_NAME | VARCHAR2 | 16 | Fiscal period name #2 | DW_FISCAL_DAY_D | FISCAL_PERIOD_SET_NAME | ||
LEGAL_ENTITY_ID | NUMBER | 38 | 0 | Legal Entity for the manufacturing plant | DW_LEGAL_ENTITY_D | LEGAL_ENTITY_ID | |
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 | |
OPERATION_TYPE_CODE | VARCHAR2 | 32 | Specifies the type of the operation. | DW_ORA_WIS_OPERATION_TYPE_LKP_TL | ORA_WIS_OPERATION_TYPE_CODE | ||
CREATION_DATE | TIMESTAMP | Creation Date of the Operation transaction | |||||
LAST_UPDATE_DATE | TIMESTAMP | Last update date of the operation transaction | |||||
UOM_CODE | VARCHAR2 | 16 | Transactional unit of measure code of the primary product quantity that is transacted. | DW_UNIT_OF_MEASURE_D_TL | UOM_CODE | ||
OPERATION_READY_QUANTITY | NUMBER | The quantity that is sitting in the inbound queue of the operation. | |||||
OPERATION_COMPLETED_QUANTITY | NUMBER | Primary product quantity completed so far in the work order at the operation. | |||||
OPERATION_SCRAPPED_QUANTITY | NUMBER | Primary product quantity scrapped so far in the work order at the operation. | |||||
OPERATION_REJECTED_QUANTITY | NUMBER | Primary product quantity rejected so far in the work order at the operation. | |||||
PUOM_CODE | VARCHAR2 | 16 | Primary UOM code | DW_UNIT_OF_MEASURE_D_TL | UOM_CODE | ||
PUOM_CONVERSION_FACTOR | NUMBER | Transaction UOM to Primary UOM conversion factor | |||||
PUOM_OPERATION_READY_QUANTITY | NUMBER | The quantity that is sitting in the inbound queue of the operation in Primary UOM | |||||
PUOM_OPERATION_COMPLETED_QUANTITY | NUMBER | Primary product quantity completed so far in the work order at the operation in Primary UOM. | |||||
PUOM_OPERATION_SCRAPPED_QUANTITY | NUMBER | Primary product quantity scrapped so far in the work order at the operation in Primary UOM. | |||||
PUOM_OPERATION_REJECTED_QUANTITY | NUMBER | Primary product quantity rejected so far in the work order at the operation in Primary UOM. | |||||
PLANNED_START_DATE | DATE | Planned start date of the operation without timestamp. #2 | DW_DAY_D | CALENDAR_DATE | |||
PLANNED_COMPLETION_DATE | DATE | Planned completion date of the operation without timestamp. | DW_DAY_D | CALENDAR_DATE | |||
COUNT_POINT_OPERATION_FLAG | VARCHAR2 | 16 | Flag used to indicate if this is a count point operation | DW_YN_LKP_TL | YN_LKP_CODE | ||
OSP_ITEM_ID | NUMBER | 38 | 0 | Item that represents the value added service in a supplier operation | DW_INVENTORY_ITEM_D | INVENTORY_ITEM_ID | |
IN_PROCESS_QUANTITY | NUMBER | Quantity in supplier operation that has been completed in the previous count point operation but hasn't been received yet in this operation | |||||
PO_REQUESTED_QUANTITY | NUMBER | Quantity for which a supply request has been raised with SCO for this supplier operation | |||||
PO_APPROVED_QUANTITY | NUMBER | Quantity for which an approved PO exists for this supplier operation | |||||
SHIPPED_QUANTITY | NUMBER | Quantity which has been shipped to the supplier | |||||
RECEIVED_QUANTITY | NUMBER | Quantity of the partially finished assembly (PFA) that has been delivered to the shopfloor from the supplier | |||||
OVER_RECEIPT_QUANTITY | NUMBER | Quantity received in excess of the expected quantity for a supplier operation | |||||
PUOM_IN_PROCESS_QUANTITY | NUMBER | Primary UOM Quantity in supplier operation that has been completed in the previous count point operation but hasn't been received yet in this operation | |||||
PUOM_PO_REQUESTED_QUANTITY | NUMBER | Primary UOM Quantity for which a supply request has been raised with SCO for this supplier operation | |||||
PUOM_PO_APPROVED_QUANTITY | NUMBER | Primary UOM Quantity for which an approved PO exists for this supplier operation | |||||
PUOM_SHIPPED_QUANTITY | NUMBER | Primary UOM Quantity which has been shipped to the supplier | |||||
PUOM_RECEIVED_QUANTITY | NUMBER | Primary UOM Quantity of the partially finished assembly (PFA) that has been delivered to the shopfloor from the supplier | |||||
PUOM_OVER_RECEIPT_QUANTITY | NUMBER | Primary UOM Quantity received in excess of the expected quantity for a supplier operation | |||||
FIRST_PASS_YIELD | BIGDECIMAL | 10 | Quantity which got completed in first attempt | ||||
THROUGHPUT | BIGDECIMAL | 10 | It is the metric which shows the throughput of this Work Order Operation | ||||
PERFORMANCE_RATIO | BIGDECIMAL | 10 | Performance ratio for this particular Work Order Operation | ||||
UNPLANNED_MATERIAL_USED_FLAG | VARCHAR2 | 16 | Flag to indicate whether any unplanned material is used or not | DW_YN_LKP_TL | YN_LKP_CODE | ||
AUTO_TRANSACT_FLAG | VARCHAR2 | 16 | Indicates whether both resources and materials are automatically charged based on the Supply Type or the Charge Type setups upon completion of the operation. | ||||
RESEQUENCE_FLAG | VARCHAR2 | 16 | Flag used to indicate if the operation can be re-sequenced while executing the operation. Valid values are Y or N. |
#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 #2 In these cases to join with DW_FISCAL_DAY_D apart from FISCAL_PERIOD_TYPE and FISCAL_PERIOD_SET_NAME the relationship should be based on PLANNED_START_DATE column
Copyright © 2019, 2023, Oracle and/or its affiliates.