Updating Transaction Payment Terms, Using the List of Values (LOV) and Receive Error - ORA-1840: Input Value Not Long Enough for Date Format
Last updated on FEBRUARY 06, 2018
Applies to:Oracle Receivables - Version 12 to 18.104.22.168 [Release 12.0 to 12.1]
Information in this document applies to any platform.
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:
ORA-1840: input value not long enough for date format.
ORA-6512: at "APPS.ARPT_SQL_FUNC_UTIL", line 1267.
Steps to Reproduce:
Navigation: Transactions > Transactions
Enter Customer information
Go To: Payment Terms
Click on the LOV button and enter value %
Click Find and error occurs
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
Million Knowledge Articles and hundreds of Community platforms