Adop Cutover Failed with ORA-01422: exact fetch returns more than requested number of rows After Applying AD & TXK Delta.7 (Doc ID 2096919.1)

Last updated on JANUARY 18, 2016

Applies to:

Oracle Applications DBA - Version 12.2.3 to 12.2.3 [Release 12.2Cloud]
Information in this document applies to any platform.

Symptoms

One has applied the AD & TXK Delta.7 to an EBS 12.2.3 RAC instance, when perform cutover,

it failed with the following error:

  [ERROR] Failed to execute SQL statement :
  declare
  result varchar2(10);
  begin
  ad_zd_adop.cutover;
  exception when others then
  update ad_adop_sessions set status='F'
  where adop_session_id=26;
  commit;
  raise_application_error(-20001,'Error while calling ad_zd_adop.cutover.' || sqlerrm);
  end;

  [ERROR] Error Message :
  [ERROR] ORA-20001: Error while calling ad_zd_adop.cutover.ORA-01422: exact fetch returns more than requested number of rows
  [ERROR] ORA-06512: at "APPS.AD_ZD_LOG", line 78
  [ERROR] ORA-06512: at "APPS.AD_ZD", line 17
  [ERROR] ORA-06512: at "APPS.AD_ZD", line 61
  [ERROR] ORA-01422: exact fetch returns more than requested number of rows
  [ERROR] ORA-06512: at line 9 (DBD ERROR: OCIStmtExecute)
  [UNEXPECTED]Error occurred while performing database cutover
  [UNEXPECTED]Cutover phase completed with errors/warnings. Please check logfiles



Changes

 Applied AD & TXK Delta 7

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