Taxware Data File TMD2 Failing With Error 'ORA-00001: unique constraint (AR.HZ_GEOGRAPHY_RANGES_U1) violated' (Doc ID 2093272.1)

Last updated on JANUARY 04, 2016

Applies to:

Oracle E-Business Tax - Version 12 to 12.2 [Release 12.0 to 12.2]
Information in this document applies to any platform.

Symptoms

On : Release 12 Version, Tax Set Up

Taxware Data File TMD2 Failing With Error 'ORA-00001: unique constraint (AR.HZ_GEOGRAPHY_RANGES_U1) violated'


The E-Business Tax Content Upload Sql Loader Program error with below message:

Creating Tax Zones.
Records Inserted: xxxxx
Creating Tax Accounts for Tax Jurisdictions.
Records Inserted: 0
Creating TL for Tax Jurisdictions.
Records Inserted: 3052
Unexpected Error create_tax_zones: ORA-00001: unique constraint (AR.HZ_GEOGRAPHY_RANGES_U1) violated

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