122 Upgrade Patch Failed on Benzzconcle.sql : ORA-04098: trigger 'APPS.PERCONTACTRELATIONSHI_109D_DYT' is invalid and failed (Doc ID 1907839.1)

Last updated on APRIL 25, 2017

Applies to:

Oracle Advanced Benefits - Version 12.2 and later
Information in this document applies to any platform.

Goal

Apply  12.2 Upgrade Patch and it fails with the following:

sqlplus -s APPS/***** @/ddmo4i/applmgr/fs1/EBSapps/appl/ad/12.0.0/patch/115/sql/adsqlwrapper.sql '/ddmo4i/applmgr/fs1/EBSapps/appl/ben/12.0.0/patch/115/sql/benzzconcle.sql '
Connected.

PL/SQL procedure successfully completed.

begin
*
ERROR at line 1:
ORA-04098: trigger 'APPS.PERCONTACTRELATIONSHI_109D_DYT' is invalid and failed
re-validation
ORA-06512: at line 3


How to proceed?
 

Solution

Sign In with your My Oracle Support account

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

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms