Party Merge Failing In Procedure Zx_party_merge_pkg.Merge_ptp_sites For Entity Zx_party_tax_profile

(Doc ID 1361487.1)

Last updated on AUGUST 09, 2016

Applies to:

Oracle E-Business Tax - Version 12 and later
Information in this document applies to any platform.


Party Merge process fails when calling package ZX_PARTY_MERGE_PKG.MERGE_PTP_SITES for the ZX_PARTY_TAX_PROFILE table.

Log file shows the following:

Parent_Entity_Name : HZ_PARTY_SITES
Batch_Id : XXXXX
Batch_Party_Id : XXXX
Error : From Party Info not available for Party-Id XXXXXX and Party-Type THIRD_PARTY_SITE
Incorrect status retuned by Merge_Party_Sites_PTP_Pvt()
Return Status = E
Bulk merge completed. Transferred PARTY_ID from XXXXX to XXXXX
**** Error ****
Error: Merge failed in procedure ZX_PARTY_MERGE_PKG.MERGE_PTP_SITES for entity ZX_PARTY_TAX_PROFILE
Error executing procedure ZX_PARTY_MERGE_PKG.MERGE_PTP_SITES for entity HZ_PARTY_SITES
.... One or more of the Merges in the batch had errors.
.... Please check the log file
.... No changes from the batch have been applied
Concurrent Program Execution completed


Customer had applied  Patch 10430488:R12.ZX.B ERROR COMPLETING PARTY MERGE


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