My Oracle Support Banner

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 AUGUST 14, 2020

Applies to:

Oracle Fusion Tax Cloud Service - Version 11.13.19.01.0 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


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