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.
Module:
WO_RESOURCE_TRANSACTION_ID
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 |
#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.