EGP_DELETE_ERRORS

EGP_DELETE_ERRORS stores information about constraints that are violated for every entity that you try to delete. Oracle Bills of Material retrieves the translated error message using the message name associated with every failed constraint. .

Details

• Schema: FUSION

• Object owner: EGP

• Object type: TABLE

• Tablespace: FUSION_TS_TX_DATA

Primary Key

Name	Columns
EGP_DELETE_ERRORS_PK	DELETE_ENTITY_SEQUENCE_ID, ERROR_SEQUENCE_NUMBER

Columns

Name	Datatype	Length	Precision	Not-null	Comments
DELETE_ENTITY_SEQUENCE_ID	NUMBER		18	Yes	Attribute indicating the unique identifier of the deleted entity in the egp_delete_errors table.
ERROR_SEQUENCE_NUMBER	NUMBER		18	Yes	Ignore this column. Not used in Fusion.
DELETE_ERROR_TYPE	NUMBER		1		Ignore this column. Not used in Fusion.
DELETE_SQL_STATEMENT_ID	NUMBER		18		Ignore this column. Not used in Fusion.
ERROR_CODE	VARCHAR2	4000			Text provided by the system in response to a failed transaction that provides the deploying company with more information about the nature of the error.
ERROR_MESSAGE	VARCHAR2	4000			Error Message Details indicating the detailed errors.
LAST_UPDATE_DATE	TIMESTAMP			Yes	Who column: indicates the date and time of the last update of the row.
LAST_UPDATED_BY	VARCHAR2	64		Yes	Who column: indicates the user who last updated the row.
CREATION_DATE	TIMESTAMP			Yes	Who column: indicates the date and time of the creation of the row.
CREATED_BY	VARCHAR2	64		Yes	Who column: indicates the user who created the row.
LAST_UPDATE_LOGIN	VARCHAR2	32			Who column: indicates the session login associated to the user who last updated the row.
OBJECT_VERSION_NUMBER	NUMBER		9	Yes	Used to implement optimistic locking. This number is incremented every time that the row is updated. The number is compared at the start and end of a transaction to detect whether another session has updated the row since it was queried.
REQUEST_ID	NUMBER		18		Enterprise Service Scheduler: indicates the request ID of the job that created or last updated the row.
PROGRAM_NAME	VARCHAR2	30			Identifies the concurrent program
PROGRAM_APP_NAME	VARCHAR2	50			Identifies the Application name spawning the Concurrent Request

Foreign Keys

Table	Foreign Table	Foreign Key Column
EGP_DELETE_ERRORS	egp_delete_entities	DELETE_ENTITY_SEQUENCE_ID

Indexes

Index	Uniqueness	Tablespace	Columns
EGP_DELETE_ERRORS_U1	Unique	FUSION_TS_TX_DATA	DELETE_ENTITY_SEQUENCE_ID, ERROR_SEQUENCE_NUMBER