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     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, 2023, Oracle and/or its affiliates.