ARHPMERGE:Party Merge Raises Error - Exact Fetch Returns More Than Requested Number Of Rows (Doc ID 2122752.1)

Last updated on JUNE 06, 2017

Applies to:

Oracle Trading Community - Version 12.1.0 to 12.2.5 [Release 12.1 to 12.2]
Information in this document applies to any platform.

Symptoms

Party merge fails. Log file and output report have errors: Party Merge Raises error - exact fetch returns more than requested number of rows

ERROR
-----------------------
LOG file error:
error is raised: 'do_merge ORA-01422: exact fetch returns more than requested number of rows'.
The log file of the merge is attached.
A Party Merge batch was created and submitted. The concurrent process completed normally but the merge itself was not completed.
The log file indicates an error such as follows:
This unexpected SQL error occurred during the merge process :
-
do_merge ORA-01422: exact fetch returns more than requested number of rows
Error Entity Name:
Error FK Column:
.... One or more of the Merges in the batch had errors.
.... Please check the log file
.... No changes from the batch have been applied
-

BUSINESS IMPACT
-----------------------
The issue has the following business impact:
Due to this issue, the batch party merge does not complete

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