My Oracle Support Banner

JGZZVACF: Error Attempting to Create New Tax Registration Number: FRM-41830 List of Values contains no entries (Doc ID 1078763.1)

Last updated on JANUARY 25, 2023

Applies to:

Oracle Financials for EMEA - Version 12.1.1 to 12.1.1 [Release 12.1]
Information in this document applies to any platform.
Form:JGZZVACF.FMB - EMEA VAT Reporting Entity Setup


When attempting to create a new Tax Registration Number, the following error occurs.

FRM-41830: List of Values contains no entries

FRM-40212: Invalid value for field TAX_REGISTRATION_NUMBER


The issue can be reproduced at will with the following steps:

1. Responsibility: Oracle Payables - upgraded from 11.5 to R12 > The upgrade has associated the EMEA Reporting Entities from with the Payables VAT Registration Number, the Legal Entity and the old tax regime.
Created a new Tax Regime as the upgraded one did not work correctly.

2. Path: EMEA VAT Reporting Entities Setup - Select the Allocation Rules
Can not enter a new EMEA Reporting Entity set of Allocation codes for Belgium because the localization form does not allow to create a new record. The upgrade has linked the LE and VAT Reg to the Old Tax Regime.

3. It is necessary to enter a new set of allocation rules in the Belgium AP Localization form to link the Legal Entity / AP VAT Reg to the new tax regime.
Field Name - Tax Registration Number
Query back the old Regime and migrated allocation rules, try to insert a new record to see if the new tax regime, tax rates exist. 

4. The error shows


 Upgraded from 11.5 to R12


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.