ORA-01795 Error Occurs When Attempting OPPM Package Import (Doc ID 2242867.1)

Last updated on MARCH 10, 2017

Applies to:

Primavera Portfolio Management - Version 15.1.1.0 and later
Information in this document applies to any platform.

Symptoms

On OPPM 15.1.1.0 version, Server Utilities

When attempting to import an OPPM Packager package, the following error occurs.

ERROR
-----------------------
ORA-01795: maximum number of expressions in a list is 1000


STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Via the OPPM Packager, attempt to import package.

BUSINESS IMPACT
-----------------------
The issue has the following business impact:
Due to this issue, OPPM packages cannot be imported.

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