Invalid DB Objects Found after Applying SES Bundle Patch (Doc ID 2287046.1)

Last updated on JULY 28, 2017

Applies to:

Oracle Secure Enterprise Search - Version 11.2.2.2.0 and later
Information in this document applies to any platform.

Symptoms

Installed SES 11.2.2.2 with DB 11.2.0.3 and Integrated with PSFT 8.53

After applying SES BP6 and overlay patches few DB invalid objects found and that ultimately resulting in the PeopleSoft round trip test failure.

Issue can be reproduced with these steps:

===========================

1. Install fresh SES instance
2. Apply BP5 and BP6
3. Upgrade DB to 12c
4. Apply BP6 overlay patches and then BP6+ patch.

After this while checking can see invalid objects

OWNER                OBJECT_TYPE       OBJECT_NAME         STATUS
-----------            --------------------   ------------------- ----------
SEARCH_ESS         PACKAGE BODY ESSI_SQLNOTIFY    INVALID
SEARCHSYS           PACKAGE BODY   EQ_CRW               INVALID

 

Trying to recompile fails with the error "PLS-00306: wrong number or types of arguments in call to 'RESPONSE_MSG_TYPE' "

Complete stack is as follows:

==================

 

Changes

 

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