CZ_ERROR_MESSAGES_INT

This table is used to store the reported errors while working with any interface table in CZ.

Details

• Schema: FUSION

• Object owner: CZ

• Object type: TABLE

• Tablespace: INTERFACE

Primary Key

Name	Columns
CZ_ERROR_MESSAGES_INT_PK	MESSAGE_ID

Columns

Name	Datatype	Length	Precision	Not-null	Comments
MESSAGE_ID	NUMBER		18	Yes	System generated unique identifier of the reported error.
TABLE_NAME	VARCHAR2	255			Name of the table for which the error is recorded.
MESSAGE_NAME	VARCHAR2	30			Name of the message used to report error.
MESSAGE_TYPE	VARCHAR2	30			Message type of the error message, such as WARNING and ERROR.
ERROR_ATTRIBUTE	VARCHAR2	30			Attribute for which the error is reported.
MESSAGE_TEXT	VARCHAR2	1000			Message text for the error message.
LOAD_REQUEST_ID	NUMBER		18		Unique ID of the Load ESS job for which the data error occurred.
CREATED_BY	VARCHAR2	64		Yes	Who column: indicates the user who created the row.
CREATION_DATE	TIMESTAMP			Yes	Who column: indicates the date and time of the creation of 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.
SOURCE_ROOT_PARENT_ID	VARCHAR2	240			Associated root parent ID for an entity in the source system, such as Inventory_Item_Id of the model the rule belongs to.
SOURCE_ENTITY_ID	VARCHAR2	240			Unique ID of the interface table record.
BATCH_ID	NUMBER		18		Value that identifies the batch the error record belongs to.

Indexes

Index	Uniqueness	Tablespace	Columns
CZ_ERROR_MESSAGES_INT_U1	Unique	FUSION_TS_INTERFACE	MESSAGE_ID