Online Patch Enabling Patch Is Failing on ADZDPREP.sql

[Mansoor]

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;
/

Thanks

[ErmanArslansOracleBlog]

There may be some patches missing in your env.

Did you check the following? and consider taking its action plan?

ADOP - Patch 13543062 fails on ADZDPREP.sql - ORA-20001: ORA-06508: PL/SQL: could not find program unit being called (Doc ID 1630377.1)

[Mansoor]

Thanks for quick reply.

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

Thanks

[ErmanArslansOracleBlog]

Now I realized that you are in the old forum.

You should create this thread in the new forum.

The link is http://erman-arslan-s-oracle-forum.124.s1.nabble.com/

please create the same thread in there.