My Oracle Support Banner

VAT_ITEM Table Is Populated for Items Under Transaction Level but Not Populated for Packs (Doc ID 2062473.1)

Last updated on FEBRUARY 26, 2019

Applies to:

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


In Oracle Retail Merchandising System (RMS), the VAT_ITEM table is populated for items below Transaction level, but is not populated for packs when a new Value Added Tax (VAT) region is added on the VAT Dept Maintenance form.

Steps to Reproduce:

  1. Create new VAT region, new vat codes, and new VAT code rate.
  2. Open the Dept Maintenance form for a department and attach the newly created VAT region, VAT code, VAT rate code.
  3. Validate VAT_ITEM for all the items of that dept and newly created VAT region.

Actual Result: It is inserting data in VAT_ITEM  for item level 3 and tran level 2, but not inserting record for pack items.
Expected Result: It should not insert data in VAT_ITEM for item level 3 and tran level 2, but should insert record for pack items.


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.