# DW_MFG_OPERATION_TXNS_CF (Preview)

This table requires activation of Manufacturing functional area. This fact table stores the operation transactions that are recorded for the primary product as the semi finished assembly gets completed and moves from one operation to another. These transactions include operation completion, primary product scrap, primary product reject, as well as, reversal transactions.

## Details

Module:

## Key Columns

WO_OPERATION_TRANSACTION_ID

## Columns

Columns
Name | Datatype | Length | Precision | Not Null | Comments | Referred Table | Referred Column
--- | --- | --- | --- | --- | --- | --- | ---
WO_OPERATION_TRANSACTION_ID | NUMBER | 38 | 0 | True | The unique identifier of an operation transaction record. |  |
SOURCE_RECORD_ID | VARCHAR2 | 64 |  |  | This column is for Oracle Internal use only. System Generated |  |
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
WO_OPERATION_ID | NUMBER | 38 | 0 |  | The operation from which the primary product quantity is transacted. | DW_MFG_OPERATIONS_TL | WO_OPERATION_ID
OPERATION_SEQ_NUMBER | NUMBER |  |  |  | Operation sequence number |  |
TRANSACTION_TYPE_CODE | VARCHAR2 | 32 |  |  | Represents the type of operation transaction | DW_ORA_WIE_OP_TRANSACTION_TYPE_LKP_TL | ORA_WIE_OP_TRANSACTION_TYPE_CODE
TRANSACTION_DATE | DATE |  |  |  | Transaction Date without timestamp #2 | DW_DAY_D | CALENDAR_DATE
TRANSACTION_TIMESTAMP | TIMESTAMP |  |  |  | Transaction Date with timestamp |  |
CREATION_DATE | TIMESTAMP |  |  |  | Creation Date of the Operation transaction |  |
LAST_UPDATE_DATE | TIMESTAMP |  |  |  | Last update date of the operation transaction |  |
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
TRANSACTION_QUANTITY | NUMBER |  |  |  | Transactional product quantity that is transacted. |  |
PUOM_CODE | VARCHAR2 | 16 |  |  | Primary UOM code | DW_UNIT_OF_MEASURE_D_TL | UOM_CODE
PUOM_TRANSACTION_QUANTITY | NUMBER |  |  |  | Transaction quantity in Primary UOM |  |
FROM_DISPATCH_STATE | VARCHAR2 | 32 |  |  | The status from which this transaction takes place. | DW_ORA_WIE_DISPATCH_STATE_LKP_TL | ORA_WIE_DISPATCH_STATE_CODE
TO_DISPATCH_STATE | VARCHAR2 | 32 |  |  | The end resulting status where the transaction quantity moves to. | DW_ORA_WIE_DISPATCH_STATE_LKP_TL | ORA_WIE_DISPATCH_STATE_CODE
REASON_CODE | VARCHAR2 | 32 |  |  | Reason for either rejecting the quantities at the operation or scrapping at the operation. | DW_ORA_WIE_REASON_CODE_LKP_TL | ORA_WIE_REASON_CODE

## 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 TRANSACTION_DATE column

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