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
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.
On : 12.1.3 version, Tax Set Up
Attempting to run the European Sales Listing (ZXXEUSL) and receive the following 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.
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