CSI_UTL_PKG Becomes Invalid with Error "PLS-00364: loop index variable 'ENTITLE_CONTRACTS_REC' use is invalid" (Doc ID 2094627.1)

Last updated on MARCH 08, 2017

Applies to:

Oracle Installed Base - Version 12.1.3 and later
Information in this document applies to any platform.

Goal

CSI_UTL_PKG becomes invalid after applying recommended patches.
Customer installed Oracle E-Business Suite Release 12.1.3+ Recommended Patch Collection 3 [RPC3] and most of the patches recommended by the patch wizard.
While trying to compile APPS.CSI_UTL_PKG compile body getting the following error.
From the code found that table or view which is reported as missing is: mtl_system_items_b1_kfv

SQL> alter package APPS.CSI_UTL_PKG compile body;

Warning: Package Body altered with compilation errors.

SQL> show errors
Errors for PACKAGE BODY APPS.CSI_UTL_PKG:

LINE/COL ERROR
-------- -----------------------------------------------------------------
7421/5 PL/SQL: SQL Statement ignored
7436/9 PL/SQL: ORA-00942: table or view does not exist
7457/7 PL/SQL: Statement ignored
7457/26 PLS-00364: loop index variable 'ENTITLE_CONTRACTS_REC' use is
invalid

 

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