Creating Bank Account at Customer Account Level Errors ORA-01422: Exact Fetch Returns More Than Requested Number of Rows (Doc ID 1573039.1)

Last updated on FEBRUARY 23, 2015

Applies to:

Oracle Trading Community - Version 12.1.3 and later
Information in this document applies to any platform.

Symptoms

Creating bank account at customer account gets the following error:

validate_party (-)
HZ_PARTIES_PKG.Insert_Row (+)
HZ_PARTIES_PKG.Insert_Row (-) x_party_id = 3564022
do_create_party (-)
HZ_RELATIONSHIPS_PKG.Insert_Row-1 (+)
HZ_RELATIONSHIPS_PKG.Insert_Row-1 (-) x_relationship_id = 1607174
HZ_RELATIONSHIPS_PKG.Insert_Row-2 (+)
HZ_RELATIONSHIPS_PKG.Insert_Row-2 (-) x_relationship_id = 1607174
"SQL ERROR-The following SQL error occurred:
ORA-01422: exact fetch returns more than requested number of rows."
create_relationship (-)
"ERROR-The following SQL error occurred:
ORA-01422: exact fetch returns more than requested number of rows."
create_bank_branch (-)
"OAF LOG: Event : Check Errors, in:
oracle.apps.fnd.framework.webui.OAPageErrorHandler: Exception: The following
SQL error occurred:
ORA-01422: exact fetch returns more than requested number of rows. ,In VO:
BranchInfoPLSQLVO"

select * from dba_source where name in ('HZ_RELATIONSHIPS_PKG')
/*$Header: ARHRELTS.pls 120.2 2005/10/30 03:54:49 appldev noship $ */
/*$Header: ARHRELTB.pls 120.4 2005/10/30 03:54:47 appldev noship $ */

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