CST_TRANSACTION_ERRORS
The purpose of this table is to store the external system references (and transaction ids where available) that are affected by the errors logged during a cost process run. All processors that are a part of the cost process create the data in this table. The transaction information is displayed in the review cost accounting processes UI to see the details of the transactions affected by a particular error. Note that not all errors will have corresponding transactions for it. For Fusion v1, the data in this table will be maintained for only the past 5 request ids for a given cost organization and book.
Details
-
Schema: FUSION
-
Object owner: CST
-
Object type: TABLE
-
Tablespace: FUSION_TS_TX_DATA
Primary Key
| Name | Columns |
|---|---|
|
CST_TRANSACTION_ERRORS_PK |
CP_ERROR_ID, EXTERNAL_SYSTEM_REFERENCE, EXTERNAL_SYSTEM_REF_ID, TRANSACTION_ID, WO_RES_EXT_SYSTEM_REF_ID, WO_OP_EXT_SYSTEM_REF_ID, WO_EXT_SYSTEM_REF_ID |
Columns
| Name | Datatype | Length | Precision | Not-null | Comments |
|---|---|---|---|---|---|
| CP_ERROR_ID | NUMBER | 18 | Yes | Identifies the unique cost process error in the CST_CP_ERRORS table. | |
| EXTERNAL_SYSTEM_REFERENCE | VARCHAR2 | 60 | Yes | Identifies an inventory transaction source for which an error occured. | |
| EXTERNAL_SYSTEM_REF_ID | VARCHAR2 | 30 | Yes | Identifies an inventory transaction for which an error occured. | |
| WO_RES_EXT_SYSTEM_REF_ID | VARCHAR2 | 30 | Yes | Identifies the resource transaction in the source system. | |
| WO_OP_EXT_SYSTEM_REF_ID | VARCHAR2 | 30 | Yes | Surrogate ID identifying the operation transaction in source manufacturing systems. Default 0. | |
| WO_EXT_SYSTEM_REF_ID | VARCHAR2 | 30 | Yes | Surrogate ID identifying the work order in source manufacturing system. Default 0. | |
| TRANSACTION_ID | NUMBER | 18 | Yes | Identifies a cost transaction for which an error occured. | |
| 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. | ||
| 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 |
|---|---|---|---|---|
| CST_TRANSACTION_ERRORS_N1 | Non Unique | FUSION_TS_TX_DATA | REQUEST_ID, TRANSACTION_ID | |
| CST_TRANSACTION_ERRORS_N2 | Non Unique | FUSION_TS_TX_DATA | EXTERNAL_SYSTEM_REFERENCE, EXTERNAL_SYSTEM_REF_ID | Obsolete |
| CST_TRANSACTION_ERRORS_N3 | Non Unique | Default | EXTERNAL_SYSTEM_REFERENCE, EXTERNAL_SYSTEM_REF_ID, TRANSACTION_ID, WO_RES_EXT_SYSTEM_REF_ID, WO_OP_EXT_SYSTEM_REF_ID, WO_EXT_SYSTEM_REF_ID | |
| CST_TRANSACTION_ERRORS_U1 | Unique | FUSION_TS_TX_DATA | CP_ERROR_ID, EXTERNAL_SYSTEM_REFERENCE, EXTERNAL_SYSTEM_REF_ID, TRANSACTION_ID, WO_RES_EXT_SYSTEM_REF_ID, WO_OP_EXT_SYSTEM_REF_ID, WO_EXT_SYSTEM_REF_ID |