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 This column is for Oracle Internal use only. 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