Export_Itemvat.ksh Batch Is Not Updating Correctly Records
(Doc ID 2705315.1)
Last updated on AUGUST 19, 2021
Applies to:Oracle Retail Merchandising System - Version 16.0.2 and later
Information in this document applies to any platform.
Updating active date of vat code, for the style item, an additional 'vatitemmod' message is created for a different vat code.
For the sku item, a 'vatitemcre' message is created instead of 'vatitemmod' message and an additional 'vatitemmod' message is created for a different vat code as well.
'Export_itemvat.ksh' batch should update records properly.
The issue can be reproduced with the following steps:
- Via UI(user interface), update the active date of an item's vat code that is not yet active.
- Click Save then Yes to the popup "Do you want to overwrite children information with the parent's".
- Check VAT_ITEM table records. Notice that the old date for the item children was not deleted.
- Check ITEM_EXPORT_STG table records.
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