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

Columns

Name
RUN_CONTROLVARCHAR230YesRun Control PROCESSOR_NAMEVARCHAR230YesThe 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_CODEVARCHAR230YesThe message name code from the FND Messages table (FND_MESSAGES.MESSAGE_NAME). MESSAGE_TYPEVARCHAR230Message 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. MESSAGEVARCHAR2240Resolved 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_IDNUMBER18Inventory Organization ID INVENTORY_ITEM_IDNUMBER18Inventory Item ID TRANSACTION_DATETIMESTAMPTransaction Date ACCOUNTED_DATETIMESTAMPAccounted date is used in the Period End Validation flow. BASE_TXN_TYPE_IDNUMBER18Inventory transaction type identifier. The 3 base txn IDs taken together determine the transaction type shown on the UI. BASE_TXN_SOURCE_TYPE_IDNUMBER18Inventory transaction source type identifier. The 3 base txn IDs taken together determine the transaction type shown on the UI. BASE_TXN_ACTION_IDNUMBER18Inventory transaction action identifier. The 3 base txn IDs taken together determine the transaction type shown on the UI. COST_ORG_IDNUMBER18Cost Organization ID COST_BOOK_IDNUMBER18Cost Book ID VAL_UNIT_IDNUMBER18Valuation Unit ID TABLE_NAMEVARCHAR230Table Name TABLE_ROW_IDVARCHAR218Table 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_REFERENCEVARCHAR260External System Reference EXTERNAL_SYSTEM_REF_IDVARCHAR230External System Reference ID SUBPROCESSOR_NAMEVARCHAR2900Subprocessor Name. This value is the direct name and not a look up. TOKEN1_NAMEVARCHAR230Token name as required by error code message. TOKEN1_VALUEVARCHAR2240Token value as required by error code message. TOKEN2_NAMEVARCHAR230Token name as required by error code message. TOKEN2_VALUEVARCHAR2240Token value as required by error code message. TOKEN3_NAMEVARCHAR230Token name as required by error code message. TOKEN3_VALUEVARCHAR2240Token value as required by error code message. TOKEN4_NAMEVARCHAR230Token name as required by error code message. TOKEN4_VALUEVARCHAR2240Token value as required by error code message. TOKEN5_NAMEVARCHAR230Token name as required by error code message. TOKEN5_VALUEVARCHAR2240Token value as required by error code message. TOKEN6_NAMEVARCHAR230Token name as required by error code message. TOKEN6_VALUEVARCHAR2240Token value as required by error code message.

Name

RUN_CONTROLVARCHAR230YesRun Control

PROCESSOR_NAMEVARCHAR230YesThe 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_CODEVARCHAR230YesThe message name code from the FND Messages table (FND_MESSAGES.MESSAGE_NAME).

MESSAGE_TYPEVARCHAR230Message 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.

MESSAGEVARCHAR2240Resolved 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_IDNUMBER18Inventory Organization ID

INVENTORY_ITEM_IDNUMBER18Inventory Item ID

TRANSACTION_DATETIMESTAMPTransaction Date

ACCOUNTED_DATETIMESTAMPAccounted date is used in the Period End Validation flow.

BASE_TXN_TYPE_IDNUMBER18Inventory transaction type identifier. The 3 base txn IDs taken together determine the transaction type shown on the UI.

BASE_TXN_SOURCE_TYPE_IDNUMBER18Inventory transaction source type identifier. The 3 base txn IDs taken together determine the transaction type shown on the UI.

BASE_TXN_ACTION_IDNUMBER18Inventory transaction action identifier. The 3 base txn IDs taken together determine the transaction type shown on the UI.

COST_ORG_IDNUMBER18Cost Organization ID

COST_BOOK_IDNUMBER18Cost Book ID

VAL_UNIT_IDNUMBER18Valuation Unit ID

TABLE_NAMEVARCHAR230Table Name

TABLE_ROW_IDVARCHAR218Table 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_REFERENCEVARCHAR260External System Reference

EXTERNAL_SYSTEM_REF_IDVARCHAR230External System Reference ID

SUBPROCESSOR_NAMEVARCHAR2900Subprocessor Name. This value is the direct name and not a look up.

TOKEN1_NAMEVARCHAR230Token name as required by error code message.

TOKEN1_VALUEVARCHAR2240Token value as required by error code message.

TOKEN2_NAMEVARCHAR230Token name as required by error code message.

TOKEN2_VALUEVARCHAR2240Token value as required by error code message.

TOKEN3_NAMEVARCHAR230Token name as required by error code message.

TOKEN3_VALUEVARCHAR2240Token value as required by error code message.

TOKEN4_NAMEVARCHAR230Token name as required by error code message.

TOKEN4_VALUEVARCHAR2240Token value as required by error code message.

TOKEN5_NAMEVARCHAR230Token name as required by error code message.

TOKEN5_VALUEVARCHAR2240Token value as required by error code message.

TOKEN6_NAMEVARCHAR230Token name as required by error code message.

TOKEN6_VALUEVARCHAR2240Token value as required by error code message.

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