Example of Error File :
Payables Open Interface Error in SQL LOAD LOG Files
=============================================================================
*****************************************************************************************
=============================================================================
SQL*Loader: Release 9.2.0.1.0 - Production on Thu Aug 14 17:30:30 2008
Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.
Control File: AP_INVOICES_INTERFACE.ctl
Data File: AP_INV_TEST.TXT
Bad File: AP_INV_TEST.bad
Discard File: none specified
(Allow all discards)
Number to load: ALL
Number to skip: 0
Errors allowed: 50
Bind array: 64 rows, maximum of 256000 bytes
Continuation: none specified
Path used: Conventional
Table AP_INVOICES_INTERFACE, loaded from every logical record.
Insert option in effect for this table: APPEND
TRAILING NULLCOLS option in effect
Column Name Position Len Term Encl Datatype
------------------------------ ---------- ----- ---- ---- ---------------------
INVOICE_NUM FIRST * ^ O(") CHARACTER
SQL string for column : "RTRIM(:INVOICE_NUM)||'1'"
INVOICE_TYPE_LOOKUP_CODE NEXT * ^ O(") CHARACTER
SQL string for column : "RTRIM(:INVOICE_TYPE_LOOKUP_CODE)"
INVOICE_DATE NEXT * ^ O(") DATE DD-MON-RRRR
VENDOR_NUM NEXT * ^ O(") CHARACTER
SQL string for column : "RTRIM(:VENDOR_NUM)"
VENDOR_SITE_CODE NEXT * ^ O(") CHARACTER
SQL string for column : "RTRIM(:VENDOR_SITE_CODE)"
INVOICE_AMOUNT NEXT * ^ O(") CHARACTER
SQL string for column : "RTRIM(:INVOICE_AMOUNT)"
TERMS_NAME NEXT * ^ O(") CHARACTER
SQL string for column : "RTRIM(:TERMS_NAME)"
DESCRIPTION NEXT * ^ O(") CHARACTER
SQL string for column : "RTRIM(:DESCRIPTION)"
LAST_UPDATE_DATE NEXT * ^ O(") DATE DD-MON-RRRR
LAST_UPDATED_BY NEXT * ^ O(") CHARACTER
SQL string for column : "RTRIM(:LAST_UPDATED_BY)"
CREATION_DATE NEXT * ^ O(") DATE DD-MON-RRRR
CREATED_BY NEXT * ^ O(") CHARACTER
SQL string for column : "RTRIM(:CREATED_BY)"
GL_DATE NEXT * ^ O(") DATE DD-MON-RRRR
LEGAL_ENTITY_NAME NEXT * ^ O(") CHARACTER
SQL string for column : "RTRIM(:LEGAL_ENTITY_NAME)"
SOURCE NEXT * ^ O(") CHARACTER
SQL string for column : "RTRIM(:SOURCE)"
INVOICE_CURRENCY_CODE NEXT * ^ O(") CHARACTER
SQL string for column : "RTRIM(:INVOICE_CURRENCY_CODE)"
PAY_GROUP_LOOKUP_CODE NEXT * ^ O(") CHARACTER
SQL string for column : "RTRIM(:PAY_GROUP_LOOKUP_CODE)"
OPERATING_UNIT NEXT * ^ O(") CHARACTER
SQL string for column : "RTRIM(:OPERATING_UNIT)"
INVOICE_ID NEXT * ^ O(") CHARACTER
SQL string for column : "AP_INVOICES_INTERFACE_S.NEXTVAL"
Record 1: Rejected - Error on table AP_INVOICES_INTERFACE, column INVOICE_DATE.
ORA-01858: a non-numeric character was found where a numeric was expected
Record 21: Rejected - Error on table AP_INVOICES_INTERFACE, column VENDOR_SITE_CODE.
ORA-12899: value too large for column "AP"."AP_INVOICES_INTERFACE"."VENDOR_SITE_CODE" (actual: 20, maximum: 15)
Record 376: Rejected - Error on table AP_INVOICES_INTERFACE, column VENDOR_SITE_CODE.
ORA-12899: value too large for column "AP"."AP_INVOICES_INTERFACE"."VENDOR_SITE_CODE" (actual: 23, maximum: 15)
Record 384: Rejected - Error on table AP_INVOICES_INTERFACE, column VENDOR_SITE_CODE.
ORA-12899: value too large for column "AP"."AP_INVOICES_INTERFACE"."VENDOR_SITE_CODE" (actual: 23, maximum: 15)
Record 2: Rejected - Error on table AP_INVOICES_INTERFACE.
ORA-01400: cannot insert NULL into ("AP"."AP_INVOICES_INTERFACE"."INVOICE_ID")
Record 4: Rejected - Error on table AP_INVOICES_INTERFACE, column INVOICE_DATE.
ORA-01847: day of month must be between 1 and last day of month
Record 51: Rejected - Error on table AP_INVOICES_INTERFACE, column INVOICE_DATE.
ORA-01861: literal does not match format string
Record 1: Rejected - Error on table AP_INVOICES_INTERFACE, column INVOICE_DATE.
ORA-01858: a non-numeric character was found where a numeric was expected
Record 21: Rejected - Error on table AP_INVOICES_INTERFACE, column VENDOR_SITE_CODE.
ORA-12899: value too large for column "AP"."AP_INVOICES_INTERFACE"."VENDOR_SITE_CODE" (actual: 20, maximum: 15)
Table AP_INVOICES_INTERFACE:
1062 Rows successfully loaded.
4 Rows not loaded due to data errors.
0 Rows not loaded because all WHEN clauses were failed.
0 Rows not loaded because all fields were null.
Space allocated for bind array: 254904 bytes(52 rows)
Read buffer bytes: 1048576
Total logical records skipped: 0
Total logical records read: 1066
Total logical records rejected: 4
Total logical records discarded: 0
Run began on Thu Aug 14 17:30:30 2008
Run ended on Thu Aug 14 17:31:10 2008
Elapsed time was: 00:00:39.78
CPU time was: 00:00:00.10
=============================================================================
*****************************************************************************************
=============================================================================
SQL*Loader: Release 9.2.0.1.0 - Production on Tue Aug 19 20:19:14 2008
Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.
Control File: AP_INVOICE_LINES_INTERFACE.ctl
Data File: AP_LINE_TEST.TXT
Bad File: AP_LINE_TEST.bad
Discard File: none specified
(Allow all discards)
Number to load: ALL
Number to skip: 0
Errors allowed: 50
Bind array: 64 rows, maximum of 256000 bytes
Continuation: none specified
Path used: Conventional
Table AP_INVOICE_LINES_INTERFACE, loaded from every logical record.
Insert option in effect for this table: APPEND
TRAILING NULLCOLS option in effect
Column Name Position Len Term Encl Datatype
------------------------------ ---------- ----- ---- ---- ---------------------
REFERENCE_2 FIRST * ^ O(") CHARACTER
SQL string for column : "RTRIM(:REFERENCE_2)"
TYPE NEXT * ^ O(") CHARACTER
(FILLER FIELD)
ACCOUNTING_DATE NEXT * ^ O(") DATE DD-MON-RRRR
DESCRIPTION NEXT * ^ O(") CHARACTER
SQL string for column : "RTRIM(:DESCRIPTION)"
DIST_CODE_COMBINATION_ID NEXT * ^ O(") CHARACTER
SQL string for column : "RTRIM(:DIST_CODE_COMBINATION_ID)"
LAST_UPDATED_BY NEXT * ^ O(") CHARACTER
SQL string for column : "RTRIM(:LAST_UPDATED_BY)"
AMOUNT NEXT * ^ O(") CHARACTER
SQL string for column : "RTRIM(:AMOUNT)"
CREATED_BY NEXT * ^ O(") CHARACTER
SQL string for column : "RTRIM(:CREATED_BY)"
CREATION_DATE NEXT * ^ O(") DATE DD-MON-RRRR
ATTRIBUTE1 NEXT * ^ O(") CHARACTER
SQL string for column : "RTRIM(:ATTRIBUTE1)"
ATTRIBUTE2 NEXT * ^ O(") CHARACTER
SQL string for column : "RTRIM(:ATTRIBUTE2)"
ATTRIBUTE3 NEXT * ^ O(") CHARACTER
SQL string for column : "RTRIM(:ATTRIBUTE3)"
TYPE_1099 NEXT * ^ O(") CHARACTER
SQL string for column : "RTRIM(:TYPE_1099)"
UNIT_OF_MEAS_LOOKUP_CODE NEXT * ^ O(") CHARACTER
SQL string for column : "RTRIM(:UNIT_OF_MEAS_LOOKUP_CODE)"
TAX_RATE NEXT * ^ O(") CHARACTER
SQL string for column : "RTRIM(:TAX_RATE)"
QUANTITY_INVOICED NEXT * ^ O(") CHARACTER
SQL string for column : "RTRIM(:QUANTITY_INVOICED)"
UNIT_PRICE NEXT * ^ O(") CHARACTER
SQL string for column : "RTRIM(:UNIT_PRICE)"
INVOICE_ID NEXT * ^ O(") CHARACTER
SQL string for column : "AP_INVOICE_LINES_INTERFACE_S.NEXTVAL"
Record 22: Rejected - Error on table AP_INVOICE_LINES_INTERFACE, column DESCRIPTION.
no terminator found after TERMINATED and ENCLOSED field
Record 23: Rejected - Error on table AP_INVOICE_LINES_INTERFACE, column DESCRIPTION.
no terminator found after TERMINATED and ENCLOSED field
Record 1: Rejected - Error on table AP_INVOICE_LINES_INTERFACE, column AMOUNT.
ORA-01722: invalid number
Record 2: Rejected - Error on table AP_INVOICE_LINES_INTERFACE, column AMOUNT.
ORA-01722: invalid number
Record 56: Rejected - Error on table AP_INVOICE_LINES_INTERFACE, column DESCRIPTION.
no terminator found after TERMINATED and ENCLOSED field
Record 57: Rejected - Error on table AP_INVOICE_LINES_INTERFACE, column DESCRIPTION.
no terminator found after TERMINATED and ENCLOSED field
Record 1: Rejected - Error on table AP_INVOICE_LINES_INTERFACE.
ORA-01400: cannot insert NULL into ("AP"."AP_INVOICE_LINES_INTERFACE"."INVOICE_ID")
Record 2: Rejected - Error on table AP_INVOICE_LINES_INTERFACE.
Record 35: Rejected - Error on table AP_INVOICE_LINES_INTERFACE, column AMOUNT.
ORA-01722: invalid number
ORA-01821: date format not recognized
MAXIMUM ERROR COUNT EXCEEDED - Above statistics reflect partial run.
Table AP_INVOICE_LINES_INTERFACE:
0 Rows successfully loaded.
51 Rows not loaded due to data errors.
0 Rows not loaded because all WHEN clauses were failed.
0 Rows not loaded because all fields were null.
Space allocated for bind array: 254388 bytes(58 rows)
Read buffer bytes: 1048576
Total logical records skipped: 0
Total logical records read: 76
Total logical records rejected: 51
Total logical records discarded: 0
Run began on Tue Aug 19 20:19:14 2008
Run ended on Tue Aug 19 20:19:41 2008
Elapsed time was: 00:00:26.47
CPU time was: 00:00:00.06
=============================================================================
*****************************************************************************************
=============================================================================
=============================================================================
*****************************************************************************************
=============================================================================
Payables Open Interface Error in SQL LOAD LOG Files
=============================================================================
*****************************************************************************************
=============================================================================
SQL*Loader: Release 9.2.0.1.0 - Production on Thu Aug 14 17:30:30 2008
Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.
Control File: AP_INVOICES_INTERFACE.ctl
Data File: AP_INV_TEST.TXT
Bad File: AP_INV_TEST.bad
Discard File: none specified
(Allow all discards)
Number to load: ALL
Number to skip: 0
Errors allowed: 50
Bind array: 64 rows, maximum of 256000 bytes
Continuation: none specified
Path used: Conventional
Table AP_INVOICES_INTERFACE, loaded from every logical record.
Insert option in effect for this table: APPEND
TRAILING NULLCOLS option in effect
Column Name Position Len Term Encl Datatype
------------------------------ ---------- ----- ---- ---- ---------------------
INVOICE_NUM FIRST * ^ O(") CHARACTER
SQL string for column : "RTRIM(:INVOICE_NUM)||'1'"
INVOICE_TYPE_LOOKUP_CODE NEXT * ^ O(") CHARACTER
SQL string for column : "RTRIM(:INVOICE_TYPE_LOOKUP_CODE)"
INVOICE_DATE NEXT * ^ O(") DATE DD-MON-RRRR
VENDOR_NUM NEXT * ^ O(") CHARACTER
SQL string for column : "RTRIM(:VENDOR_NUM)"
VENDOR_SITE_CODE NEXT * ^ O(") CHARACTER
SQL string for column : "RTRIM(:VENDOR_SITE_CODE)"
INVOICE_AMOUNT NEXT * ^ O(") CHARACTER
SQL string for column : "RTRIM(:INVOICE_AMOUNT)"
TERMS_NAME NEXT * ^ O(") CHARACTER
SQL string for column : "RTRIM(:TERMS_NAME)"
DESCRIPTION NEXT * ^ O(") CHARACTER
SQL string for column : "RTRIM(:DESCRIPTION)"
LAST_UPDATE_DATE NEXT * ^ O(") DATE DD-MON-RRRR
LAST_UPDATED_BY NEXT * ^ O(") CHARACTER
SQL string for column : "RTRIM(:LAST_UPDATED_BY)"
CREATION_DATE NEXT * ^ O(") DATE DD-MON-RRRR
CREATED_BY NEXT * ^ O(") CHARACTER
SQL string for column : "RTRIM(:CREATED_BY)"
GL_DATE NEXT * ^ O(") DATE DD-MON-RRRR
LEGAL_ENTITY_NAME NEXT * ^ O(") CHARACTER
SQL string for column : "RTRIM(:LEGAL_ENTITY_NAME)"
SOURCE NEXT * ^ O(") CHARACTER
SQL string for column : "RTRIM(:SOURCE)"
INVOICE_CURRENCY_CODE NEXT * ^ O(") CHARACTER
SQL string for column : "RTRIM(:INVOICE_CURRENCY_CODE)"
PAY_GROUP_LOOKUP_CODE NEXT * ^ O(") CHARACTER
SQL string for column : "RTRIM(:PAY_GROUP_LOOKUP_CODE)"
OPERATING_UNIT NEXT * ^ O(") CHARACTER
SQL string for column : "RTRIM(:OPERATING_UNIT)"
INVOICE_ID NEXT * ^ O(") CHARACTER
SQL string for column : "AP_INVOICES_INTERFACE_S.NEXTVAL"
Record 1: Rejected - Error on table AP_INVOICES_INTERFACE, column INVOICE_DATE.
ORA-01858: a non-numeric character was found where a numeric was expected
Record 21: Rejected - Error on table AP_INVOICES_INTERFACE, column VENDOR_SITE_CODE.
ORA-12899: value too large for column "AP"."AP_INVOICES_INTERFACE"."VENDOR_SITE_CODE" (actual: 20, maximum: 15)
Record 376: Rejected - Error on table AP_INVOICES_INTERFACE, column VENDOR_SITE_CODE.
ORA-12899: value too large for column "AP"."AP_INVOICES_INTERFACE"."VENDOR_SITE_CODE" (actual: 23, maximum: 15)
Record 384: Rejected - Error on table AP_INVOICES_INTERFACE, column VENDOR_SITE_CODE.
ORA-12899: value too large for column "AP"."AP_INVOICES_INTERFACE"."VENDOR_SITE_CODE" (actual: 23, maximum: 15)
Record 2: Rejected - Error on table AP_INVOICES_INTERFACE.
ORA-01400: cannot insert NULL into ("AP"."AP_INVOICES_INTERFACE"."INVOICE_ID")
Record 4: Rejected - Error on table AP_INVOICES_INTERFACE, column INVOICE_DATE.
ORA-01847: day of month must be between 1 and last day of month
Record 51: Rejected - Error on table AP_INVOICES_INTERFACE, column INVOICE_DATE.
ORA-01861: literal does not match format string
Record 1: Rejected - Error on table AP_INVOICES_INTERFACE, column INVOICE_DATE.
ORA-01858: a non-numeric character was found where a numeric was expected
Record 21: Rejected - Error on table AP_INVOICES_INTERFACE, column VENDOR_SITE_CODE.
ORA-12899: value too large for column "AP"."AP_INVOICES_INTERFACE"."VENDOR_SITE_CODE" (actual: 20, maximum: 15)
Table AP_INVOICES_INTERFACE:
1062 Rows successfully loaded.
4 Rows not loaded due to data errors.
0 Rows not loaded because all WHEN clauses were failed.
0 Rows not loaded because all fields were null.
Space allocated for bind array: 254904 bytes(52 rows)
Read buffer bytes: 1048576
Total logical records skipped: 0
Total logical records read: 1066
Total logical records rejected: 4
Total logical records discarded: 0
Run began on Thu Aug 14 17:30:30 2008
Run ended on Thu Aug 14 17:31:10 2008
Elapsed time was: 00:00:39.78
CPU time was: 00:00:00.10
=============================================================================
*****************************************************************************************
=============================================================================
SQL*Loader: Release 9.2.0.1.0 - Production on Tue Aug 19 20:19:14 2008
Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.
Control File: AP_INVOICE_LINES_INTERFACE.ctl
Data File: AP_LINE_TEST.TXT
Bad File: AP_LINE_TEST.bad
Discard File: none specified
(Allow all discards)
Number to load: ALL
Number to skip: 0
Errors allowed: 50
Bind array: 64 rows, maximum of 256000 bytes
Continuation: none specified
Path used: Conventional
Table AP_INVOICE_LINES_INTERFACE, loaded from every logical record.
Insert option in effect for this table: APPEND
TRAILING NULLCOLS option in effect
Column Name Position Len Term Encl Datatype
------------------------------ ---------- ----- ---- ---- ---------------------
REFERENCE_2 FIRST * ^ O(") CHARACTER
SQL string for column : "RTRIM(:REFERENCE_2)"
TYPE NEXT * ^ O(") CHARACTER
(FILLER FIELD)
ACCOUNTING_DATE NEXT * ^ O(") DATE DD-MON-RRRR
DESCRIPTION NEXT * ^ O(") CHARACTER
SQL string for column : "RTRIM(:DESCRIPTION)"
DIST_CODE_COMBINATION_ID NEXT * ^ O(") CHARACTER
SQL string for column : "RTRIM(:DIST_CODE_COMBINATION_ID)"
LAST_UPDATED_BY NEXT * ^ O(") CHARACTER
SQL string for column : "RTRIM(:LAST_UPDATED_BY)"
AMOUNT NEXT * ^ O(") CHARACTER
SQL string for column : "RTRIM(:AMOUNT)"
CREATED_BY NEXT * ^ O(") CHARACTER
SQL string for column : "RTRIM(:CREATED_BY)"
CREATION_DATE NEXT * ^ O(") DATE DD-MON-RRRR
ATTRIBUTE1 NEXT * ^ O(") CHARACTER
SQL string for column : "RTRIM(:ATTRIBUTE1)"
ATTRIBUTE2 NEXT * ^ O(") CHARACTER
SQL string for column : "RTRIM(:ATTRIBUTE2)"
ATTRIBUTE3 NEXT * ^ O(") CHARACTER
SQL string for column : "RTRIM(:ATTRIBUTE3)"
TYPE_1099 NEXT * ^ O(") CHARACTER
SQL string for column : "RTRIM(:TYPE_1099)"
UNIT_OF_MEAS_LOOKUP_CODE NEXT * ^ O(") CHARACTER
SQL string for column : "RTRIM(:UNIT_OF_MEAS_LOOKUP_CODE)"
TAX_RATE NEXT * ^ O(") CHARACTER
SQL string for column : "RTRIM(:TAX_RATE)"
QUANTITY_INVOICED NEXT * ^ O(") CHARACTER
SQL string for column : "RTRIM(:QUANTITY_INVOICED)"
UNIT_PRICE NEXT * ^ O(") CHARACTER
SQL string for column : "RTRIM(:UNIT_PRICE)"
INVOICE_ID NEXT * ^ O(") CHARACTER
SQL string for column : "AP_INVOICE_LINES_INTERFACE_S.NEXTVAL"
Record 22: Rejected - Error on table AP_INVOICE_LINES_INTERFACE, column DESCRIPTION.
no terminator found after TERMINATED and ENCLOSED field
Record 23: Rejected - Error on table AP_INVOICE_LINES_INTERFACE, column DESCRIPTION.
no terminator found after TERMINATED and ENCLOSED field
Record 1: Rejected - Error on table AP_INVOICE_LINES_INTERFACE, column AMOUNT.
ORA-01722: invalid number
Record 2: Rejected - Error on table AP_INVOICE_LINES_INTERFACE, column AMOUNT.
ORA-01722: invalid number
Record 56: Rejected - Error on table AP_INVOICE_LINES_INTERFACE, column DESCRIPTION.
no terminator found after TERMINATED and ENCLOSED field
Record 57: Rejected - Error on table AP_INVOICE_LINES_INTERFACE, column DESCRIPTION.
no terminator found after TERMINATED and ENCLOSED field
Record 1: Rejected - Error on table AP_INVOICE_LINES_INTERFACE.
ORA-01400: cannot insert NULL into ("AP"."AP_INVOICE_LINES_INTERFACE"."INVOICE_ID")
Record 2: Rejected - Error on table AP_INVOICE_LINES_INTERFACE.
Record 35: Rejected - Error on table AP_INVOICE_LINES_INTERFACE, column AMOUNT.
ORA-01722: invalid number
ORA-01821: date format not recognized
MAXIMUM ERROR COUNT EXCEEDED - Above statistics reflect partial run.
Table AP_INVOICE_LINES_INTERFACE:
0 Rows successfully loaded.
51 Rows not loaded due to data errors.
0 Rows not loaded because all WHEN clauses were failed.
0 Rows not loaded because all fields were null.
Space allocated for bind array: 254388 bytes(58 rows)
Read buffer bytes: 1048576
Total logical records skipped: 0
Total logical records read: 76
Total logical records rejected: 51
Total logical records discarded: 0
Run began on Tue Aug 19 20:19:14 2008
Run ended on Tue Aug 19 20:19:41 2008
Elapsed time was: 00:00:26.47
CPU time was: 00:00:00.06
=============================================================================
*****************************************************************************************
=============================================================================
=============================================================================
*****************************************************************************************
=============================================================================
No comments:
Post a Comment