+-----------------------------
| Starting concurrent program execution...
+-----------------------------

Arguments
------------
/var/tmp/claim_invoices_20070508.00008
------------
Spawned Process 16496

SQL*Loader: Release 8.0.6.3.0 - Production on Wed Jun 13 11:17:27 2007

(c) Copyright 1999 Oracle Corporation.  All rights reserved.

Control File:   /ora_app/install11.5.10/devappl/ap/11.5.0/bin/zzclaims.ctl
Data File:      /var/tmp/claim_invoices_20070508.00008
  Bad File:     /ora_app/install11.5.10/devcomn/admin/out/DEV_ormlprfi01/o249391.out
  Discard File: /ora_app/install11.5.10/devcomn/admin/out/DEV_ormlprfi01/o249391.out 
 (Allow all discards)

Number to load: ALL
Number to skip: 0
Errors allowed: 50
Bind array:     64 rows, maximum of 65536 bytes
Continuation:    none specified
Path used:      Conventional

Table LV_AP_ZZCLAIMS_HEADERS, loaded when REC_TYPE = 0X48(character 'H')
Insert option in effect for this table: APPEND

   Column Name                  Position   Len  Term Encl Datatype
------------------------------ ---------- ----- ---- ---- ---------------------
REC_TYPE                            FIRST     *   ,       CHARACTER            
ZZ_INVOICE_ID                        NEXT     *   ,       CHARACTER            
INVOICE_NUM                          NEXT     *   ,       CHARACTER            
INVOICE_DATE                         NEXT     *   ,       DATE DD-MON-RRRR     
VENDOR_NUM                           NEXT     *   ,       CHARACTER            
VENDOR_SITE_CODE                     NEXT     *   ,       CHARACTER            
AMOUNT                               NEXT     *   ,       CHARACTER            
INVOICE_CURRENCY_CODE                NEXT     *   ,       CHARACTER            
DESCRIPTION                          NEXT     *   ,       CHARACTER            
SOURCE                               NEXT     *   ,       CHARACTER            
DOC_CATEGORY_CODE                    NEXT     *   ,       CHARACTER            
PAYMENT_METHOD_LOOKUP_CODE           NEXT     *   ,       CHARACTER            
PAY_GROUP_LOOKUP_CODE                NEXT     *   ,       CHARACTER            
INVOICE_RECEIVED_DATE                NEXT     *   ,       DATE DD-MON-RRRR     

INTERFACE_STATUS               CONSTANT 'N'

Table LV_AP_ZZCLAIMS_LINES, loaded when REC_TYPE = 0X4c(character 'L')
Insert option in effect for this table: APPEND

   Column Name                  Position   Len  Term Encl Datatype
------------------------------ ---------- ----- ---- ---- ---------------------
REC_TYPE                             NEXT     *   ,       CHARACTER            
LINE_NUMBER                          NEXT     *   ,       CHARACTER            
ZZ_INVOICE_ID                        NEXT     *   ,       CHARACTER            
LINE_TYPE_LOOKUP_CODE                NEXT     *   ,       CHARACTER            
NET_AMOUNT                           NEXT     *   ,       CHARACTER            
DESCRIPTION                          NEXT     *   ,       CHARACTER            
TAX_CODE                             NEXT     *   ,       CHARACTER            

INTERFACE_STATUS               CONSTANT 'N'

Record 2: Discarded - failed all WHEN clauses.

Table LV_AP_ZZCLAIMS_HEADERS:
  1 Row successfully loaded.
  0 Rows not loaded due to data errors.
  1 Row not loaded because all WHEN clauses were failed.
  0 Rows not loaded because all fields were null.


Table LV_AP_ZZCLAIMS_LINES:
  0 Rows successfully loaded.
  0 Rows not loaded due to data errors.
  2 Rows not loaded because all WHEN clauses were failed.
  0 Rows not loaded because all fields were null.


Space allocated for bind array:                  65064 bytes(12 rows)
Space allocated for memory besides bind array:        0 bytes

Total logical records skipped:          0
Total logical records read:             2
Total logical records rejected:         0
Total logical records discarded:        1

Run began on Wed Jun 13 11:17:27 2007
Run ended on Wed Jun 13 11:17:27 2007

Elapsed time was:     00:00:00.05
CPU time was:         00:00:00.00