CST_PREP_ERRORS_I_GT
This table holds the errors for the transactions processed by the PreProcessor. At the end of each block, the errors are aggregated and inserted into CST_CP_ERRORS table to get persisted. The transaction level details of the error is inserted into CST_TRANSACTION_ERRORS.
Details
-
Schema: FUSION
-
Object owner: CST
-
Object type: TABLE
-
Tablespace: Default
Columns
| Name | Datatype | Length | Precision | Not-null | Comments |
|---|---|---|---|---|---|
| RUN_CONTROL | VARCHAR2 | 30 | Yes | Identifies the Run Control used for cost processing. | |
| 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 | Reference to the unique identifier for the inventory organization | ||
| INVENTORY_ITEM_ID | NUMBER | 18 | Reference to the unique identifier for the inventory item | ||
| TRANSACTION_DATE | TIMESTAMP | This is the date when the transaction was processed. | |||
| 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 transaction 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 transaction IDs taken together determine the transaction type shown on the UI. | ||
| BASE_TXN_ACTION_ID | NUMBER | 18 | Inventory transaction action identifier. The 3 base transaction IDs taken together determine the transaction type shown on the UI. | ||
| COST_ORG_ID | NUMBER | 18 | Surrogate ID identifying the cost organization. | ||
| COST_BOOK_ID | NUMBER | 18 | Surrogate ID identifying the cost book. | ||
| VAL_UNIT_ID | NUMBER | 18 | Surrogate ID identifying the valuation unit. | ||
| TABLE_NAME | VARCHAR2 | 30 | Identifies the source table from which the error or event was generated. | ||
| 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 | Reference Information from an External system (external to Cost Management). | ||
| 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 | Subprocessor 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. |
Indexes
| Index | Uniqueness | Columns |
|---|---|---|
| CST_PREP_ERRORS_I_GT_N1 | Non Unique | RUN_CONTROL, PROCESSOR_NAME, ERROR_CODE, COST_ORG_ID, COST_BOOK_ID, TABLE_NAME, TOKEN1_VALUE, TOKEN2_VALUE, TOKEN3_VALUE, TOKEN4_VALUE, TOKEN5_VALUE, TOKEN6_VALUE |