Updating Transaction Payment Terms, Using the List of Values (LOV) and Receive Error - ORA-1840: Input Value Not Long Enough for Date Format
(Doc ID 1904562.1)
Last updated on FEBRUARY 29, 2024
Applies to:
Oracle Receivables - Version 12 to 12.1.3.4 [Release 12.0 to 12.1]Information in this document applies to any platform.
Symptoms
On : 12.1.3 version, Transactions Related
Attempting to create a Transaction. You try to query on the List of Values (LOV) for the Payment Terms and receive the following error:
ERROR
-----------------------
ORA-1840: input value not long enough for date format.
ORA-6512: at "APPS.ARPT_SQL_FUNC_UTIL", line 1267.
Steps to Reproduce:
Responsibility: Receivables
Navigation: Transactions > Transactions
Enter Customer information
Go To: Payment Terms
Click on the LOV button and enter value %
Click Find and error occurs
Cause
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
Symptoms |
Cause |
Solution |