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 FEBRUARY 10, 2017

Applies to:

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

Symptoms

On : 12.1.3 version, Receivables Uptake of EBTAX

ACTUAL BEHAVIOR
---------------
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.

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