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
Run Party Merge Concurrent Program in Oracle Receivables. Log file shows the following error:
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
4. Click on run batch button
5. Concurrent request is submitted
6. Concurrent request is finished with error.
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