Invalid Install Base (CSI) Objects After Applying Patch 7836468 (Doc ID 790540.1)

Last updated on SEPTEMBER 06, 2016

Applies to:

Oracle Install Base - Version 11.5.10.2 to 11.5.10.2 [Release 11.5]
Information in this document applies to any platform.
***Checked for relevance on 19-Feb-2013***


Symptoms


After applying Patch 7836468 there are invalid objects in the database, which prevent Install Base transactions from being processed.

The invalid packages are:

CSI_INV_INTERORG_PKG
CSI_INV_ISO_PKG
CSI_INV_TXNSTUB_PKG
CSI_PROCESS_TXN_GRP
CSI_PROCESS_TXN_PVT
CSI_RMA_RECEIPT_PUB


The two compilation errors that stand out are:

PL/SQL: ORA-00904: "CSI_UTL_PKG"."GET_LOT_CTRL_CODE": invalid identifier

 

CSI_PROCESS_TXN_GRP: PLS-00306: wrong number or types of arguments in call to 'GET_ITEM_ATTRIBUTES'

 

Changes

Applied Patch 7836468

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