WIE_OPERATION_TRANSACTIONS_INT
This is the interface table for work order operation transactions. Production progress updates, in terms of partial finished assembly that are completed in an operation, can be interfaced from either third party systems or from contract manufacturers via this interface table. When assembly movements cross over operations that result in automatic material consumption (auto transact materials) or automatic charging of resources, the operation transaction processor writes the appropriate inventory material transaction interface records and WIP resource transaction interface entries and processes them accordingly. Scraps and Rejects are reported at the operation transaction level.
Details
-
Schema: FUSION
-
Object owner: WIE
-
Object type: TABLE
-
Tablespace: INTERFACE
Primary Key
| Name | Columns |
|---|---|
|
WIE_OPER_TXNS_INT_PK |
INTERFACE_ROW_ID |
Columns
| Name | Datatype | Length | Precision | Not-null | Comments | Status |
|---|---|---|---|---|---|---|
| INTERFACE_ROW_ID | NUMBER | 18 | Yes | The unique identifier of an operation transaction interface 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. | ||
| INTERFACE_BATCH_CODE | VARCHAR2 | 30 | Represents the user identified code for the interface batch. | |||
| INTERFACE_BATCH_ID | NUMBER | 18 | Represents the internal interface batch identifier. This is used to group a batch of interface records for processing. When interface records are brought in via services or the UI, the system will internally generate this value. | |||
| INTERFACE_STATUS_CODE | VARCHAR2 | 30 | Yes | Represents the progress of the interface processing with statuses such as ready for processing or currently in process as well as the various flavors of completion statuses. Valid values exist in the lookup with lookup type = ORA_WIE_INTERFACE_STATUS. | ||
| TXN_HEADER_NUMBER | VARCHAR2 | 18 | This is a user loaded key that uniquely identifies the transaction within the batch. This user key will be used as a handle to connect the child entities (i.e. the WIE_TRANSACTION_LOTS_INT and WIE_TRANSACTION_SERIALS_INT tables) to this parent transaction table. | |||
| ORGANIZATION_CODE | VARCHAR2 | 30 | The organization code that represents the manufacturing plant to which this operation transaction is performed. | |||
| ORGANIZATION_ID | NUMBER | 18 | The organization identifier that represents the manufacturing plant to which this operation transaction is performed. | |||
| WORK_ORDER_NUMBER | VARCHAR2 | 120 | Represents the user-facing identifier of the work order. Operation transactions are always performed in the context of a work order. | |||
| WORK_ORDER_ID | NUMBER | 18 | Represents the internal identifier of the work order. Operation transactions are always performed in the context of a work order. | |||
| WO_OPERATION_SEQ_NUMBER | NUMBER | Represents the work order operation sequence from which this operation transaction is being performed. | ||||
| WO_OPERATION_ID | NUMBER | 18 | The operation from which the primary product quantity is transacted. | |||
| INVENTORY_ITEM_ID | NUMBER | 18 | The primary product identifier defined on the work order. This is an internal column and is de-normalized. | |||
| FROM_DISPATCH_STATE | VARCHAR2 | 30 | Yes | The status from which this transaction takes place. Valid values exist in the lookup with lookup type = ORA_WIE_DISPATCH_STATE. | ||
| TO_DISPATCH_STATE | VARCHAR2 | 30 | Yes | The end resulting status where the transaction quantity moves to. Valid values exist in the lookup with lookup type = ORA_WIE_DISPATCH_STATE. | ||
| TRANSACTION_DATE | TIMESTAMP | Yes | Date when the operation transaction is performed. | |||
| TRANSACTION_QUANTITY | NUMBER | Yes | Represents the quantity of the operation transaction. | |||
| TRANSACTION_UOM_CODE | VARCHAR2 | 3 | Represents the unit of measure code of the primary product quantity being transacted. | |||
| TRANSACTION_UNIT_OF_MEASURE | VARCHAR2 | 25 | Represents the unit of measure of the primary product quantity being transacted. | |||
| SECONDARY_TRANSACTION_QUANTITY | NUMBER | Represents the secondary quantity for a material transaction if the item is dual UOM enabled. | ||||
| SECONDARY_UOM_CODE | VARCHAR2 | 3 | Represents the secondary UOM for a material transaction if the item is dual UOM enabled. | |||
| SECONDARY_UNIT_OF_MEASURE | VARCHAR2 | 25 | Represents the secondary unit of measure for a material transaction if the item is dual UOM enabled. | |||
| REASON_CODE | VARCHAR2 | 30 | Indicates the reason code for the operation transaction. Primarily used when rejecting or scrapping quantities at the operation. | |||
| WORK_METHOD_CODE | VARCHAR2 | 30 | Represents the work method code for which this operation transaction is applicable. | |||
| WORK_METHOD_ID | NUMBER | 18 | Represents the work method for which this operation transaction is applicable. It is a foreign key to the WIS_WORK_METHODS_B table. | |||
| COMPL_SUBINVENTORY_CODE | VARCHAR2 | 18 | Subinventory where the material is drawn from or where the products are completed. | |||
| COMPL_LOCATOR_SEGMENT1 | VARCHAR2 | 40 | Represents the completion locator flexfield segment. | |||
| COMPL_LOCATOR_SEGMENT2 | VARCHAR2 | 40 | Represents the completion locator flexfield segment. | |||
| COMPL_LOCATOR_SEGMENT3 | VARCHAR2 | 40 | Represents the completion locator flexfield segment. | |||
| COMPL_LOCATOR_SEGMENT4 | VARCHAR2 | 40 | Represents the completion locator flexfield segment. | |||
| COMPL_LOCATOR_SEGMENT5 | VARCHAR2 | 40 | Represents the completion locator flexfield segment. | |||
| COMPL_LOCATOR_SEGMENT6 | VARCHAR2 | 40 | Represents the completion locator flexfield segment. | |||
| COMPL_LOCATOR_SEGMENT7 | VARCHAR2 | 40 | Represents the completion locator flexfield segment. | |||
| COMPL_LOCATOR_SEGMENT8 | VARCHAR2 | 40 | Represents the completion locator flexfield segment. | |||
| COMPL_LOCATOR_SEGMENT9 | VARCHAR2 | 40 | Represents the completion locator flexfield segment. | |||
| COMPL_LOCATOR_SEGMENT10 | VARCHAR2 | 40 | Represents the completion locator flexfield segment. | |||
| COMPL_LOCATOR_SEGMENT11 | VARCHAR2 | 40 | Represents the completion locator flexfield segment. | |||
| COMPL_LOCATOR_SEGMENT12 | VARCHAR2 | 40 | Represents the completion locator flexfield segment. | |||
| COMPL_LOCATOR_SEGMENT13 | VARCHAR2 | 40 | Represents the completion locator flexfield segment. | |||
| COMPL_LOCATOR_SEGMENT14 | VARCHAR2 | 40 | Represents the completion locator flexfield segment. | |||
| COMPL_LOCATOR_SEGMENT15 | VARCHAR2 | 40 | Represents the completion locator flexfield segment. | |||
| COMPL_LOCATOR_SEGMENT16 | VARCHAR2 | 40 | Represents the completion locator flexfield segment. | |||
| COMPL_LOCATOR_SEGMENT17 | VARCHAR2 | 40 | Represents the completion locator flexfield segment. | |||
| COMPL_LOCATOR_SEGMENT18 | VARCHAR2 | 40 | Represents the completion locator flexfield segment. | |||
| COMPL_LOCATOR_SEGMENT19 | VARCHAR2 | 40 | Represents the completion locator flexfield segment. | |||
| COMPL_LOCATOR_SEGMENT20 | VARCHAR2 | 40 | Represents the completion locator flexfield segment. | |||
| COMPL_LOCATOR_ID | NUMBER | The inventory locator where the materials are drawn from or where the products are completed to. | ||||
| TRANSACTION_NOTE | VARCHAR2 | 4000 | A note that is captured upon performing the operation transaction. | |||
| SOLD_TO_LEGAL_ENTITY_ID | NUMBER | 18 | The legal entity identifier of the enterprise that is procuring goods/services from the supplier. | |||
| SOLD_TO_LEGAL_ENTITY_NAME | VARCHAR2 | 240 | The legal entity name of the enterprise that is procuring goods/services from the supplier. | |||
| PO_NUMBER | VARCHAR2 | 30 | The user key to the Fusion Purchase Order Number. | |||
| PO_HEADER_ID | NUMBER | 18 | The Fusion Purchase Order Identifier. The system key. | |||
| PO_LINE_NUMBER | NUMBER | The Fusion Purchase Order Line Number. The user key. | ||||
| PO_LINE_ID | NUMBER | 18 | The Fusion Purchase Order Line Number. The system key identifier. | |||
| 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 | To complete the interface cycle, the operation transaction processor updates the operation_transaction_id in this table after successfully processing the transactions. | |||
| WO_OP_TXN_GROUP_ID | NUMBER | 18 | A unique identifier used to group multiple operation transactions together. Its primary usage is to support linking electronic records and signatures (ERES) artifacts to one or more operation transactions. | |||
| INV_TRANSACTION_INTERFACE_ID | NUMBER | 18 | This is the identifier of the record that is written into the INV_TRANSACTIONS_INTERFACE table to process the completion (or the return) material transaction. This will be populated only for the "Move and Complete" and "Return and Move" scenarios. | |||
| INV_TRANSACTION_HEADER_ID | NUMBER | 18 | This is the TRANSACTION_HEADER_ID that is populated into the INV_TRANSACTIONS_INTERFACE. This acts as a group handle in invoking the online inventory API. When the move transaction process also writes backflush component consumption records in INV_TRANSACTIONS_INTERFACE, the same TRANSACTION_HEADER_ID value is populated for the backflush transaction. | |||
| INSPECTION_EVENT_ID | NUMBER | 18 | Foreign key to the quality inspection results that were collected while performing this transaction. | |||
| COUNTRY_OF_ORIGIN_CODE | VARCHAR2 | 2 | Code for the country of manufacture used to stripe Inventory transactions. | |||
| CHANGE_EXECUTION_SEQUENCE_FLAG | VARCHAR2 | 1 | Flag to indicate that the re-sequence operation should be executed by bringing in the ready quantity before doing operation completion. | Obsolete | ||
| EXECUTION_SEQUENCE | NUMBER | Indicates the execution sequence of the operation when the operation transaction is performed. | ||||
| NEXT_EXEC_OP_SEQ_NUMBER | NUMBER | Indicates the operation sequence number to which the ready quantity needs to be moved to. | ||||
| UNDER_COMPLETE_FLAG | VARCHAR2 | 1 | Flag to indicate that the work order is to be marked as under-completed as a result of this operation transaction. | |||
| WORKER_ID | NUMBER | The partition number for multi-threading. | ||||
| CREATED_BY | VARCHAR2 | 64 | Who column: indicates the user who created the row. | |||
| CREATION_DATE | TIMESTAMP | Who column: indicates the date and time of the creation of the row. | ||||
| LAST_UPDATED_BY | VARCHAR2 | 64 | Who column: indicates the user who last updated the row. | |||
| LAST_UPDATE_DATE | TIMESTAMP | 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. | ||||
| LOAD_REQUEST_ID | NUMBER | 18 | This column is used when loading data from the csv file to the interface table using the central ESS program. This is the request id for the job that did the move from UCM to the interface table. | |||
| 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 | Status |
|---|---|---|---|---|
| WIE_OPER_TXNS_INT_N01 | Non Unique | Default | WORK_ORDER_ID | |
| WIE_OPER_TXNS_INT_N02 | Non Unique | Default | WORK_ORDER_NUMBER, ORGANIZATION_CODE | |
| WIE_OPER_TXNS_INT_N03 | Non Unique | Default | WORK_ORDER_NUMBER, ORGANIZATION_ID | |
| WIE_OPER_TXNS_INT_N04 | Non Unique | Default | WORKER_ID | Obsolete |
| WIE_OPER_TXNS_INT_N05 | Non Unique | Default | WORKER_ID, INTERFACE_STATUS_CODE | |
| WIE_OPER_TXNS_INT_N06 | Non Unique | Default | REQUEST_ID, INTERFACE_STATUS_CODE | |
| WIE_OPER_TXNS_INT_N07 | Non Unique | Default | INTERFACE_BATCH_ID, INTERFACE_STATUS_CODE | |
| WIE_OPER_TXNS_INT_N08 | Non Unique | Default | INTERFACE_BATCH_CODE, INTERFACE_STATUS_CODE | |
| WIE_OPER_TXNS_INT_N09 | Non Unique | Default | LAST_UPDATE_DATE, INTERFACE_STATUS_CODE | |
| WIE_OPER_TXNS_INT_U01 | Unique | Default | INTERFACE_ROW_ID |