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 MAY 21, 2021

Applies to:

Oracle Fusion Tax Cloud Service - Version N/A and later
Information in this document applies to any platform.


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.

Unexpected Error in INSERT_PTP_RECORDS: ORA-00001: unique constraint (FUSION.ZX_PARTY_TAX_PROFILE_U2) violated
  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

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


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.