Online Patch Enabling Patch Is Failing on ADZDPREP.sql

Posted by Mansoor8810 on Feb 05, 2025; 7:50pm
URL: http://erman-arslan-s-oracle-forum.124.s1.nabble.com/Online-Patch-Enabling-Patch-Is-Failing-on-ADZDPREP-sql-tp12906.html

DOC> ***************************************************
DOC> Move XML SCHEMA to a Non-Editioned E-biz user (APPS_NE)
DOC>
DOC>#
begin
*
ERROR at line 1:
ORA-20001: ORA-01453: SET TRANSACTION must be first statement of transaction
ORA-06512: at "APPS.AD_ZD", line 29
ORA-06512: at "APPS.AD_ZD_PREP", line 423
ORA-06512: at line 3
Restarted: file ADZDPREP.sql on worker 1 for product ad username APPLSYS.
FAILED: file ADZDPREP.sql on worker 1 for product ad username APPLSYS.

ATTENTION: All workers either have failed or are waiting:

       FAILED: file ADZDPREP.sql on worker  1.
ATTENTION: Please fix the above failed worker(s) so the manager can continue.


We are upgrading with database version is 11.2.0.4.

There are no errors in compiling the pacakge.

SQL> alter package AD_ZD_PREP compile body;

Package body altered.

The actual error is happening while moving XML shchema in

ADZDPREP.sql script.

Move XML SCHEMA to a Non-Editioned E-biz user (APPS_NE)

begin
ad_zd.log('adzdprep', 'STATEMENT','Move XML SCHEMA: begin');
ad_zd_prep.move_xml_schemas;
ad_zd.log('adzdprep', 'STATEMENT','end');
end;
/
yes I verified MOS Doc ID 1630377.1.The XDB_MIGRATESCHEMA package is valid in our environment.
So that document is not helpful.

SQL> select object_name,object_type,status from dba_objects where object_name ='XDB_MIGRATESCHEMA';

OBJECT_NAME
--------------------------------------------------------------------------------
OBJECT_TYPE         STATUS
------------------- -------
XDB_MIGRATESCHEMA
PACKAGE             VALID

XDB_MIGRATESCHEMA
PACKAGE BODY        VALID