My Oracle Support Banner : 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.


On : 12.2 version, Upgrade related issues

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


  [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

The output of adzdpatchstat.out is :

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



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.



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

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