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 JULY 11, 2018
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.
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!