Package Body ICX_PRDS_GEN_PKG Invalid After Application Of Patches (Doc ID 2299491.1)

Last updated on OCTOBER 10, 2022

Applies to:

Symptoms

On : 12.2.5 version, Patch Application Issues

After the application of patches : 19906190:R12.AP.C and 22684834:R12.ICX.D the package body ICX_PRDS_GEN_PKG has become invalid.

ERROR
-----------------------

SQL> alter package apps.ICX_PRDS_GEN_PKG compile body;

Warning: Package Body altered with compilation errors.

SQL> sho err
Errors for PACKAGE BODY APPS.ICX_PRDS_GEN_PKG:

LINE/COL ERROR
-------- -----------------------------------------------------------------
193/3 PL/SQL: SQL Statement ignored
193/56 PL/SQL: ORA-00942: table or view does not exist
216/2 PL/SQL: SQL Statement ignored
216/14 PL/SQL: ORA-00942: table or view does not exist
1697/3 PL/SQL: SQL Statement ignored
1697/56 PL/SQL: ORA-00942: table or view does not exist
1703/1 PL/SQL: SQL Statement ignored
1703/13 PL/SQL: ORA-00942: table or view does not exist
1764/1 PL/SQL: SQL Statement ignored
1766/6 PL/SQL: ORA-00942: table or view does not exist
1774/1 PL/SQL: SQL Statement ignored


STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Apply patches 19906190:R12.AP.C and 22684834:R12.ICX.D
2. Observe that package body .ICX_PRDS_GEN_PKG is invalid and cannot be compiled due to error

Cause

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