My Oracle Support Banner

VAT Item Maintenance Form Fails with Error: "VAT Rate with This Date Already Exists" (Doc ID 1920924.1)

Last updated on MARCH 19, 2019

Applies to:

Oracle Retail Merchandising System - Version 13.1.3 to 13.1.9 [Release 13.1]
Information in this document applies to any platform.


In Oracle Retail Merchandising System (RMS) 13.1.x, the Value Added Tax (VAT) Item Maintenance form fails with the following error:

Steps to Reproduce:

  1. Add records (record count up to 14 for a particular VAT region) in the 'VAT Item Maintenance' screen.  Ensure unique value# item, VAT region, VAT type, and active date.
  2. Note that you will face no issue unless and until the record count is 14.
  3. Add a 15th record on this screen and press OK for the same VAT region.
  4. Open the item in 'Edit' mode and click the screen 'VAT Item Maintenance'.  
  5. Fetch the records by selecting the 'VAT Region'.  Once here, if you scroll down (using the scrollbar) or press any button except 'Cancel' you will receive the error “VAT rate with this date already exists”.


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.