# 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 |  |  | This column is for Oracle Internal use only. 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, 2025, Oracle and/or its affiliates.