Lockbox Import Process Going Into Error When Used With BAI Transmission Fomat (Doc ID 2186775.1)

Last updated on NOVEMBER 16, 2016

Applies to:

Oracle Fusion Receivables - Version 11.1.10.0.0 and later
Information in this document applies to any platform.

Symptoms

On : 11.1.10.0.0 version, Lockbox

When attempting to load standard_lockbox_import_interface_template,
the following error occurs.

ERROR
-----------------------
Record 1: Rejected - Error on table AR_PAYMENTS_INTERFACE_ALL, column DEPOSIT_DATE.
ORA-01858: a non-numeric character was found where a numeric was expected

Record 5: Rejected - Error on table AR_PAYMENTS_INTERFACE_ALL, column ITEM_NUMBER.
ORA-01722: invalid number

Record 3: Rejected - Error on table AR_PAYMENTS_INTERFACE_ALL, column DEPOSIT_DATE.
ORA-01858: a non-numeric character was found where a numeric was expected

Record 4: Rejected - Error on table AR_PAYMENTS_INTERFACE_ALL, column ITEM_NUMBER.
ORA-01722: invalid number

Record 6: Rejected - Error on table AR_PAYMENTS_INTERFACE_ALL, column DEPOSIT_DATE.
ORA-01858: a non-numeric character was found where a numeric was expected

Record 7: Rejected - Error on table AR_PAYMENTS_INTERFACE_ALL, column DEPOSIT_DATE.
ORA-01858: a non-numeric character was found where a numeric was expected

Record 8: Rejected - Error on table AR_PAYMENTS_INTERFACE_ALL, column TRANSMISSION_RECORD_COUNT.
ORA-01722: invalid number

STEPS
-----------------------
The issue can be reproduced
1. Complete the spreadsheet
2. Import spreadsheet


BUSINESS IMPACT
-----------------------
The issue has the following business impact:
Due to this issue, users cannot create receipts using spreadsheet.

Cause

Sign In with your My Oracle Support account

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

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms