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

Last updated on MARCH 04, 2024

Applies to:

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

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.