European Sales Listing (ZXXEUSL) Completes with Error - The value DEXXXXXXXX for Value Set ZX_TRL_FIRST_PTY_VAT_REG_NUM Occurs in More Than One Row in Column TAX_REGISTRATION_NUMBER of Table ZX_TRL_ESL_VAT_NO_V and Duplicate Values Are Not Allowed (Doc ID 1947283.1)

Last updated on OCTOBER 21, 2016

Applies to:

Oracle E-Business Tax - Version 12.1.3 and later
Information in this document applies to any platform.

Symptoms

On : 12.1.3 version, Tax Set Up

Attempting to run the European Sales Listing (ZXXEUSL) and receive the following error:

ERROR
-----------------------
Trader VAT No. - The value DEXXXXXXXX for value set ZX_TRL_FIRST_PTY_VAT_REG_NUM occurs in more than one row in column TAX_REGISTRATION_NUMBER of table ZX_TRL_ESL_VAT_NO_V and duplicate values are not allowed. Please choose a different value or contact your system administrator.

Steps to Reproduce:
Responsibility:  Tax Manager 
Navigation:  Default and Controls > Tax Reporting Types

You have defined HZ_GEOGRAPHIES where GEOGRAPHY_CODE = 'DE'

The report parameter for legal entity is returning two values, because there are two codes for ‘DE’  in HZ_GEOGRAPHIES and FND_TERRITORIES (one is Germany and the other is Delaware).

If you run the same report from Requests > Run, no error is returned.

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