Hello,
in order to import all data of invoices from a txt file to oracle I find that I have to import all data to
AP_INVOICES_INTERFACE
AP_INVOICE_LINES_INTERFACE
but when I added the date it is giving me error
how can I put the date :
fields terminated by ',' optionally enclosed by '"'
TRAILING NULLCOLS
(
INVOICE_ID
,INVOICE_NUM
,INVOICE_TYPE_LOOKUP_CODE
,INVOICE_DATE DATE 'DD-MON-YYYY'
,VENDOR_NAME
,VENDOR_SITE_CODE
,INVOICE_AMOUNT
,INVOICE_CURRENCY_CODE
--,EXCHANGE_DATE
,SOURCE
,DESCRIPTION
)
I got this error in the result:
Record 1: Rejected - Error on table "AP"."AP_INVOICES_INTERFACE", column INVOICE_DATE.
ORA-01861: literal does not match format string