EGO_PEOPLE_V View Fetch Returns More Than Requested Number Of Rows (Doc ID 2132202.1)

Last updated on APRIL 28, 2016

Applies to:

Oracle Product Hub - Version 12.2.4 and later
Information in this document applies to any platform.

Symptoms

On : 12.2.4 version, Catalog items

Find an issue with standard API EGO_CHANGE_USER_ATTRS_PUB.Process_Change_User_Attrs.

For some users, when calling the API ends in error : "Unexpected error in EGO_CHANGE_USER_ATTRS_PUB.Process_Change_User_Attrs: ORA-01422: exact fetch returns more than requested number of rows. Entity: CHANGE_USER_ATTRS_ENTITY_CODE".

The following query returns too many rows:

SELECT 'HZ_PARTY:'||TO_CHAR(PERSON_ID)
INTO G_HZ_PARTY_ID
FROM EGO_PEOPLE_V
WHERE USER_NAME = G_USER_NAME;

When there is multiple records for the same person in the HZ_RELATIONSHIPS table, the EGO_PEOPLE_V table returns too many rows/duplicate rows.

Error
 EGO_CHANGE_USER_ATTRS_PUB.Process_Change_User_Attrs: ORA-01422: exact fetch returns more than requested number of rows. Entity: CHANGE_USER_ATTRS_ENTITY_CODE".


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