DW_MFG_OPERATIONS_CF (Preview)

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.

Details

Module:

Key Columns

WO_OPERATION_ID

Columns

Columns
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.    

Notes

#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.