Tax Configuration Content Upload Ends In Error: ORA-00001: Unique Constraint (FUSION.ZX_PARTY_TAX_PROFILE_U2) Violated
(Doc ID 2531059.1)
Last updated on MARCH 13, 2025
Applies to:
Oracle Fusion Tax Cloud Service - Version N/A and laterOracle Fusion Tax - Version 11.1.1.5.1 and later
Information in this document applies to any platform.
Symptoms
When importing multiple tax registrations details for a party using the Tax Implementation Workbook, the program called "Tax Configuration Content Upload" ends in error for some parties, but it works for other parties.
ERROR
-----------------------
Unexpected Error in INSERT_PTP_RECORDS: ORA-00001: unique constraint (FUSION.ZX_PARTY_TAX_PROFILE_U2) violated
Call ZX_REGISTRATION_VALIDATION_PKG.validate_trn
After calling ZX_REGISTRATION_VALIDATION_PKG.validate_trn: S
Unexpected Error in IMPORT_WRAPPER: ORA-0000: normal, successful completion
Unexpected error during Data validation, Please review output/log file for detailed report.
Return status: 2
STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Fill in two tax registration lines for party number "XXXX"
2. upload the spreadsheet
3. the process ends in error
Cause
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
| Symptoms |
| Cause |
| Solution |
| References |