Anyone successfully loaded Credit Card Transactions using US Bank VCF 4.0 format?
Hi,
We are changing our Procurement Cards to US Bank. I have the credit card transactions file from the bank, they say it is VCF 4.0 format, however, when I run the Credit Card Transactions Loader Preformat and US Bank Visa Transaction Loader programs, I cannot get anything to load into AP_CREDIT_CARD_TRXNS_ALL.
Record 1: Rejected - Error on table "AP"."AP_CREDIT_CARD_TRXNS_ALL", column TRANSACTION_DATE. ORA-01858: a non-numeric character was found where a numeric was expected
I don't think the file format is what Oracle expects. I have reviewed several MOS notes but have not found any solution.