My Oracle Support Banner

R12.AD.C.delta.4 : Adop Phase=finalize Fails On Script ADZDPATCHSTAT.sql (Doc ID 1663525.1)

Last updated on JUNE 21, 2023

Applies to:

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

Symptoms

On : 12.2 version, Upgrade related issues

When attempting to execute adop phase=finalize
the following error occurs.

ERROR
-----------------------

  [STATEMENT] Output: <ADOP_LOG_HOME>/3/finalize_<DATE TIME>/<CONTEXT_NAME>/adzdpatchstat.out

  [ERROR] Error occurred while executing
  [STATEMENT] [END <DATE TIME>] Generating Post Finalize Reports
  [ERROR] Error while executing runGeneratePostFinalizeReport
  [STATEMENT] [START <DATE TIME>] Unlocking sessions table
  [STATEMENT] SQL stmt: < begin
  AD_ZD_ADOP.UNLOCK_SESSIONS_TABLE('fdjebs1',60,2);


The output of adzdpatchstat.out is :

declare
*
ERROR at line 1:
ORA-00933: SQL command not properly ended
ORA-06512: at "APPS.AD_ZD_ADOP", line 72
ORA-06512: at line 11

 

Changes

PATH B from Note <<1617461.1>> - R12.AD.C.Delta.4 and R12.TXK.C.Delta.4 Release Update Packs has been applied. From this note the incorrect PATH has been followed. As this is a new upgrade PATH A should have been followed. But in case the adop phase=finalize analytics=yes is executed the same error will show up.

 

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.