My Oracle Support Banner

EBS Autoconfig fails on database tier - afdbprf.sh - ORA-01422: exact fetch returns more than requested number of rows ORA-06512: at "APPS.ADX_PRF_PKG" (Doc ID 2995542.1)

Last updated on DECEMBER 29, 2023

Applies to:

Oracle E-Business Suite Technology Stack - Version 12.2.3 to 12.2.13 [Release 12.2]
Information in this document applies to any platform.

Symptoms

When running autoconfig on EBS database tier, the following error occurs :

Executing script in InstantiateFile:
<>/db/tech_st/19.0.0/appsutil/install/<>/afdbprf.sh

SQL*Plus: Release 19.0.0.0.0 - Production on Thu Dec 14 07:56:30 2023
Version 19.19.0.0.0

Copyright (c) 1982, 2022, Oracle. All rights reserved.

Enter value for 1: Enter value for 2: Enter value for 3: Connected.
begin
*
ERROR at line 1:
ORA-01422: exact fetch returns more than requested number of rows
ORA-06512: at "APPS.ADX_PRF_PKG", line 52
ORA-06512: at line 7

Disconnected from Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production
Version 19.19.0.0.0
ERRORCODE = 1 ERRORCODE_END

Changes

 No known changes

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


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