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.

Symptoms


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
Merge_Party_Sites_PTP_Pvt(+)
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
Merge_PTP_Sites(-)
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

Changes

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

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