R12.1.3 : hrglobal failing with invalid trigger
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
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:
0