My Oracle Support Banner

Wrong Active_date in VAT_ITEM Table if User Creates Item Using New From Existing Option (Doc ID 2650187.1)

Last updated on SEPTEMBER 07, 2022

Applies to:

Oracle Retail Merchandising System - Version 15.0.1 and later
Information in this document applies to any platform.


Wrong Aative_date in VAT_ITEM Table if user creates item using 'New From Existing' option.

Steps to Recreate:

  1.  Created an item with last year, Vdate was 14-03-18.
  2.  Item was available in system from 14-03-18. First Active_date in VAT_ITEM : 14-03-18.
  3. Now, after a year, when the Vdate is 16-02-19 - create a new item with "New from Existing" in RMS.
  4. Item is available in system from 16-02-19. But the Active_date in VAT_ITEM table is reflected as 14-03-18.



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.