CST_PREP_ERRORS_GT
This table holds the errors for the transactions processed by the PreProcessor. At every commit 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. The Run Control is a pointer to the Cost Process parameters table. | |
| 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 | Indicates the Inventory Org to which the item belongs. | ||
| INVENTORY_ITEM_ID | NUMBER | 18 | Value that identifies the inventory item associated with the transaction. | ||
| TRANSACTION_DATE | TIMESTAMP | The date when this transaction happened. | |||
| 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 | Identifies the Cost Organization associated with the inventory organization. | ||
| COST_BOOK_ID | NUMBER | 18 | Identifies the Cost Book assigned to the Cost Organization. | ||
| VAL_UNIT_ID | NUMBER | 18 | Indicates Valuation unit identifier for transaction. | ||
| 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 | Identifies an inventory transaction source for which an error occured. | ||
| EXTERNAL_SYSTEM_REF_ID | VARCHAR2 | 30 | Identifies an inventory transaction for which an error occured. | ||
| 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. | ||
| ROW_COUNT | NUMBER | 18 | Row count, normally 1 but can be summed for large counts or global errors. |
Indexes
| Index | Uniqueness | Columns |
|---|---|---|
| CST_PREP_ERRORS_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 |