WIE_OPERATION_TRANSACTIONS
This table stores the operation transactions that are recorded for the primary product as the semi finished assembly gets completed and moves from one operation to another. These transactions include operation completion, primary product scrap, primary product reject, as well as, reversal transactions.
Details
-
Schema: FUSION
-
Object owner: WIE
-
Object type: TABLE
-
Tablespace: Default
Primary Key
| Name | Columns |
|---|---|
|
WIE_OPERATION_TRANSACTIONS_PK |
WO_OPERATION_TRANSACTION_ID |
Columns
| Name | Datatype | Length | Precision | Not-null | Comments |
|---|---|---|---|---|---|
| WO_OPERATION_TRANSACTION_ID | NUMBER | 18 | Yes | The unique identifier of an operation 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 operation transaction is performed. | |
| WORK_ORDER_ID | NUMBER | 18 | Yes | Represents the internal identifier of the work order. Operation transactions are always performed in the context of a work order. | |
| WO_OPERATION_ID | NUMBER | 18 | Yes | The operation from which the primary product quantity is transacted. | |
| INVENTORY_ITEM_ID | NUMBER | 18 | Yes | 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_TYPE_CODE | VARCHAR2 | 30 | Yes | Represents the type of operation transaction and will be derived based on the content in FROM_DISPATCH_STATE and TO_DISPATCH_STATE. Valid values exist in the lookup with lookup type = ORA_WIE_OP_TRANSACTION_TYPE. | |
| TRANSACTION_DATE | TIMESTAMP | Yes | Date when the operation transaction is performed. | ||
| TRANSACTION_QUANTITY | NUMBER | Yes | Transactional product quantity that is transacted. | ||
| TRANSACTION_UOM_CODE | VARCHAR2 | 3 | Yes | Transactional unit of measure code of the primary product 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. | |
| REASON_CODE | VARCHAR2 | 30 | Reason for either rejecting the quantities at the operation or scrapping at the operation. | ||
| COMPL_SUBINVENTORY_CODE | VARCHAR2 | 18 | Subinventory where the material is drawn from or where the products are completed. | ||
| 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. | ||
| PO_HEADER_ID | NUMBER | 18 | The Fusion Purchase Order Identifier. The system 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. | ||
| INV_TRANSACTION_ID | NUMBER | 18 | Upon successful processing of the completion/return material transaction (the product level transaction associated with the move), we record the successful INV_MATERIAL_TXNS.TRANSACTION_ID back in this column. The INV online API returns this value. | ||
| INTERFACE_ROW_ID | NUMBER | 18 | Represents the operation transactions interface record. | ||
| INTERFACE_BATCH_ID | NUMBER | 18 | Represents the interface batch identifier. | ||
| 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. | ||
| 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. | |
| INSPECTION_EVENT_ID | NUMBER | 18 | Foreign key to the quality inspection results that were collected while performing this transaction. | ||
| WORKER_ID | NUMBER | Represents the identifier that is the unique link to the interface records used when an operation transaction was performed via FBDI/REST/UI. Since the interface records are immediately purged after a successful commit, processes that happen immediately after commit can utilize this to get the operation transaction details. | |||
| 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. |
Foreign Keys
| Table | Foreign Table | Foreign Key Column |
|---|---|---|
| wie_transaction_serials | wie_operation_transactions | WO_TRANSACTION_ID |
| wie_transaction_lots | wie_operation_transactions | WO_TRANSACTION_ID |
Indexes
| Index | Uniqueness | Tablespace | Columns |
|---|---|---|---|
| WIE_OPERATION_TRANSACTIONS_N01 | Non Unique | Default | ORGANIZATION_ID |
| WIE_OPERATION_TRANSACTIONS_N02 | Non Unique | Default | WORK_ORDER_ID |
| WIE_OPERATION_TRANSACTIONS_N03 | Non Unique | Default | REQUEST_ID |
| WIE_OPERATION_TRANSACTIONS_N04 | Non Unique | Default | WORKER_ID |
| WIE_OPERATION_TRANSACTIONS_N05 | Non Unique | Default | WO_OPERATION_ID |
| WIE_OPERATION_TRANSACTIONS_N06 | Non Unique | Default | INTERFACE_ROW_ID |
| WIE_OPERATION_TRANSACTIONS_U01 | Unique | Default | WO_OPERATION_TRANSACTION_ID |