Install, Upgrade, Clone, Patch - EBS (MOSC)

MOSC Banner

3438354 : 11.5.10.2 : The patch is failing because of invalid objects

edited Jun 27, 2018 10:30AM in Install, Upgrade, Clone, Patch - EBS (MOSC) 8 commentsAnswered

Hi : This thread will address your following issue

Trying to apply u3438354.drv.  Workers failing because cannot compile database objects
I looked at the worker log files and noticed apps.per_people_f is invalid.  Looks like it's because a package it depends on is missing a procedure or function.
Here's the sqlplus session below:

FMSD> sho user
USER is "APPS"
FMSD> select object_type from dba_objects where object_name='PER_PEOPLE';

OBJECT_TYPE
------------------
VIEW
SYNONYM

FMSD> alter view per_people compile force;

Warning: View altered with compilation errors.

FMSD> select text from user_errors
where name='PER_PEOPLE'

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

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

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center