Patch 5075182 causes invalid object APPS.FND_OID_DIAG (Doc ID 360285.1)

Last updated on MAY 03, 2016

Applies to:

Oracle Applications DBA - Version 11.5.9 to 11.5.10.2 [Release 11.5 to 11.5.10]
Information in this document applies to any platform.
Application Install - Version: 11.5.9 to 11.5.10.2
***Checked for relevance on 07-Jun-2013***

Symptoms

Applying <Patch 5075182>, causes APPS.FND_OID_DIAG to become invalid.

To check if FND_OID_DIAG is invalid, please execute following select :

select owner, object_name, object_type, status
from dba_objects
where object_name = 'FND_OID_DIAG';

 

OWNEROBJECT_NAMEOBJECT_TYPESTATUS
APPS FND_OID_DIAG PACKAGE VALID
APPS FND_OID_DIAG PACKAGE BODY INVALID


To try and recompile FND_OID_DIAG using following commands :

alter package APPS.FND_OID_DIAG compile;

Warning: Package altered with compilation errors

alter package APPS.FND_OID_DIAG compile body;

Warning: Package body altered with compilation errors

To see the errors occurring for FND_OID_DIAG compilation :

show errors
Error: PLS-00201: identifier 'FND_OID_UTIL.GET_OID_SESSION' must be declared
Line: 76
Text: ldapSession := fnd_oid_util.get_oid_session;
Error: PL/SQL: Statement ignored
Line: 76
Text: ldapSession := fnd_oid_util.get_oid_session;
Error: PLS-00201: identifier 'FND_OID_UTIL.UNBIND' must be declared
Line: 121
Text: result := fnd_oid_util.unbind(ldapSession);
Error: PL/SQL: Statement ignored
Line: 121
Text: result := fnd_oid_util.unbind(ldapSession);
Error: Hint: Variable 'errNumber' is declared but never used in 'fnd_oid_diag'

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