You have encountered an unexpected error Error During A Merge Mapping
(Doc ID 815011.1)
Last updated on JUNE 17, 2021
Oracle Trading Community - Version 11.5.10 to 22.214.171.124 [Release 11.5] Information in this document applies to any platform.
Log onto OCO and click on Customers tab
Search Persons with name "John XXXX" Two parties were returned
Press Mark Duplicates button
Click the check boxes in the Select column (or click on the Select All hyperlink), then ClicK the Continue button
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
Go to Data Quality tab
You will see Merge request name = John XXXX
Check off the box in the Select column for the merge request, click on the Assign button
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
Click on the icon in the Map column
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
Click on the radio button besides "Employers"
Click on Resolve Duplicates Button
Click on the Return to Overview hyperlink (at the bottom of the page), You are returned to the Relationship page
Click on Back button
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!