My Oracle Support Banner

Item Approved Without Having Cost/Retail For a VAT_REGION and Item Not Scanning In Downstream Systems (Doc ID 2527215.1)

Last updated on DECEMBER 04, 2019

Applies to:

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

Symptoms

While approving the item,system is not ensuring that it should have either B(BOTH) or both C(COST) and R(RETAIL) for all VAT_REGION on a given date .

items are not ringing stores,as there is no retail VAT flown to downstream systems . 

Need to ensure that an item is only approved in Oracle Retail Merchandising System(RMS).when there is a B or both (C,R) VAT present in VAT_ITEM table for all VAT_REGION for an item at any given point of time.

Even for an approved item, if tries to change VAT by any processes in RMS,We need to ensure there is either B or both C,R exists for an item in VAT_ITEM for all the regions at any given point of time.

This validation check should ensure in all processes in RMS through which we can change VAT :

  1. Item Induction.
  2. Quick Item ADD.
  3. Creation through screen.
  4. Item List Use


Expected behavior is that there must be a validation check in item approval item should be approved in RMS when there is a B or both (C,R) VAT present in VAT_ITEM table for all VAT_REGION for an item at any given point of time.

 Steps to reproduce :

  1. Create item.
  2. Before approval delete retail vat from vat maintenance screen.
  3. Approve the item.

 

Changes

 

Cause

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
Symptoms
Changes
Cause
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.