ERPstuff - Oracle EBS Community

begin
DBMS_ERRLOG.CREATE_ERROR_LOG (dml_table_name => 'EMP');
end;

it will create table for dataload error,

CREATE TABLE "ERR$_EMP"
( "ORA_ERR_NUMBER$" NUMBER,
"ORA_ERR_MESG$" VARCHAR2(2000),
"ORA_ERR_ROWID$" UROWID (4000),
"ORA_ERR_OPTYP$" VARCHAR2(2),
"ORA_ERR_TAG$" VARCHAR2(2000),
"EMPNO" VARCHAR2(4000),
"ENAME" VARCHAR2(4000),
"JOB" VARCHAR2(4000),
"MGR" VARCHAR2(4000),
"HIREDATE" VARCHAR2(4000),
"SAL" VARCHAR2(4000),
"COMM" VARCHAR2(4000),
"DEPTNO" VARCHAR2(4000),
"STATUS" VARCHAR2(4000)
) ;

COMMENT ON TABLE "ERR$_EMP" IS 'DML Error Logging table for "EMP"';