Account Merge Errors With ORA-01422: exact fetch returns more than requested number of rows (Doc ID 2782248.1)

Last updated on OCTOBER 13, 2022

Applies to:

Symptoms

Version 12.1.3, Account merge (RAXMRG) errors when merging accounts that are owned by the same customer. (party)

When the accounts to be merged belong to the same customer,  the 'create same' selection box can not be chosen as the party sites are the same sites for both accounts.
The 'create same' site checkbox is to cause the system to simply copy the address to the new customer.  This can not be done when the accounts belong to the same customer as the party sites are the same for both accounts.

If the TO account does not have an address that the FROM account has assigned to the org_id and the 'create same' checkbox is marked , the following error will occur:
The error will be shown on the output report and the log file.

ERROR
-----------------------
 ORA-01422: exact fetch returns more than requested number of rows.          

STEPS
-----------------------
The issue can be reproduced using the following steps:   Using the navigation Customers: Customer Merge
1. Complete the account merge form ARXCUMRG.     When the account numbers are entered notice that the name is identical for both accounts.   The name is displayed from the party record.  (HZ_PARTIES.party_name)
2. Map the addresses found on the FROM account to addresses found in the listing (LOV) of addresses for the TO account.
3. Once all FROM addresses are mapped to the TO account, save the form.
4. If there is an address for the FROM account not found on the TO account , use the create same checkbox.  Since the accounts belong to the same customer.  The error will occur.
5. Submit the merge. The concurrent request RAXMRG will be submitted.
6. Once the merge completes, review the log file and output report.     The log file and report should be reviewed every time a merge occurs as the concurrent request can report complete when there are errors. 

Changes

Cause

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.