ORA-01422: exact fetch returns more than requested number of rows in Package CSI_PARTY_RELATIONSHIPS_PVT Procedure CREATE_INST_PARTY_RELATIONSHIP (Doc ID 2050923.1)

Last updated on MARCH 08, 2017

Applies to:

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

Symptoms

Error when adding party association to an instance via the Install Base UI the following error occurs:

ORA-01422: exact fetch returns more than requested number of rows in Package CSI_PARTY_RELATIONSHIPS_PVT Procedure CREATE_INST_PARTY_RELATIONSHIP

Steps to Reproduce
The issue can be reproduced at will with the following steps:
1. Assign a contact to the address book on supplier in Payables which has multiple Sites
2. Assign this vendor contact to install base using the Associations tab
3. Multiple rows displayed for only one Contact attached to a Vendor source in Associations tab
4. Attempting to update one of the contacts rows displayed results in ORA-01422 error

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