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

Last updated on APRIL 06, 2017

Applies to:

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

Symptoms

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.

Changes

 

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms