# 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

Copyright © 2019, 2025, Oracle and/or its affiliates.