PLS-00201: identifier 'SYS.XDB_MIGRATESCHEMA' must be declared

 [applmgr@oracle ~]$ sqlplus apps/*****@DB

SQL > alter package AD_ZD_PREP compile body;

Warning: Package Body altered with compilation errors.

SQL> show error;

Errors for PACKAGE BODY AD_ZD_PREP:

LINE/COL ERROR

-------- -----------------------------------------------------------------

467/3    PL/SQL: SQL Statement ignored

467/19   PL/SQL: ORA-00942: table or view does not exist

471/5    PL/SQL: SQL Statement ignored

471/21   PL/SQL: ORA-00942: table or view does not exist

491/5    PL/SQL: Statement ignored

491/5    PLS-00201: identifier 'SYS.XDB_MIGRATESCHEMA' must be declared

505/5    PL/SQL: SQL Statement ignored

505/21   PL/SQL: ORA-00942: table or view does not exist

Solution:

SQL> select owner, object_name from dba_objects where lower(object_name) ='xdb_migrateschema';

no row select

# oracle@ora admin]$ sqlplus / as sysdba

SQL> grant READ on DIRECTORY FND_DIAG_DIR to APPS;

SQL> grant WRITE on DIRECTORY FND_DIAG_DIR to APPS;

SQL>@$ORACLE_HOME/rdbms/admin/dbmsxdbschmig.sql

SQL>@$ORACLE_HOME/rdbms/admin/prvtxdbschmig.plb

SQL> select owner, object_name from dba_objects where lower(object_name) ='xdb_migrateschema';

OWNER              OBJECT_NAME

SYS         XDB_MIGRATESCHEMA

SYS         XDB_MIGRATESCHEMA

2 rows selected.

# cd /u01/db/tech_st/12.1.0.2/appsutil/admin

adgrants.sql version > 120.67.12020000.69 2020/03/20 00:56:38

# sqlplus /nolog

# @/adgrants.sql apps

[applmgr@oracle ~]$ sqlplus apps/*****@DB

SQL> alter package AD_ZD_PREP compile body;

Package body altered.

 SQL > select owner,object_name,object_type from dba_objects where status='INVALID' and object_name like 'AD_ZD%';

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