DW_MFG_RESOURCE_TXNS_CF (Preview)

This table requires activation of Manufacturing functional area. This fact table stores the resource transactions that are recorded for the primary product as the semi finished assembly gets completed and moves from one operation to another.

Details

Module:

Key Columns

WO_RESOURCE_TRANSACTION_ID

Columns

Columns
Name Datatype Length Precision Not Null Comments Referred Table Referred Column
WO_RESOURCE_TRANSACTION_ID NUMBER 38 0 True The unique identifier of a resource transaction record    
SOURCE_RECORD_ID VARCHAR2 64     System Generated    
WORK_ORDER_ID NUMBER 38 0   Represents the uniquel identifier of the work order. Resource transactions are always performed in the context of a 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 in 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 resource 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       The operation sequence number.    
WO_OPERATION_RESOURCE_ID NUMBER 38 0   The operation resource reference from the work order.    
RESOURCE_SEQ_NUMBER NUMBER       The resource sequence number.    
RESOURCE_ID NUMBER 38 0   Resource Identifier DW_MFG_RESOURCES_D RESOURCE_ID
RESOURCE_TYPE_CODE VARCHAR2 32     Type of Resource, Labor or Equipment DW_ORA_WIS_RESOURCE_TYPE_LKP_TL ORA_WIS_RESOURCE_TYPE_CODE
TRANSACTION_TYPE_CODE VARCHAR2 32     Identifies the type of the resource transaction DW_ORA_WIE_TRANSACTION_TYPES_LKP_TL ORA_WIE_TRANSACTION_TYPES_CODE
TRANSACTION_DATE DATE       Transaction date without timestamp #2 DW_DAY_D CALENDAR_DATE
TRANSACTION_TIMESTAMP TIMESTAMP       Transaction date with timestamp    
CREATION_DATE TIMESTAMP       Transaction creation date    
LAST_UPDATE_DATE TIMESTAMP       Transaction last update date    
UOM_CODE VARCHAR2 16     Unit of measure code of the resource quantity that is transacted. DW_UNIT_OF_MEASURE_D_TL UOM_CODE
HRS_UOM_CODE VARCHAR2 16     Hours UOM defined in Fusion Setup using Profile Option Code = 'ORA_RCS_HOUR_UOM'. DW_UNIT_OF_MEASURE_D_TL UOM_CODE
HRS_UOM_CONVERSION_FACTOR NUMBER       Resource Usage UOM to Hours UOM conversion factor    
ACTUAL_RESOURCE_USAGE NUMBER       Actual usage of the resource    
HRS_ACTUAL_RESOURCE_USAGE NUMBER       Actual usage of the resource in the Hours UOM defined in Fusion Setup using Profile Option Code = 'ORA_RCS_HOUR_UOM'.    
EQUIPMENT_INSTANCE_ID NUMBER 38 0   Represents the foreign key to the equipment instance record. DW_MFG_EQUIPMENT_INSTANCES_D EQUIPMENT_INSTANCE_ID
LABOR_INSTANCE_ID NUMBER 38 0   Represents the foreign key to the labor instance record. DW_MFG_LABOR_INSTANCES_D LABOR_INSTANCE_ID

Notes

#1 In these cases in addition to the inventory item id column, ORGANIZATION_ID should also be used for join with DW_INVENTORY_ITEM_D #2 In these cases, to join with DW_FISCAL_DAY_D apart from the mentioned columns, the relationship should be based on TRANSACTION_DATE column

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