Payables and Cash Management - EBS (MOSC)

MOSC Banner

Unable to load multiple Invoice using Sql * Loader

edited Feb 5, 2013 8:47PM in Payables and Cash Management - EBS (MOSC) 5 commentsAnswered
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

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center