CST_DB_ERRORS
Transactions that cause the background process to end with an unexpected error are captured here and the info here is used to quarantine those transactions so that the next run can process the unaffected transactions.
Details
-
Schema: FUSION
-
Object owner: CST
-
Object type: TABLE
-
Tablespace: FUSION_TS_TX_DATA
Columns
| Name | Datatype | Length | Precision | Not-null | Comments |
|---|---|---|---|---|---|
| ORA_ERR_NUMBER$ | NUMBER | Oracle Error Number logged by the Oracle Error loggin feature. | |||
| ORA_ERR_MESG$ | VARCHAR2 | 2000 | Oracle Error message logged by the Oracle Error loggin feature. | ||
| ORA_ERR_ROWID$ | UROWID | 4000 | ROWID of the error row logged by the Oracle Error loggin feature. | ||
| ORA_ERR_OPTYP$ | VARCHAR2 | 2 | Type of the error logged by the Oracle Error loggin feature. e.g. I - Insert, D - Delete, U - Update. | ||
| ORA_ERR_TAG$ | VARCHAR2 | 2000 | Identifies the tag for the logged error. The tag is concatenated string of request_id and the sql name in the error. | ||
| TRANSACTION_ID | NUMBER | 18 | Identifies a costing transaction if the SQL in the error references it. | ||
| CMR_PO_DISTRIBUTION_ID | NUMBER | 18 | Identifies a PO Distribution if the SQL in the error references it. | ||
| CMR_AP_INVOICE_DIST_ID | NUMBER | 18 | Identifies a AP Invoice Distribution if the SQL in the error references it. | ||
| CST_INV_TRANSACTION_ID | NUMBER | 18 | Identifies a Inventory Transaction if the SQL in the error references it. | ||
| EXTERNAL_SYSTEM_REF_ID | VARCHAR2 | 60 | Identifies an Interface Reference Id if the SQL in the error references it. | ||
| EXTERNAL_SYSTEM_REFERENCE | VARCHAR2 | 60 | Identifies an Interface Reference if the SQL in the error references it. | ||
| CMR_RCV_TRANSACTION_ID | NUMBER | 18 | Identifies a Receiving Transaction if the SQL in the error references it. | ||
| TRADE_EVENT_ID | NUMBER | 18 | Identifies a Trade event if the SQL in the error references it. | ||
| QUARANTINE_STATUS | VARCHAR2 | 1 | Indicate the quarantine status of the error row. N - Not Quarantined, I - In Progress, Y - Quarantined. | ||
| DEST_TRANSACTION_ID | NUMBER | 18 | Identifies a Destination Transfer transaction if the SQL in the error references it. | ||
| CST_WORK_ORDER_ID | NUMBER | 18 | Identifies a Work Order for Manufacturing Transaction if the SQL in the error references it. | ||
| RESOURCE_TRANSACTION_ID | NUMBER | 18 | Identifies a Manufacturing Resource Transaction if the SQL in the error references it. | ||
| OPERATION_TRANSACTION_ID | NUMBER | 18 | Identifies a Manufacturing Operation Transaction if the SQL in the error references it. | ||
| SCENARIO_ROLLUP_HEADER_ID | NUMBER | 18 | Identifies a Rollup header if the SQL in the error references it. | ||
| INVENTORY_ITEM_ID | NUMBER | 18 | Inventory Item Identifier | ||
| 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. |