CST_TE_ERRORS_GT

This table holds the errors for the transactions processed by the Trade Events 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: FUSION_TS_TX_DATA

Columns

Name	Datatype	Length	Precision	Not-null	Comments
RUN_CONTROL	VARCHAR2	30		Yes	Run Control
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		Inventory Organization ID
INVENTORY_ITEM_ID	NUMBER		18		Inventory Item ID
TRANSACTION_DATE	TIMESTAMP				Transaction Date
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		Cost Organization ID
COST_BOOK_ID	NUMBER		18		Cost Book ID
VAL_UNIT_ID	NUMBER		18		Valuation Unit ID
TABLE_NAME	VARCHAR2	30			Table Name
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			External System Reference
EXTERNAL_SYSTEM_REF_ID	VARCHAR2	30			External System Reference ID
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_TE_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