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

MOSC Banner

R12.1.3 : hrglobal failing with invalid trigger

edited Nov 24, 2013 10:59PM in Install, Upgrade, Clone, Patch - EBS (MOSC) 2 commentsAnswered
Hi,
hrglobal failing with invalid trigger

Problem Description
---------------------------------------------------
Start time for file is: Wed Nov 20 2013 13:22:33

sqlplus -s APPS/***** @$APPL_TOP/pay/12.0
.0/patch/115/sql/pyieprdt.sql
Connected.
declare
*
ERROR at line 1:
ORA-20001: pyieprdt.sql failed: ORA-04098: trigger
'APPS.HR_PAY_IF_REP_NAME_UNIQUE_ASIU' is invalid and failed re-validation
ORA-06512: at line 367


The trigger APPS.HR_PAY_IF_REP_NAME_UNIQUE_ASIU is invalid  and has errors :


select line,text from user_errors where name='HR_PAY_IF_REP_NAME_UNIQUE_ASIU'

SQL> /

     LINE TEXT
---------- ----------------------------------------------------------------------------------------------------
       13 PLS-00905: object APPS.HR_PAY_INTERFACE_PKG is invalid
       12 PL/SQL: Statement ignored
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