My Oracle Support Banner

CSI_II_RELATIONSHIPS_PUB API Error: ORA-01403: no data found in Package CSI_ITEM_INSTANCE_PVT Procedure UPDATE_ITEM_INSTANCE (Doc ID 423467.1)

Last updated on MARCH 01, 2021

Applies to:

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

Symptoms

When calling API CSI_II_RELATIONSHIPS_PUB.CREATE_RELATIONSHIP to create instance to instance relationship, the procedure is erroring out and no relationship is getting created.

Error in Log file:
Error from CSI_II_RELATIONSHIPS_PVT.CREATE_RELATIONSHIP
Call to update_instance has errored ....
MESSAGE DATA = ORA-06502: PL/SQL: numeric or value error
ORA-01403: no data found in Package CSI_ITEM_INSTANCE_PVT Procedure UPDATE_ITEM_INSTANCE
Error from Create_relationship PVT..
MESSAGE DATA = ORA-06502: PL/SQL: numeric or value error
ORA-01403: no data found in Package CSI_ITEM_INSTANCE_PVT Procedure UPDATE_ITEM_INSTANCE
Error from Create_relationship PVT..
MESSAGE DATA = Instance validation failed (instance_id=xxxxxxxx)

Changes

 

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!

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