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

MOSC Banner

Patch 7303030 fails on peasgasd.sql with message PL/SQL: program error at "APPS.HR_API_USER_HOOKS_UT

edited Jan 9, 2013 9:17PM in Install, Upgrade, Clone, Patch - EBS (MOSC) 4 commentsAnswered ✓

Hi

Running again the patch 7303030 for an upgrade from 12.0.6 to 12.1.1. and failing on peasgasd.sql. Error messages I see:

FAILED: file peasgasd.sql on worker  1.

Inside the worker main error is :

DELETE_ASSIGNMENT(Business Process API) successful.
BEGIN hr_api_user_hooks_utility.clear_hook_report; END;

*
ERROR at line 1:
ORA-06501: PL/SQL: program error
ORA-06512: at "APPS.HR_API_USER_HOOKS_UTILITY", line 891
ORA-06512: at line 1
Hook Package: HR_ASSIGNMENT_BK2

also an issue I see in the worker ...

-------------------------------

298/1  PLS-00201: identifier 'INVALID_SEE_COMMENT_IN_SOURCE' must be declared
298/1  PL/SQL: Statement ignored

Hook: After Process
-------------------
(PER_GB_PENSRV_SVPN.AUTO_CALC_FTE) The call_procedure does not exist in the call

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