My Oracle Support Banner

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 [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:
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


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

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