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.
Module:
WO_OPERATION_TRANSACTION_ID
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 |
#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, 2024, Oracle and/or its affiliates.