Party Merge Completes with Error - Merge Failed In Procedure ZX_PARTY_MERGE_PKG.ZX_MERGE For Entity ZX_PARTY_TAX_PROFILE (Doc ID 2028279.1)

Last updated on OCTOBER 21, 2016

Applies to:

Oracle Trading Community - Version 12.1.3 and later
Information in this document applies to any platform.

Symptoms

On : 12.1.3 version, Data Quality Management

You are attempting to use Party Merge and it completes with the following error:

**** Error ****
Error: Merge failed in procedure ZX_PARTY_MERGE_PKG.ZX_MERGE for entity ZX_PARTY_TAX_PROFILE

Example:
Party Merge Routine for Merging Location Owners
  595034 : Transferred OWNER_PARTY_ID from 1351234 to 2153342
  
  Bulk merge completed. Transferred PARTY_ID from 1351234 to 2153342 Party Usage
  "CUSTOMER" (ID:790065) : Transferred PARTY_ID from 1351234 to 2153342
  Merge eBTax party tax profile and party tax profile's child entities
  Bulk merge completed. Transferred PARTY_ID from 1351234 to 2153342

Patches have been applied
Patch 14493964:R12.HZ.B
Patch 17977385:R12.ZX.B

SELF_ASSESS_FLAG is set to "N"

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms