CSI_ITEM_INSTANCE_VLD_PVT Invalid After Applying Patch 8490923

(Doc ID 1334220.1)

Last updated on MARCH 08, 2017

Applies to:

Oracle Install Base - Version 11.5.10.2 and later
Information in this document applies to any platform.
***Checked for relevance on 26-Mar-2013***

CSI_UTL_PKG
GET_LOT_CTRL_CODE
PLS-00302
csiviivb.pls

Symptoms

After applying <Patch 8490923>,  there was a new invalid object CSI_ITEM_INSTANCE_VLD_PVT with compilation error raised .. as follows


LINE/COL ERROR
-------- -----------------------------------------------------------------
1638/6 PL/SQL: SQL Statement ignored
1639/19 PL/SQL: ORA-00904: "CSI_UTL_PKG"."GET_LOT_CTRL_CODE": invalid
identifier

1639/31 PLS-00302: component 'GET_LOT_CTRL_CODE' must be declared
1639/31 PLS-00302: component 'GET_LOT_CTRL_CODE' must be declared
6714/7 PL/SQL: SQL Statement ignored
6717/11 PL/SQL: ORA-00904: "CSI_UTL_PKG"."GET_LOT_CTRL_CODE": invalid

Cause

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