3438354 : 11.5.10.2 : The patch is failing because of invalid objects
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'