DBA Data[Home] [Help] [Dependency Information]

TABLE: OZF.OZF_INTERFACE_ERRORS

Object Details
Object Name: OZF_INTERFACE_ERRORS
Object Type: TABLE
Owner: OZF
FND Design Data: TableOZF.OZF_INTERFACE_ERRORS
Subobject Name:
Status: VALID


OZF_INTERFACE_ERROR stores details of validation errors while loading data in interface tables.


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Columns
Name Datatype Length Mandatory Comments
CREATION_DATE DATE
Yes Standard WHO Column
CREATED_BY NUMBER (15) Yes Standard WHO Column
LAST_UPDATE_DATE DATE
Yes Standard WHO Column
LAST_UPDATED_BY NUMBER (15) Yes Standard WHO Column
LAST_UPDATE_LOGIN NUMBER (15) Yes Standard WHO Column
REQUEST_ID NUMBER

Request Identifier
PROGRAM_APPLICATION_ID NUMBER

Program Application Identifier
PROGRAM_UPDATE_DATE DATE

Program Update Date
PROGRAM_ID NUMBER

Program Identifier
CREATED_FROM VARCHAR2 (30)
Create From
ENTITY_NAME VARCHAR2 (240) Yes Name of the Entity that Has Error
ENTITY_ROW_ID NUMBER
Yes Identifier of the Entity Row that Has Error
COLUMN_NAME VARCHAR2 (30)
Name of the Column that Has Error
COLUMN_VALUE VARCHAR2 (4000)
Value of the Column that Has Error
MESSAGE_CODE VARCHAR2 (30) Yes Error Message Code
MESSAGE_TEXT VARCHAR2 (2000)
Error Message Text
Query Text

Cut, paste (and edit) the following text to query this object:


SELECT CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
,      REQUEST_ID
,      PROGRAM_APPLICATION_ID
,      PROGRAM_UPDATE_DATE
,      PROGRAM_ID
,      CREATED_FROM
,      ENTITY_NAME
,      ENTITY_ROW_ID
,      COLUMN_NAME
,      COLUMN_VALUE
,      MESSAGE_CODE
,      MESSAGE_TEXT
FROM OZF.OZF_INTERFACE_ERRORS;

Dependencies

[top of page]

OZF.OZF_INTERFACE_ERRORS does not reference any database object

OZF.OZF_INTERFACE_ERRORS is referenced by following:

SchemaAPPS
SynonymOZF_INTERFACE_ERRORS