R12.2 Apps DBA. Powered by Blogger.

APPS.AD_ZD_ADOP package body errors adop apply failed

No comments :
[ERROR] Failed to execute SQL statement :
select AD_ZD_ADOP.GET_INVALID_NODES() from dual
[ERROR] Error Message :
[ERROR] Failed to execute SQL statement :
select AD_ZD_ADOP.GET_INVALID_NODES() from dual
[ERROR] Error Message :
[UNEXPECTED]Nodes "-1" are listed in ADOP_VALID_NODES table but not in FND_NODES table.
[UNEXPECTED]To correct this, run AutoConfig on nodes "-1"
[UNEXPECTED]Error while checking if this is a multi node instance
SQL> ALTER PACKAGE APPS.AD_ZD_ADOP COMPILE BODY;
Warning: Package Body altered with compilation errors.
SQL> SHOW ERROR
Errors for PACKAGE BODY APPS.AD_ZD_ADOP:
LINE/COL ERROR
-------- -----------------------------------------------------------------
505/13 PL/SQL: SQL Statement ignored
507/86 PL/SQL: ORA-00904: "SESSION_TYPE": invalid identifier
511/13 PL/SQL: SQL Statement ignored
Solution:
1. Verify that your ad_adop_session_patches.xdf file is version 120.6.12020000.4
grep Header $AD_TOP/patch/115/xdf/ad_adop_session_patches.xdf
2. If the version is correct, then run this command
adjava -mx512m -nojit oracle.apps.fnd.odf2.FndXdfCmp applsys APPS apps APPS thin <host>:<PORT>:<SID>
table $AD_TOP/patch/115/xdf/ad_adop_session_patches.xdf $FND_TOP/patch/115/xdf/xsl changedb=y
Please put in the actual host (fully qualified), port, and SID
NOTE: If you would like to test the command first, please change "changedb=y" to "changedb=n".
3. Please retry compiling AD_ZD_ADOP (or retry running ADZDADOPB.pls).
4. If the compilation works, retry the patch.

No comments :

Post a Comment

Note: only a member of this blog may post a comment.