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 laterInformation 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
-----------------------
[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 |