List of Values for Table Validated Descriptive Flexfield Errors Java.sql.SQLSyntaxErrorException: ORA-01722: Invalid Number (Doc ID 1628833.1)

Last updated on SEPTEMBER 06, 2016

Applies to:

Oracle Internet Expenses - Version 12.1.3 and later
Information in this document applies to any platform.

Symptoms

On the Receipt Details page, choose the list of values for the descriptive flexfield. Search for a value from the list of values. However, the following error occurs:

oracle.apps.fnd.framework.OAException: oracle.jbo.SQLStmtException: JBO-27122: SQL error during statement preparation. Statement: select fnd_number.number_to_canonical(CMS_SID) FLEX_ID
, CUSTOMER_NAME FLEX_VALUE
, CUSTOMER_NAME FLEX_DISPLAY
from ICAP_OIE_CMS_CUSTOMERS_EXCL_V
where (1 = 1)
and 'Y' = 'Y'
and nvl(fnd_date.canonical_to_date(:1), trunc(SysDate))
between nvl(trunc(to_date(null)), nvl(fnd_date.canonical_to_date(:2), trunc(SysDate)))
and nvl(trunc(to_date(null)), nvl(fnd_date.canonical_to_date(:3), trunc(SysDate)))
and (upper(CUSTOMER_NAME ) like :L1
and (CUSTOMER_NAME like :L2
or CUSTOMER_NAME like :L3
or CUSTOMER_NAME like :L4
or CUSTOMER_NAME like :L5))
order by CUSTOMER_NAME
at oracle.apps.fnd.framework.OAException.wrapperException(OAException.java:912)
at oracle.apps.fnd.framework.webui.OAPageErrorHandler.prepareException(OAPageErrorHandler.java:1169)

...

## Detail 0 ##
java.sql.SQLSyntaxErrorException: ORA-01722: invalid number

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