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_ |
LAST_UPDATE_DATE, LAST_UPDATED_BY, 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 | Who column: indicates the date and time of the creation of the row. | |||
CREATED_BY | VARCHAR2 | 64 | 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 | 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 | ||
AUDIT_ACTION_TYPE_ | VARCHAR2 | 10 | Action Type - have values like INSERT, UPDATE and DELETE. | ||
AUDIT_CHANGE_BIT_MAP_ | VARCHAR2 | 1000 | Used to store a bit map of 1s and 0s for each column in the table. | ||
AUDIT_IMPERSONATOR_ | VARCHAR2 | 64 | Original Impersonator User. |
Indexes
Index | Uniqueness | Tablespace | Columns |
---|---|---|---|
EGP_DELETE_ERRORS_U1_ | Unique | Default | LAST_UPDATE_DATE, LAST_UPDATED_BY, DELETE_ENTITY_SEQUENCE_ID, ERROR_SEQUENCE_NUMBER |