Running Lockbox Process Is Ending With Errors: ORA-01843: not a valid month and ORA-01722: invalid number. (Doc ID 2676741.1)

Last updated on AUGUST 24, 2020

Applies to:

Symptoms

On Oracle Fusion Receivables, Trying to import receipts using lockbox is getting these errors:

Error:

Record 1: Rejected - Error on table AR_PAYMENTS_INTERFACE_ALL, column DEPOSIT_DATE.
ORA-01843: not a valid month.

Record 3: Rejected - Error on table AR_PAYMENTS_INTERFACE_ALL, column DEPOSIT_DATE.
ORA-01843: not a valid month.

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

Record 6: Rejected - Error on table AR_PAYMENTS_INTERFACE_ALL, column AMOUNT_APPLIED1.
ORA-01722: invalid number.

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

Record 10: Rejected - Error on table AR_PAYMENTS_INTERFACE_ALL, column AMOUNT_APPLIED1.
ORA-01722: invalid number.

Record 12: Rejected - Error on table AR_PAYMENTS_INTERFACE_ALL, column DEPOSIT_DATE.
ORA-01843: not a valid month.

Record 13: Rejected - Error on table AR_PAYMENTS_INTERFACE_ALL, column DEPOSIT_DATE.
ORA-01843: not a valid month.



Steps to reproduce the issue:

The issue can be reproduced at will with the following steps:

1. On Navigator.
2. Go to Tools > Scheduling Processes.
3. Run Lockbox process.
4. Reviewed the report and observed the errors described appear.

Cause

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