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 SEPTEMBER 01, 2024
Applies to:
Oracle Applications DBA - Version 12.2.10 and laterInformation 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:
---------------
[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 |