WIE_RESOURCE_TRANSACTIONS
This 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
-
Schema: FUSION
-
Object owner: WIE
-
Object type: TABLE
-
Tablespace: Default
Primary Key
Name | Columns |
---|---|
WIE_RESOURCE_TXNS_PK |
WO_RESOURCE_TRANSACTION_ID |
Columns
Name | Datatype | Length | Precision | Not-null | Comments |
---|---|---|---|---|---|
WO_RESOURCE_TRANSACTION_ID | NUMBER | 18 | Yes | The unique identifier of a resource transaction record. Its value is an application generated unique id. | |
OBJECT_VERSION_NUMBER | NUMBER | 9 | Yes | Used to implement optimistic locking. This number is incremented every time that the row is updated. The number is compared at the start and end of a transaction to detect whether another session has updated the row since it was queried. | |
ORGANIZATION_ID | NUMBER | 18 | Yes | The organization identifier that represents the manufacturing plant to which this resource transaction is performed. | |
WORK_CENTER_ID | NUMBER | 18 | The work center where the resource is charged. | ||
WORK_ORDER_ID | NUMBER | 18 | Yes | Represents the internal identifier of the work order. Resource transactions are always performed in the context of a work order. | |
INVENTORY_ITEM_ID | NUMBER | 18 | Yes | The primary product identifier defined in the work order. This is an internal column and is de-normalized. | |
WO_OPERATION_ID | NUMBER | 18 | Yes | The operation from which the primary product quantity is transacted. | |
OPERATION_SEQ_NUMBER | NUMBER | The operation sequence number. Along with the work order number, will be the unique user key to the work order operation entity. | |||
WO_OPERATION_RESOURCE_ID | NUMBER | 18 | The operation resource reference from the work order. | ||
RESOURCE_SEQ_NUMBER | NUMBER | The resource sequence number. We need this column in a denormalized form here to be able to capture resource transactions which are adhoc in nature and can then result in the creation of a work order operation resource record. | |||
RESOURCE_TYPE | VARCHAR2 | 30 | Represents the charged resource type. Valid values exist in the lookup with lookup type = ORA_WIS_RESOURCE_TYPE. De-Normalized for Costing. | ||
RESOURCE_ID | NUMBER | 18 | Yes | Represents the internal identifier of the resource. | |
RESOURCE_CODE | VARCHAR2 | 30 | Represents the user key for the resource. | ||
RESOURCE_ACTIVITY_CODE | VARCHAR2 | 30 | Activity is used to define any intra operation steps + any other custom run steps that the customer would like to track at the resource level. Valid values exist in the lookup with lookup type = ORA_WIS_RESOURCE_ACTIVITY. | ||
AUTO_TRANSACT_FLAG | VARCHAR2 | 1 | Flag that identifies that this is a system generated transaction. | ||
BASIS_TYPE | VARCHAR2 | 30 | Yes | Indicates whether the resource quantity is fixed (i.e. usage per lot produced) or variable (i.e. usage per item produced). Valid values exist in the lookup with lookup type = EGP_BOM_BASIS_TYPE. De-Normalized for Costing. | |
CHARGE_TYPE | VARCHAR2 | 30 | Whether resource transactions were automatically generated and at what stage. Valid values exist in the lookup with lookup type = ORA_WIS_CHARGE_TYPE. De-Normalized for Costing. | ||
USAGE_RATE | NUMBER | The predefined resource rate that is required to perform operation/activity for one unit of the assembly. The usage rate is the value that we will inherit as is from the work definition. For example: Number of hours it take to spray paint one pedestal. De-Normalized for Costing. | |||
REQUIRED_USAGE | NUMBER | Represents the required usage for the resource. Based on the basis type it would be the usage per assembly unit [variable] or the usage per work order [fixed]. The planned resource usage is the value applied based on the work order quantity depending on the 'Basis'. For example: Usage rate : 1 hour, Basis : Variable, WO Qty = 10 So, planned resource usage = 1 * 10 = 10 hours. De-Normalized for Costing. | |||
TRANSACTION_TYPE_CODE | VARCHAR2 | 30 | Yes | Identifies the type of the resource transaction. Valid values exist in the lookup with lookup type = ORA_WIE_TRANSACTION_TYPE. | |
TRANSACTION_DATE | TIMESTAMP | Yes | Date when the resource transaction is performed. | ||
TRANSACTION_QUANTITY | NUMBER | Yes | Represents the quantity of the resource transaction. | ||
TRANSACTION_UOM_CODE | VARCHAR2 | 3 | Yes | Unit of measure code of the resource quantity that is transacted. | |
PRIMARY_QUANTITY | NUMBER | Yes | This is a calculated field. If the transaction is not done in the primary quantity (Transaction UOM <> Primary UOM) this will have a different value. Onhand is recorded in the primary quantity, hence it is useful to convert and store this against the transaction. | ||
PRIMARY_UOM_CODE | VARCHAR2 | 3 | Yes | Represents the unit of measure code for the primary quantity. This is denormalized from the item master for ease of driving analytics. | |
SOURCE_SYSTEM_TYPE | VARCHAR2 | 30 | Indicates the type of source system (i.e. internal or external) from which data is being imported. Valid values exist in the lookup with lookup type = ORA_WIE_SOURCE_SYSTEM_TYPE. | ||
SOURCE_SYSTEM_ID | NUMBER | Represents the identifier of the source system. If the source system type = "INTERNAL" this value equates to the application id. If "EXTERNAL", then it is the source system as defined in the trading community (TCA) source systems table. | |||
SOURCE_SYSTEM_CODE | VARCHAR2 | 30 | A code used to indicate the source system from which data is being imported. Depending on the source system type, this value could represent an internal Fusion product code or the actual trading community (TCA) source system reference. | ||
SOURCE_HEADER_REF | VARCHAR2 | 240 | Represents the source system's user-facing header reference identifier. | ||
SOURCE_HEADER_REF_ID | NUMBER | 18 | Represents the source system's internal header reference identifier. | ||
SOURCE_LINE_REF | VARCHAR2 | 240 | Represents the source system's user-facing line reference identifier. | ||
SOURCE_LINE_REF_ID | NUMBER | 18 | Represents the source system's internal line reference identifier. | ||
WO_OPERATION_TRANSACTION_ID | NUMBER | 18 | When the auto-transact flag is checked at the operation level, the operation completion that moves the primary product quantity out of the operation triggers the creation of resource transactions. In such cases, we will have the operation transaction id that triggered this resource transaction. | ||
CST_INTERFACED_FLAG | VARCHAR2 | 1 | Yes | Flag to indicate whether the resource transaction is interfaced to costing or not. The not yet interfaced transaction will become candidates for the ESS job that pushes the transaction to the Fusion Costing system. | |
INTERFACE_BATCH_ID | NUMBER | 18 | Represents the interface batch identifier. | ||
INTERFACE_ROW_ID | NUMBER | 18 | Represents the interface row identifier for resource transactions. | ||
TXN_HEADER_ID | NUMBER | 18 | This is an internal column. Used by the resource transaction processor. | ||
EQUIPMENT_INSTANCE_ID | NUMBER | 18 | Represents the foreign key to the equipment instance record. | ||
LABOR_INSTANCE_ID | NUMBER | 18 | Represents the foreign key to the labor instance record. | ||
PJC_CONTEXT_CATEGORY | VARCHAR2 | 40 | Segment used to identify the descriptive flexfield application context for project-related standardized cost collection. | ||
PJC_PROJECT_ID | NUMBER | 18 | Identifier of the project used to build the transaction descriptive flexfield for project-related transaction distributions. Foreign key to PJF_PROJECTS_ALL_B.PROJECT_ID. | ||
PJC_TASK_ID | NUMBER | 18 | Identifier of the task used to build the transaction descriptive flexfield for project-related transaction distributions. Foreign key to PJF_PROJ_ELEMENTS_B.PROJ_ELEMENT_ID (however uses an alias of TASK_ID). | ||
PJC_EXPENDITURE_TYPE_ID | NUMBER | 18 | Expenditure type used to build the transaction descriptive flexfield for project-related transaction distributions. | ||
PJC_EXPENDITURE_ITEM_DATE | DATE | Date on which a project-related transaction is incurred. | |||
PJC_ORGANIZATION_ID | NUMBER | 18 | Identifier for expenditure organization used to build the transaction descriptive flexfield for project-related transaction distributions. | ||
PJC_BILLABLE_FLAG | VARCHAR2 | 1 | Flag that indicates if a project-related item is available to be billed to customers. Valid values are Y or N. | ||
PJC_CAPITALIZABLE_FLAG | VARCHAR2 | 1 | Flag that indicates if a project-related item is eligible for capitalization. Valid values are Y or N. | ||
PJC_WORK_TYPE_ID | NUMBER | 18 | Identifier for project-related classification of the worked performed. | ||
PJC_CONTRACT_ID | NUMBER | 18 | Identifier of contract. This attribute is used when Oracle Contract Billing or Oracle Grants Accounting is installed. | ||
PJC_CONTRACT_LINE_ID | NUMBER | 18 | Tracks contract line information. This attribute is used when Oracle Contract Billing or Oracle Grants Accounting is installed. | ||
PJC_FUNDING_ALLOCATION_ID | NUMBER | 18 | Specifies the name of the project funding override. This attribute is used when Oracle Contract Billing or Oracle Grants Accounting is installed. | ||
PJC_RESERVED_ATTRIBUTE1 | VARCHAR2 | 150 | Reserved for project-related functionality. | ||
PJC_RESERVED_ATTRIBUTE2 | VARCHAR2 | 150 | Reserved for future project-related functionality. | ||
PJC_RESERVED_ATTRIBUTE3 | VARCHAR2 | 150 | Reserved for future project-related functionality. | ||
PJC_RESERVED_ATTRIBUTE4 | VARCHAR2 | 150 | Reserved for future project-related functionality. | ||
PJC_RESERVED_ATTRIBUTE5 | VARCHAR2 | 150 | Reserved for future project-related functionality. | ||
PJC_RESERVED_ATTRIBUTE6 | VARCHAR2 | 150 | Reserved for future project-related functionality. | ||
PJC_RESERVED_ATTRIBUTE7 | VARCHAR2 | 150 | Reserved for future project-related functionality. | ||
PJC_RESERVED_ATTRIBUTE8 | VARCHAR2 | 150 | Reserved for future project-related functionality. | ||
PJC_RESERVED_ATTRIBUTE9 | VARCHAR2 | 150 | Reserved for future project-related functionality. | ||
PJC_RESERVED_ATTRIBUTE10 | VARCHAR2 | 150 | Reserved for future project-related functionality. | ||
PJC_USER_DEF_ATTRIBUTE1 | VARCHAR2 | 150 | Reserved for user-definable project information. | ||
PJC_USER_DEF_ATTRIBUTE2 | VARCHAR2 | 150 | Reserved for user-definable project information. | ||
PJC_USER_DEF_ATTRIBUTE3 | VARCHAR2 | 150 | Reserved for user-definable project information. | ||
PJC_USER_DEF_ATTRIBUTE4 | VARCHAR2 | 150 | Reserved for user-definable project information. | ||
PJC_USER_DEF_ATTRIBUTE5 | VARCHAR2 | 150 | Reserved for user-definable project information. | ||
PJC_USER_DEF_ATTRIBUTE6 | VARCHAR2 | 150 | Reserved for user-definable project information. | ||
PJC_USER_DEF_ATTRIBUTE7 | VARCHAR2 | 150 | Reserved for user-definable project information. | ||
PJC_USER_DEF_ATTRIBUTE8 | VARCHAR2 | 150 | Reserved for user-definable project information. | ||
PJC_USER_DEF_ATTRIBUTE9 | VARCHAR2 | 150 | Reserved for user-definable project information. | ||
PJC_USER_DEF_ATTRIBUTE10 | VARCHAR2 | 150 | Reserved for user-definable project information. | ||
REASON_FOR_REPAIR_CODE_ID | NUMBER | 18 | Represents the reason for which this repair operation is performed. Foreign key to cse_condition_event_codes_b table. | ||
REPAIR_TXN_CODE_ID | NUMBER | 18 | Represents the code to which this repair transaction is applicable. Foreign key to cse_condition_event_codes_b table. | ||
WORK_ACCOMPLISHED_CODE_ID | NUMBER | 18 | Represents the accomplishment code recorded at resource transaction. Foreign key to cse_condition_event_codes_b table. | ||
WORKSTATION_ID | NUMBER | 18 | Foreign key to the workstation used when performing this transaction. | ||
ASSEMBLY_ASSET_ID | NUMBER | 18 | The work order asset for which the resource transactions are performed. | ||
CREATED_BY | VARCHAR2 | 64 | Yes | Who column: indicates the user who created the row. | |
CREATION_DATE | TIMESTAMP | Yes | Who column: indicates the date and time of the creation of the row. | ||
LAST_UPDATED_BY | VARCHAR2 | 64 | Yes | Who column: indicates the user who last updated the row. | |
LAST_UPDATE_DATE | TIMESTAMP | Yes | Who column: indicates the date and time of the last update of the row. | ||
LAST_UPDATE_LOGIN | VARCHAR2 | 32 | Who column: indicates the session login associated to the user who last updated the row. | ||
ATTRIBUTE_CATEGORY | VARCHAR2 | 80 | Descriptive Flexfield: structure definition of the user descriptive flexfield. | ||
ATTRIBUTE_CHAR1 | VARCHAR2 | 240 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
ATTRIBUTE_CHAR2 | VARCHAR2 | 240 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
ATTRIBUTE_CHAR3 | VARCHAR2 | 240 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
ATTRIBUTE_CHAR4 | VARCHAR2 | 240 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
ATTRIBUTE_CHAR5 | VARCHAR2 | 240 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
ATTRIBUTE_CHAR6 | VARCHAR2 | 240 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
ATTRIBUTE_CHAR7 | VARCHAR2 | 240 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
ATTRIBUTE_CHAR8 | VARCHAR2 | 240 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
ATTRIBUTE_CHAR9 | VARCHAR2 | 240 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
ATTRIBUTE_CHAR10 | VARCHAR2 | 240 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
ATTRIBUTE_CHAR11 | VARCHAR2 | 240 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
ATTRIBUTE_CHAR12 | VARCHAR2 | 240 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
ATTRIBUTE_CHAR13 | VARCHAR2 | 240 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
ATTRIBUTE_CHAR14 | VARCHAR2 | 240 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
ATTRIBUTE_CHAR15 | VARCHAR2 | 240 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
ATTRIBUTE_CHAR16 | VARCHAR2 | 240 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
ATTRIBUTE_CHAR17 | VARCHAR2 | 240 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
ATTRIBUTE_CHAR18 | VARCHAR2 | 240 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
ATTRIBUTE_CHAR19 | VARCHAR2 | 240 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
ATTRIBUTE_CHAR20 | VARCHAR2 | 240 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
ATTRIBUTE_NUMBER1 | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
ATTRIBUTE_NUMBER2 | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
ATTRIBUTE_NUMBER3 | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
ATTRIBUTE_NUMBER4 | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
ATTRIBUTE_NUMBER5 | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
ATTRIBUTE_NUMBER6 | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
ATTRIBUTE_NUMBER7 | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
ATTRIBUTE_NUMBER8 | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
ATTRIBUTE_NUMBER9 | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
ATTRIBUTE_NUMBER10 | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
ATTRIBUTE_DATE1 | DATE | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
ATTRIBUTE_DATE2 | DATE | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
ATTRIBUTE_DATE3 | DATE | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
ATTRIBUTE_DATE4 | DATE | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
ATTRIBUTE_DATE5 | DATE | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
ATTRIBUTE_TIMESTAMP1 | TIMESTAMP | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
ATTRIBUTE_TIMESTAMP2 | TIMESTAMP | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
ATTRIBUTE_TIMESTAMP3 | TIMESTAMP | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
ATTRIBUTE_TIMESTAMP4 | TIMESTAMP | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
ATTRIBUTE_TIMESTAMP5 | TIMESTAMP | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
REQUEST_ID | NUMBER | 18 | Enterprise Service Scheduler: indicates the request ID of the job that created or last updated the row. | ||
JOB_DEFINITION_NAME | VARCHAR2 | 100 | Enterprise Service Scheduler: indicates the name of the job that created or last updated the row. | ||
JOB_DEFINITION_PACKAGE | VARCHAR2 | 900 | Enterprise Service Scheduler: indicates the package name of the job that created or last updated the row. |
Indexes
Index | Uniqueness | Tablespace | Columns |
---|---|---|---|
WIE_RESOURCE_TXNS_N01 | Non Unique | Default | ORGANIZATION_ID |
WIE_RESOURCE_TXNS_N02 | Non Unique | Default | WORK_ORDER_ID |
WIE_RESOURCE_TXNS_N03 | Non Unique | Default | TXN_HEADER_ID |
WIE_RESOURCE_TXNS_N04 | Non Unique | Default | WO_OPERATION_ID |
WIE_RESOURCE_TXNS_N05 | Non Unique | Default | INTERFACE_ROW_ID |
WIE_RESOURCE_TXNS_N06 | Non Unique | Default | WO_OPERATION_RESOURCE_ID |
WIE_RESOURCE_TXNS_N07 | Non Unique | Default | WORKSTATION_ID |
WIE_RESOURCE_TXNS_U01 | Unique | Default | WO_RESOURCE_TRANSACTION_ID |