Error When Trying to Select a Payment Term: ORA-01840 Input Value Not Long Enough for Date Format
(Doc ID 2755234.1)
Last updated on JULY 14, 2021
Applies to:Oracle Receivables - Version 12.1 to 12.2 [Release 12.1 to 12.2]
Information in this document applies to any platform.
When entering an invoice, and trying to select a specific payment term, the following error occurs:
ORA-1840: input value not long enough for date format.
ORA-6512: at "APPS.ARPT_SQL_FUNC_UTIL", line 1335.
FRM-40502: ORACLE error: unable to read list of values.
Steps to Reproduce:
Responsibility: Receivables Manager
Navigation: Transactions > Transactions
- Enter an invoice and select a newly created payment term from the list of values.
A new payment term was setup, and tied to a Billing Cycle.
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!
In this Document