My Oracle Support Banner

After EBS Upgrade ADOP Prepare Errors Out With java.sql.SQLException: ORA-01422: exact fetch returns more than requested number of rows (Doc ID 2758789.1)

Last updated on JUNE 03, 2023

Applies to:

Oracle Applications DBA - Version 12.2.10 and later
Information in this document applies to any platform.

Symptoms

When performing post-upgrade steps to check the Oracle E-Business Suite upgrade from R12.1.3 to 12.2, the initial online patching cycle prepare phase fails when running AutoConfig on the patch edition file system. The following two errors can be found in adop logs:

ERROR 1:
---------------
[EVENT] Running AutoConfig on patch edition file system.
  [PROCEDURE] [START 2021/02/16 09:27:43] Running AutoConfig
  [UNEXPECTED]Error occurred running "sh <DIRECTORY>/fs1/EBSapps/appl/ad/12.0.0/bin/adconfig.sh contextfile=<DIRECTORY>/fs2/inst/apps/<HOSTNAME>/appl/admin/<HOSTNAME>.xml promptmsg=hide log=<DIRECTORY>/fs_ne/EBSapps/log/adop/5/20210216_092323/prepare/<hostname>/adconfig.log"
  [UNEXPECTED]Error calling runPendingClone subroutine.
  [EVENT] Stopping services on patch file system.

ERROR 2:
---------------
Creating the DBC file...
java.sql.SQLException: ORA-01422: exact fetch returns more than requested number of rows
ORA-06512: at "APPS.FND_PROFILE", line 403
ORA-06512: at "APPS.FND_PROFILE", line 1308
ORA-06512: at "APPS.FND_PROFILE", line 1787
ORA-06512: at "APPS.FND_WEB_CONFIG", line 269
ORA-06512: at line 1
- Error getting database ID

ADD call failed with exit code 1

 

You might also find the following "ERROR Prepare Failure" error (see bolded error below) in the adzdshowlog.out file:

1693660162 14:54:07 00:00:00 ad.plsql.ad_zd_seed.create_sync PROCEDURE begin: APPLSYS.FND_PROFILE_OPTION_VALUES
1693660162 14:54:08 00:00:00 ad.plsql.ad_zd_seed.create_sync EVENT Creating EDS Sync Trigger FND_PROFILE_OPTION_VALUES>
1693660162 14:54:08 00:00:00 ad.plsql.ad_zd_seed.create_sync STATEMENT SQL: create or replace trigger APPS."FND_PROFILE_OPTION_VALUES>"
for insert or update or delete on APPLSYS.FND_PROFILE

1693660162 14:54:08 00:00:00 ad.plsql.ad_zd_seed.create_sync EVENT Copy Seed Data using insert-select: FND_PROFILE_OPTION_VALUES
1693660162 14:54:08 00:00:00 ad.plsql.ad_zd_seed.create_sync STATEMENT SQL: insert /*+ ignore_row_on_dupkey_index("FND_PROFILE_OPTION_VALUES","FND_PROFILE_OPTION_VALUES_U1") */
into "APPLSYS

1693660162 14:54:10 00:00:01 ad.plsql.ad_zd_seed.create_sync ERROR ERROR: ORA-01422: exact fetch returns more than requested number of rows
ORA-06512: at "APPS.FND_PROFILE_OPTION_VAL_AUD"

1693660162 14:54:10 00:00:00 ad.plsql.ad_zd_seed.prepare ERROR Prepare Failure, reversing actions: FND_PROFILE_OPTION_VALUES
1693660162 14:54:10 00:00:00 ad.plsql.ad_zd_seed.create_guard EVENT Creating EDS Guard Trigger FND_PROFILE_OPTION_VALUES+
1693660162 14:54:10 00:00:00 ad.plsql.ad_zd_seed.create_guard STATEMENT SQL: create or replace trigger "APPS"."FND_PROFILE_OPTION_VALUES+" before insert or update or delete on "APPLSYS"."FND_
1693660162 14:54:10 00:00:00 ad.plsql.ad_zd_seed.prepare STATEMENT SQL: drop trigger APPS."FND_PROFILE_OPTION_VALUES>"
1693660162 14:54:10 00:00:00 ad.plsql.ad_zd_seed.prepare ERROR TABLE: FND_PROFILE_OPTION_VALUES, CODE: -1422, MESSAGE: "ORA-01422: exact fetch returns more than requested number of ro
1693660162 14:54:10 00:00:00 ad.plsql.ad_zd_seed.prepare ERROR TABLE: FND_PROFILE_OPTION_VALUES, BACKTRACE: ORA-06512: at "APPS.FND_PROFILE_OPTION_VAL_AUD", line 11
ORA-06512: at "APP

 

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
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.