Patch 23210222 Failed With Compilation Errors On OKSAUDET.pll And OKSAUCVT.pll After Applying Patch 19676458 (Doc ID 2146364.1)

Last updated on MAY 06, 2019

Applies to:

Symptoms

On : 12.2.5 version, Patch Application Issues

When attempting to apply patch, 19676458 - ORACLE E-BUSINESS SUITE 12.2.5 RELEASE UPDATE PACK and then trying to apply any of the following patches

the following compilation error occurs on these files.

au      resource        OKCADRTE.pll
au      resource        OKCADSUB.pll
au      resource        OKCADCPY.pll
au      resource        OKCEXEXC.pll
au      resource        OKCKSRCH.pll
au      resource        OKSAUMRG.pll
au      resource        OKCEXPOR.pll
au      resource        OKSAUDET.pll
au      resource        OKSAUCVT.pll
okc     forms/US        OKCADCPY.fmx
okc     forms/US        OKCADSUB.fmx
okc     forms/US        OKCADRTE.fmx
okc     forms/US        OKCEXPOR.fmx
oks     forms/US        OKSAUMRG.fmx
okc     forms/US        OKCEXEXC.fmx
okc     forms/US        OKCKSRCH.fmx
oks     forms/US        OKSAUCVT.fmx
oks     forms/US        OKSAUDET.fmx

ERROR
-----------------------
ERROR generating library "resource/OKSAUDET.plx" from input file
/u01/app/ebs/fs2/EBSapps/appl/au/12.0.0/resource/OKSAUDET.pll

Results of library generation:
(from file /u01/app/ebs/fs2/EBSapps/appl/au/12.0.0/resource/OKSAUDET.err
AD Worker has deleted the original .err file)
-------------------------------------------------------------------------
Compilation errors on OKSAUDET_LINES_CONTACTS:
PL/SQL ERROR 907 at line 0, column 0
cannot load library unit APPS.OKC_CPL_PVT (referenced by APPS.OKC_CONTRACT_PARTY_PVT)
PL/SQL ERROR 0 at line 727, column 22
Item ignored
PL/SQL ERROR 907 at line 0, column 0
cannot load library unit APPS.OKC_CPL_PVT (referenced by APPS.OKC_CONTRACT_PARTY_PVT)
PL/SQL ERROR 0 at line 728, column 22
Item ignored
PL/SQL ERROR 320 at line 732, column 5
the declaration of the type of this expression is incomplete or malformed
PL/SQL ERROR 0 at line 732, column 5
Statement ignored

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
After applying the 12.2.5 patch (19676458) executed the Patch Wizard that identified 70 recommended patches. Of the 70, the following patches failed 23210222, 23210225 and 23192771.

Here is a list of patches that contain OKC or OKS modules.....
OKC - 23495241, 23210225, 22162841, 21549573

OKS - 23192771, 23210222, 23210225, 21246112, 21194572, 22586974

Cause

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