My Oracle Support Banner

12.2.10 Upgrade - PAUPGLOC.sql Failed with ORA-20001 Error in Populating Records0: ORA-01422: Exact Fetch Returns More Than Requested Number of Rows (Doc ID 2826192.1)

Last updated on JULY 16, 2024

Applies to:

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

Symptoms

Upgrade from 11.5.10.2 to 12.2.10.

While performing the installation of the 12.2 merged upgrade patch, errors are encountered with PAUPGLOC.sql.

adworker log shows the errors.

PL/SQL procedure successfully completed.

declare
*
ERROR at line 1:
ORA-20001: Error in populating Records0: ORA-01422: exact fetch returns more
than requested number of rows
ORA-06512: at line 114

Replication steps:
- Apply the 12.2 merged patch via adpatch.
- Review the adworker logs for errors.

Changes

Upgrade from 11.5.10.2 to 12.2.10. 

Cause

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
Symptoms
Changes
Cause
Solution
References


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