Invalid Objects After Patch 4435139 - CSE_IPA_TRANS_PKG and CSI_ITEM_INSTANCE_PVT (Doc ID 387064.1)

Last updated on MARCH 08, 2017

Applies to:

Oracle Install Base - Version 11.5.10 and later
Information in this document applies to any platform.

Symptoms

After patch 4435139 was applied, the following objects are invalid:
CSE_IPA_TRANS_PKG
and
CSI_ITEM_INSTANCE_PVT

When trying to compile them following errors are displayed:

ERROR
SQL> alter package CSE_IPA_TRANS_PKG compile
Warning: Package altered with compilation errors.
SQL> show error
317/5 PL/SQL: SQL Statement ignored
317/72 PL/SQL: ORA-00904: "SEGMENT7": invalid identifier


SQL> alter package CSI_ITEM_INSTANCE_PVT compile body;
Warning: Package Body altered with compilation errors.
SQL> show error
1392/16 PL/SQL: SQL Statement ignored
1396/70 PL/SQL: ORA-00904: "MILK"."SEGMENT20": invalid identifier

 

FILE VERSIONS

CSEIPATB.pls  115.16.11510.3
csiviib.pls  115.247.11510.38 
invorgk.odf  115.3 
fawba.odf  115.14

faxwbkfv.sql  115.2


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