My Oracle Support Banner

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 JUNE 04, 2019

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.

Symptoms

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

or the same error happens during update item instance from UI

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

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Symptoms
Changes
Cause
Solution
 Community Discussions
References

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.