My Oracle Support Banner

Party Merge Fails in E-Business Tax Due to Overlapping Exemption Error - Error : All Exemptions from xxxxx123 Cannot Be Merged onto xxxxxx456 as Overlapping Exemptions Will Be Created (Doc ID 1930029.1)

Last updated on JANUARY 19, 2021

Applies to:

Oracle E-Business Tax - Version 12.1.3 to 12.1.3 [Release 12.1]
Oracle Receivables - Version 12.1.3 and later
Information in this document applies to any platform.


On : 12.1.3 version, Receivables Uptake of EBTAX

Attempting to perform a Party Merge and it fails in E-Business Tax due to overlapping exemption error:

Create Party Merge Batch Party_ID 23094 and transfer its sites into Party_ID 23100. The preview batch process completes with warning with the following log error:
Error: Merge failed in procedure ZX_PARTY_MERGE_PKG.ZX_MERGE for entity ZX_PARTY_TAX_PROFILE
This unexpected SQL error occurred during the merge process :
Error : All exemptions from ptp 843958 cannot be merged onto ptp 843996 as overlapping exemptions will be created
.... One or more of the Merges in the batch had errors.
.... Please check the log file
.... No changes from the batch have been applied

No additional information is available in the log file.
 ptp 843958 pertains to party_id 23094 and ptp 843996 pertains to party_ID 23100.

Due to this issue, users cannot merge Parties in production.


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

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