My Oracle Support Banner

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

Last updated on JUNE 17, 2021

Applies to:

Oracle Trading Community - Version 11.5.10 to [Release 11.5]
Information in this document applies to any platform.


  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
    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 ............




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
 1. Bug Summary
 2. Fixed Files
 3. Recommended Patches
 4. Solution Steps

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