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

TABLE: IMC.IMC_CSV_ERROR_DETAILS

Object Details
Object Name: IMC_CSV_ERROR_DETAILS
Object Type: TABLE
Owner: IMC
Subobject Name:
Status: VALID


This table stores details of the errors that occur during loading of the data into Interface tables


Storage Details
Tablespace: TablespaceAPPS_TS_INTERFACE
PCT Free: 10
PCT Used:
Columns
Name Datatype Length Mandatory Comments
LOAD_ID NUMBER (15) Yes Number that uniquely identifies the Load Batch
BATCH_ID NUMBER (15)
The BATCH_ID in HZ_IMP_BATCH_SUMMARY Table that this CSV load maps to
PARTY_REC_ID NUMBER (15)
Number uniquely identifies the Party Record in the File
ERROR_TYPE VARCHAR2 (30)
Type Of Error Occurred(Lookup Code)
ERROR_VALUE VARCHAR2 (1996)
Value that Errored
NEW_VALUE VARCHAR2 (240)
Corrected Value of the Errored Column
ATTRIBUTE_ERRORED VARCHAR2 (30)
Column in the IMC_CSV_INTERFCAE_FIELDS table that Errored
LOOKUP_ERROR VARCHAR2 (30)
Lookup_Type incase of a Lookup Error
PARTY_NAME VARCHAR2 (360)
Party that Errored
ERROR_STATUS VARCHAR2 (30)
Error Status. Changes to �C� when Corrected
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)
Standard Who column
Query Text

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


SELECT LOAD_ID
,      BATCH_ID
,      PARTY_REC_ID
,      ERROR_TYPE
,      ERROR_VALUE
,      NEW_VALUE
,      ATTRIBUTE_ERRORED
,      LOOKUP_ERROR
,      PARTY_NAME
,      ERROR_STATUS
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
FROM IMC.IMC_CSV_ERROR_DETAILS;

Dependencies

[top of page]

IMC.IMC_CSV_ERROR_DETAILS does not reference any database object

IMC.IMC_CSV_ERROR_DETAILS is referenced by following:

SchemaIMC
ViewIMC_CSV_ERROR_DETAILS#