ORA-01403: no data found error when creating item instance in Install Base (Doc ID 2254137.1)

Last updated on APRIL 13, 2017

Applies to:

Oracle Installed Base - Version 12.1.3 and later
Information in this document applies to any platform.

Symptoms

When attempting to create item instance in Install base for a party+party site combination users are getting the below error

ERROR
-----------------------
ORA-01403: no data found in Package CSI_ITEM_INSTANCE_PVT Procedure CREATE_ITEM_INSTANCE_PVT

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Go to Install Base Agent User
2. Select Create an Item instance
3. Create an item instance
Due to this issue, users cannot create an Item instance and put the item in customer's location

Changes

 

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