EGO Setup Default Organization for User Program Ends With ORA-01422 Error
(Doc ID 1086410.1)
Last updated on FEBRUARY 19, 2019
Applies to:Oracle Product Hub - Version 188.8.131.52 and later
Information in this document applies to any platform.
The program 'EGO Setup Default Organization for User' (EGOPRTYSTUP) ends with the below error message. This occurs when multiple records corresponding to the default enterprise organization are present in HZ_PARTIES. Have two records for this organization in the TCA, one active and one inactive.
It looks like this organization is created as part of the upgrade - the creation date on the two records corresponds to upgrade dates (R10 -> R11 and R11 -> R12).
EXCEPTION in getting default enterprise with error
ORA-01422: exact fetch returns more than requested number of rows
See that there are more than one records returned from the following query:
FROM hz_parties hp, hz_code_assignments hca
WHERE hca.owner_table_id = hp.party_id
AND hca.owner_table_name = 'HZ_PARTIES'
AND hca.class_category = 'POS_PARTICIPANT_TYPE'
AND hca.class_code = 'ENTERPRISE'
Log in as a user that has access to the Development Manager responsibility.
Switch to development manager.
Run EGO Setup Default Organization for Use concurrent program.
The program ends in error.
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