You have encountered an unexpected error Error During A Merge Mapping (Doc ID 815011.1)

Last updated on JUNE 17, 2021

Applies to:

Symptoms

1. Log onto OCO and click on Customers tab
2. Search Persons with name "John XXXX"
   Two parties were returned
3. Press Mark Duplicates button
4. Click the check boxes in the Select column (or click on the Select All hyperlink), then ClicK the Continue button
5. Select the primary record by clicking the radio button in the Select column (in this case, it's John XXXX with Registry ID 101657), then Click on the Finish button
   You will get a Confirmation message
   Now you need to wait for the merge request job to complete
6. Go to Data Quality tab
7. You will see Merge request name = John XXXX
8. Check off the box in the Select column for the merge request, click on the Assign button
9. In the Assignee field drop down list box, select your logon
   Click on the Apply butto
   You will be returned to the Merge Requests screen and your merge will be assigned to you
10. Click on the icon in the Map column
11. Click on the Relationships hyperlink
    You see:
    Relationship Role Relationship Type Inintial relationships Final
    Relationships
    Clients of BROKER/Consultant
    6 6
    Employers Employment
    2 2
12. Click on the radio button besides "Employers"
13. Click on Resolve Duplicates Button
14. Click on the Return to Overview hyperlink (at the bottom of the page),
    You are returned to the Relationship page
15. Click on Back button
16. You are returned to the Addresses page, but you get an Error
    
    You have encountered an unexpected error. Please contact the System Administrator for assistance Click here for exception details
    
    The exception Details shows:.
    
    oracle.apps.fnd.framework.OAException: oracle.jbo.SQLStmtException:
    JBO-27122: SQL error during statement preparation. Statement:
    SELECT * FROM (select distinct ....
    from hz_merge_parties p, hz_relationships r, hz_relationship_type rt, hz_code_assignments code
    where p.batch_id = :1 and ............

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.