R12.AD.C.delta.4 : Adop Phase=finalize Fails On Script ADZDPATCHSTAT.sql
(Doc ID 1663525.1)
Last updated on FEBRUARY 16, 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.
[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