Resubmitting Transaction Error Results In ORA-06508: PL/SQL: could not find program unit being called in Package CSI_ITEM_INSTANCE_PUB Procedure GET_ITEM_INSTANCES (Doc ID 563333.1)

Last updated on MAY 19, 2017

Applies to:

Oracle Installed Base - Version 11.5.9 to 12.2 [Release 11.5 to 12.2]
Information in this document applies to any platform.
***Checked for relevance on 28-Apr-2016***

Symptoms

After applying a patch, you try to reprocess errors in the Transactions Error Processing form and receive the following message: 

ERROR
ORA-06508: PL/SQL: could not find program unit being called in Package CSI_ITEM_INSTANCE_PUB Procedure GET_ITEM_INSTANCES

Steps to Reproduce:

Oracle Installed Base Admin >> Transaction Errors Processing

1. Select the failing transactions that will be processed
2. Save the selected records
3. View >> Requests >> Submit a New Request >> Single Request >> Resubmit Interface Process
4. Parameter -- Selected >> Submit
5. When Concurrent Process is Complete, the selected transactions will have the error: ORA-06508: PL/SQL: could not find program unit being called in Package CSI_ITEM_INSTANCE_PUB Procedure GET_ITEM_INSTANCES

Changes

NOTE:  This issue can occur after applying any CSI (install Base), CSE (Asset Tracking), OKC and OKS (Contracts) patch.   Less common are patches for INV (inventory), ONT (Order Management), FS (Field Service), DR (Depot Report).  The package shown, 'CSI_ITEM_INSTANCE_PUB', is just an example.

 

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