My Oracle Support Banner

Party Merge Concurrent Program is Failing with ORA-01403 and ORA-06502 Errors (Doc ID 1116645.1)

Last updated on MAY 18, 2020

Applies to:

Oracle Installed Base - Version 12.0.4 and later
Information in this document applies to any platform.
Concurrent Program: ARHPMERGE - Party Merge

Symptoms

Run Party Merge Concurrent Program in Oracle Receivables.  Log file shows the following error:

for table : CSI_ITEM_INSTANCES Data exists in table for the merge-to party. Aborting merge

Error: Merge failed in procedure CSI_PARTY_MERGE_PKG.CSI_ITEM_INSTANCES_MERGE for entity CSI_ITEM_INSTANCES
This unexpected SQL error occurred during the merge process :

ORA-06502: PL/SQL: numeric or value error
ORA-01403: no data found


Steps to Reproduce:

(R) Trading Community Manager Responsibility: (N) Data Quality Manager > Party Merge
1. Enter a name for the batch, then enter parties to merge
2. Enter the merge options like Merge
3. Save
4. Click on run batch button
5. Concurrent request is submitted
6. Concurrent request is finished with error.

Cause

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
Symptoms
Cause
Solution
References


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