My Oracle Support Banner

Running EGO_ODI_WS_XSL_ZD.xdf / APPS.EGO_ODI_WS_XSL_ZD+ Fails During Patch # 30399999 (Doc ID 2810390.1)

Last updated on OCTOBER 11, 2021

Applies to:

Oracle Product Hub - Version 12.2.4 and later
Information in this document applies to any platform.

Symptoms

On : 12.2.10 version, Online Patching - OP

Actual behavior


When attempting to Patch # 30399999
the following error occurs.

Error

sqlplus -s APPS/***** @/u01/install/APPS/fs2/EBSapps/appl/ad/12.0.0/patch/115/sql/adsqlwrapper.sql '/u01/install/APPS/fs2/EBSapps/appl/ego/12.0.0/patch/115/sql/egoxslzd.sql &un_apps &un_ego'
Connected.

PL/SQL procedure successfully completed.

DECLARE
*
ERROR at line 1:
ORA-04098: trigger 'APPS.EGO_ODI_WS_XSL_ZD+' is invalid and failed
re-validation
ORA-06512: at line 7


Steps

The issue can be reproduced at will with the following steps:
1. adop phase=apply patches=30399999 restart=yes


Cause

To view full details, sign in with your My Oracle Support account.

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


In this Document
Symptoms
Cause
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.