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

TABLE: AR.HZ_IMP_TMP_ERRORS

Object Details
Object Name: HZ_IMP_TMP_ERRORS
Object Type: TABLE
Owner: AR
FND Design Data: TableAR.HZ_IMP_TMP_ERRORS
Subobject Name:
Status: VALID


The TCA import process uses the HZ_IMP_TMP_ERRORS table to record all errors that occur during import. These errors are recorded in the HZ_IMP_ERRORS at the end of the process.


Storage Details
Tablespace: TablespaceAPPS_TS_INTERFACE
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
HZ_IMP_TMP_ERRORS_N1 NORMAL NONUNIQUE TablespaceAPPS_TS_INTERFACE ColumnREQUEST_ID
ColumnINTERFACE_TABLE_NAME
Columns
Name Datatype Length Mandatory Comments
REQUEST_ID NUMBER (15) Yes Request identifier of last concurrent program to update this record
BATCH_ID NUMBER (15) Yes Unique identifier for the batch
INT_ROW_ID ROWID (10) Yes Record row identifier from associated interface table
INTERFACE_TABLE_NAME VARCHAR2 (30) Yes Associated interface table
ERROR_ID NUMBER (15) Yes Indicates that an error has occurred for the record. Also used to join to the appropriate row in the errors table.
CREATION_DATE DATE

Standard Who column
CREATED_BY NUMBER (15)
Standard Who column
LAST_UPDATE_DATE DATE

Standard Who column
LAST_UPDATED_BY NUMBER (15)
Standard Who column
LAST_UPDATE_LOGIN NUMBER (15)
Standard Who column
PROGRAM_APPLICATION_ID NUMBER (15)
Application identifier of last concurrent program to update this record
PROGRAM_ID NUMBER (15)
Program identifier of last concurrent program to update this record
PROGRAM_UPDATE_DATE DATE

Last date this record was updated by a concurrent program
E1_FLAG VARCHAR2 (1)
Y or N indicates whether the error is a validation error or not
E2_FLAG VARCHAR2 (1)
Y or N indicates whether the error is a validation error or not
E3_FLAG VARCHAR2 (1)
Y or N indicates whether the error is a validation error or not
E4_FLAG VARCHAR2 (1)
Y or N indicates whether the error is a validation error or not
E5_FLAG VARCHAR2 (1)
Y or N indicates whether the error is a validation error or not
E6_FLAG VARCHAR2 (1)
Y or N indicates whether the error is a validation error or not
E7_FLAG VARCHAR2 (1)
Y or N indicates whether the error is a validation error or not
E8_FLAG VARCHAR2 (1)
Y or N indicates whether the error is a validation error or not
E9_FLAG VARCHAR2 (1)
Y or N indicates whether the error is a validation error or not
E10_FLAG VARCHAR2 (1)
Y or N indicates whether the error is a validation error or not
E11_FLAG VARCHAR2 (1)
Y or N indicates whether the error is a validation error or not
E12_FLAG VARCHAR2 (1)
Y or N indicates whether the error is a validation error or not
E13_FLAG VARCHAR2 (1)
Y or N indicates whether the error is a validation error or not
E14_FLAG VARCHAR2 (1)
Y or N indicates whether the error is a validation error or not
E15_FLAG VARCHAR2 (1)
Y or N indicates whether the error is a validation error or not
E16_FLAG VARCHAR2 (1)
Y or N indicates whether the error is a validation error or not
E17_FLAG VARCHAR2 (1)
Y or N indicates whether the error is a validation error or not
E18_FLAG VARCHAR2 (1)
Y or N indicates whether the error is a validation error or not
E19_FLAG VARCHAR2 (1)
Y or N indicates whether the error is a validation error or not
E20_FLAG VARCHAR2 (1)
Y or N indicates whether the error is a validation error or not
E21_FLAG VARCHAR2 (1)
Y or N indicates whether the error is a validation error or not
E22_FLAG VARCHAR2 (1)
Y or N indicates whether the error is a validation error or not
E23_FLAG VARCHAR2 (1)
Y or N indicates whether the error is a validation error or not
E24_FLAG VARCHAR2 (1)
Y or N indicates whether the error is a validation error or not
E25_FLAG VARCHAR2 (1)
Y or N indicates whether the error is a validation error or not
E26_FLAG VARCHAR2 (1)
Y or N indicates whether the error is a validation error or not
E27_FLAG VARCHAR2 (1)
Y or N indicates whether the error is a validation error or not
E28_FLAG VARCHAR2 (1)
Y or N indicates whether the error is a validation error or not
E29_FLAG VARCHAR2 (1)
Y or N indicates whether the error is a validation error or not
E30_FLAG VARCHAR2 (1)
Y or N indicates whether the error is a validation error or not
E31_FLAG VARCHAR2 (1)
Y or N indicates whether the error is a validation error or not
E32_FLAG VARCHAR2 (1)
Y or N indicates whether the error is a validation error or not
E33_FLAG VARCHAR2 (1)
Y or N indicates whether the error is a validation error or not
E34_FLAG VARCHAR2 (1)
Y or N indicates whether the error is a validation error or not
E35_FLAG VARCHAR2 (1)
Y or N indicates whether the error is a validation error or not
E36_FLAG VARCHAR2 (1)
Y or N indicates whether the error is a validation error or not
E37_FLAG VARCHAR2 (1)
Y or N indicates whether the error is a validation error or not
E38_FLAG VARCHAR2 (1)
Y or N indicates whether the error is a validation error or not
E39_FLAG VARCHAR2 (1)
Y or N indicates whether the error is a validation error or not
E40_FLAG VARCHAR2 (1)
Y or N indicates whether the error is a validation error or not
DUP_VAL_IDX_EXCEP_FLAG VARCHAR2 (1)
Y or N indicates that a unique key violation error occurred
OTHER_EXCEP_FLAG VARCHAR2 (1)
Y or N indicates that an unknown error occurred
ACTION_MISMATCH_FLAG VARCHAR2 (1)
Y or N indicates whether or not the user-defined insert or update action conflicts with the system-defined insert or update action
MISSING_PARENT_FLAG VARCHAR2 (1)
Y or N indicates whether the parent record is missing or not
E41_FLAG VARCHAR2 (1)
Indicates if error is a validation error. Y for yes, N or null for no.
E42_FLAG VARCHAR2 (1)
Indicates if error is a validation error. Y for yes, N or null for no.
E43_FLAG VARCHAR2 (1)
Indicates if error is a validation error. Y for yes, N or null for no.
E44_FLAG VARCHAR2 (1)
Indicates if error is a validation error. Y for yes, N or null for no.
E45_FLAG VARCHAR2 (1)
Indicates if error is a validation error. Y for yes, N or null for no.
E46_FLAG VARCHAR2 (1)
Indicates if error is a validation error. Y for yes, N or null for no.
E47_FLAG VARCHAR2 (1)
Indicates if error is a validation error. Y for yes, N or null for no.
E48_FLAG VARCHAR2 (1)
Indicates if error is a validation error. Y for yes, N or null for no.
E49_FLAG VARCHAR2 (1)
Indicates if error is a validation error. Y for yes, N or null for no.
E50_FLAG VARCHAR2 (1)
Indicates if error is a validation error. Y for yes, N or null for no.
Query Text

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


SELECT REQUEST_ID
,      BATCH_ID
,      INT_ROW_ID
,      INTERFACE_TABLE_NAME
,      ERROR_ID
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
,      PROGRAM_APPLICATION_ID
,      PROGRAM_ID
,      PROGRAM_UPDATE_DATE
,      E1_FLAG
,      E2_FLAG
,      E3_FLAG
,      E4_FLAG
,      E5_FLAG
,      E6_FLAG
,      E7_FLAG
,      E8_FLAG
,      E9_FLAG
,      E10_FLAG
,      E11_FLAG
,      E12_FLAG
,      E13_FLAG
,      E14_FLAG
,      E15_FLAG
,      E16_FLAG
,      E17_FLAG
,      E18_FLAG
,      E19_FLAG
,      E20_FLAG
,      E21_FLAG
,      E22_FLAG
,      E23_FLAG
,      E24_FLAG
,      E25_FLAG
,      E26_FLAG
,      E27_FLAG
,      E28_FLAG
,      E29_FLAG
,      E30_FLAG
,      E31_FLAG
,      E32_FLAG
,      E33_FLAG
,      E34_FLAG
,      E35_FLAG
,      E36_FLAG
,      E37_FLAG
,      E38_FLAG
,      E39_FLAG
,      E40_FLAG
,      DUP_VAL_IDX_EXCEP_FLAG
,      OTHER_EXCEP_FLAG
,      ACTION_MISMATCH_FLAG
,      MISSING_PARENT_FLAG
,      E41_FLAG
,      E42_FLAG
,      E43_FLAG
,      E44_FLAG
,      E45_FLAG
,      E46_FLAG
,      E47_FLAG
,      E48_FLAG
,      E49_FLAG
,      E50_FLAG
FROM AR.HZ_IMP_TMP_ERRORS;

Dependencies

[top of page]

AR.HZ_IMP_TMP_ERRORS does not reference any database object

AR.HZ_IMP_TMP_ERRORS is referenced by following:

SchemaAR
ViewHZ_IMP_TMP_ERRORS#