PAXPREPR Project Creation Results In Error - PA_LOCATION_UTILS.CHECK_LOCATION_EXISTS SQL ERROR MESSAGE: ORA-1422

(Doc ID 2035140.1)

Last updated on MARCH 08, 2017

Applies to:

Oracle Project Foundation - Version 12.1.3 and later
Information in this document applies to any platform.

Symptoms

When attempting to Copy template to create new project, after entering
project details in the quick entry window the following error occurs.
 
ERROR
-----------------------
API: PA_LOCATION_UTILS.CHECK_LOCATION_EXISTS SQL ERROR MESSAGE: ORA-1422:
EXACT FETCH RETURNS MORE THAN REQUESTED NUMBER OF ROWS

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