CST_REQ_ERRORS_INT
This is an interface table that is internally used to store the functional errors identified by the sub-processors that can run concurrently. Once the sub-processors complete, the parent process will aggregate these errors into the cst_cp_errors table used in error reporting.
Details
-
Schema: FUSION
-
Object owner: CST
-
Object type: TABLE
-
Tablespace: INTERFACE
Columns
| Name | Datatype | Length | Precision | Not-null | Comments |
|---|---|---|---|---|---|
| PARENT_REQUEST_ID | NUMBER | 18 | Yes | ESS Request ID of the parent process for which errors are recorded. | |
| ROW_COUNT | NUMBER | 18 | Count of transactions that failed with the specific error reported. | ||
| RUN_CONTROL | VARCHAR2 | 30 | Indicates the run control of the create cost accounting distributions process. | ||
| PROCESSOR_NAME | VARCHAR2 | 30 | Yes | The lookup code from the FND Lookup table for the processor name (FND_LOOKUPS.LOOKUP_CODE). Typically the Alternate Short Name of the LBA (Logical Business Area); for example: RUNC, COGS, PE, etc. | |
| ERROR_CODE | VARCHAR2 | 30 | Yes | The message name code from the FND Messages table (FND_MESSAGES.MESSAGE_NAME). | |
| MESSAGE_TYPE | VARCHAR2 | 30 | Message type. When used as part of the Cost Process this can be left as null because the Cost Process will automatically derive message types at the end of every run. Other processes using this table but are not part of the Cost Process will need to derive the message type manually. The Message type value is derived from FND_MESSAGES.TYPE based on the error code. | ||
| MESSAGE | VARCHAR2 | 240 | Resolved message text. When used as part of the Cost Process this can be left as null because the Cost Process will automatically resolve messages at the end of every run. Other processes using this table but are not part of the Cost Process will need to resolve the message manually. | ||
| INVENTORY_ORG_ID | NUMBER | 18 | Identifier of the inventory organization for which error is reported. | ||
| INVENTORY_ITEM_ID | NUMBER | 18 | Identifier of the item for which error is reported. | ||
| TRANSACTION_DATE | TIMESTAMP | User entered transaction date of the transaction for which error is reported. | |||
| ACCOUNTED_DATE | TIMESTAMP | Accounted date is used in the Period End Validation flow. | |||
| BASE_TXN_TYPE_ID | NUMBER | 18 | Inventory transaction type identifier. The 3 base txn IDs taken together determine the transaction type shown on the UI. | ||
| BASE_TXN_SOURCE_TYPE_ID | NUMBER | 18 | Inventory transaction source type identifier. The 3 base txn IDs taken together determine the transaction type shown on the UI. | ||
| BASE_TXN_ACTION_ID | NUMBER | 18 | Inventory transaction action identifier. The 3 base txn IDs taken together determine the transaction type shown on the UI. | ||
| COST_ORG_ID | NUMBER | 18 | Identifier of the cost organization for which the error is reported. | ||
| COST_BOOK_ID | NUMBER | 18 | Identifier of the cost book for which error is reported. | ||
| VAL_UNIT_ID | NUMBER | 18 | Identifier of the valuation unit for which error is reported. | ||
| TABLE_NAME | VARCHAR2 | 30 | Source table name which generated this error message. | ||
| TABLE_ROW_ID | VARCHAR2 | 18 | Table Row ID stores the surrogate key reference or table rowid to uniquely identify the row within the given table. This value is required if displaying detail level information on the review UI. | ||
| EXTERNAL_SYSTEM_REFERENCE | VARCHAR2 | 60 | Identifies the external source system. In case of inventory transfers it is CST with parent transaction identifier relating to original row. | ||
| EXTERNAL_SYSTEM_REF_ID | VARCHAR2 | 30 | Stores a value that uniquely identifies a certain instance of an object within the external system. | ||
| SUBPROCESSOR_NAME | VARCHAR2 | 900 | Sub-processor Name. This value is the direct name and not a look up. | ||
| TOKEN1_NAME | VARCHAR2 | 30 | Token name as required by error code message. | ||
| TOKEN1_VALUE | VARCHAR2 | 240 | Token value as required by error code message. | ||
| TOKEN2_NAME | VARCHAR2 | 30 | Token name as required by error code message. | ||
| TOKEN2_VALUE | VARCHAR2 | 240 | Token value as required by error code message. | ||
| TOKEN3_NAME | VARCHAR2 | 30 | Token name as required by error code message. | ||
| TOKEN3_VALUE | VARCHAR2 | 240 | Token value as required by error code message. | ||
| TOKEN4_NAME | VARCHAR2 | 30 | Token name as required by error code message. | ||
| TOKEN4_VALUE | VARCHAR2 | 240 | Token value as required by error code message. | ||
| TOKEN5_NAME | VARCHAR2 | 30 | Token name as required by error code message. | ||
| TOKEN5_VALUE | VARCHAR2 | 240 | Token value as required by error code message. | ||
| TOKEN6_NAME | VARCHAR2 | 30 | Token name as required by error code message. | ||
| TOKEN6_VALUE | VARCHAR2 | 240 | Token value as required by error code message. | ||
| CREATION_DATE | TIMESTAMP | Yes | Who column: indicates the date and time of the creation of the row. | ||
| CREATED_BY | VARCHAR2 | 64 | Yes | Who column: indicates the user who created 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. |
Indexes
| Index | Uniqueness | Tablespace | Columns |
|---|---|---|---|
| CST_REQ_ERRORS_INT_N1 | Non Unique | DEFAULT | PARENT_REQUEST_ID |