Unable to load multiple Invoice using Sql * Loader
Hi All,
I am trying to Load AP invoices using SQL * Loader, its loading single Invoice Header Line(AP_INVOICES_INTERFACE) with Multiple invoice lines(AP_INVOICE_LINES_INTERFACE) but its not loading multiple invoice header lines (AP_INVOICES_INTERFACE),
My Query:
load data
infile 'multi_ap_interface.txt'
into TABLE AP_INVOICES_INTERFACE
WHEN (01) = 'H'
fields terminated by "," OPTIONALLY ENCLOSED BY '"' TRAILING NULLCOLS
(
REC_SKIP FILLER POSITION(1),
invoice_id "AP_INVOICES_INTERFACE_S.nextval" --------------------------------------> Invoice_id should be unique for Header and Lines so i am using NEXTVAL
, vendor_id
, invoice_num
, invoice_currency_code
, invoice_amount
I am trying to Load AP invoices using SQL * Loader, its loading single Invoice Header Line(AP_INVOICES_INTERFACE) with Multiple invoice lines(AP_INVOICE_LINES_INTERFACE) but its not loading multiple invoice header lines (AP_INVOICES_INTERFACE),
My Query:
load data
infile 'multi_ap_interface.txt'
into TABLE AP_INVOICES_INTERFACE
WHEN (01) = 'H'
fields terminated by "," OPTIONALLY ENCLOSED BY '"' TRAILING NULLCOLS
(
REC_SKIP FILLER POSITION(1),
invoice_id "AP_INVOICES_INTERFACE_S.nextval" --------------------------------------> Invoice_id should be unique for Header and Lines so i am using NEXTVAL
, vendor_id
, invoice_num
, invoice_currency_code
, invoice_amount
Tagged:
1