ARHPMERGE:Party Merge Raises Error - Exact Fetch Returns More Than Requested Number Of Rows
(Doc ID 2122752.1)
Last updated on FEBRUARY 03, 2019
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.
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
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!