My Oracle Support Banner

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

  1. 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

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