FA:SCM:SCP: ORA-01795: maximum number of expressions in a list is 1000 (Doc ID 2645494.1)

Last updated on APRIL 25, 2020

Applies to:

Symptoms

When attempting to trying to change the Currency used
in the Inventory Turns and Demand at risk infotiles.
the following error occurs.

ERROR
-----------------------
oracle.apps.scm.advancedPlanning.common.planMeasures.protectedUiModel.applicat
ionModule.MeasuresAMImpl.initializeMeasureFormat(MeasuresAMImpl.java:1006)
Caused by: java.sql.SQLSyntaxErrorException: ORA-01795: maximum number of
expressions in a list is 1000


STEPS
-----------------------
The issue can be reproduced at will with the following steps:

1) Try to change the currency in the infotiles and save.

Error thrown :

at oracle.jbo.server.BaseSQLBuilderImpl.processException(BaseSQLBuilderImpl.java:
3738)
at oracle.jbo.server.OracleSQLBuilderImpl.processException(OracleSQLBuilderImpl.j
ava:4550)

Cause

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