After Database Upgrade to 10g some APPS Dependent Objects Become Invalid in CTXSYS Schema

(Doc ID 756967.1)

Last updated on FEBRUARY 08, 2017

Applies to:

Oracle Text - Version 10.2.0.1 to 10.2.0.5 [Release 10.2]
Information in this document applies to any platform.
***Checked for relevance on 06-Aug-2013***


Symptoms

After database upgrade from 9iR2  to 10gR2 , following objects are invalid in CTXSYS schema.

OWNER         OBJECT_NAME                     OBJECT_TYPE
------------  ---------------------------     ---------------------
CTXSYS        EGO_ITEM_TEXT_CTX_PKG           PACKAGE BODY
CTXSYS        HZ_CTX_CUSTOMER_TEXT            PACKAGE BODY


While compiling manually following errors are reported in DBA_ERORRS.
 

NAME                         TEXT
---------                    --------
EGO_ITEM_TEXT_CTX_PKG        PLS-00201: identifier 'APPS.EGO_ITEM_TEXT_UTIL' must be declared
EGO_ITEM_TEXT_CTX_PKG        PL/SQL: Statement ignored
HZ_CTX_CUSTOMER_TEXT         PLS-00201: identifier 'APPS.RA_CUSTOMER_TEXT_PKG' must be declared
HZ_CTX_CUSTOMER_TEXT         PL/SQL: Statement ignored

Changes

This problem comes after upgrading to 10g environment from 9i and APPS (Oracle E-Business) is being used.

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms