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 AUGUST 11, 2017

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

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms