UPC Delete on ItemExport Is Not Removing Data from AS_ITM_META_TAG Table (Doc ID 2115785.1)

Last updated on MARCH 16, 2016

Applies to:

Oracle Retail Back Office - Version 14.0 and later
Information in this document applies to any platform.

Symptoms

In Oracle Retail Back Office (ORBO), while importing an Item Export file, UPC Delete does not remove data from the AS_ITM_META_TAG table.


Steps to Reproduce:


1. Import an ItemExport file similar to the below example into Back Office through data import (DIMP).

<Item
ChangeType="UPS"
ID="000009912"
Type="Stock"
ItemCost="19.65"
Taxable="true"
POSDepartmentID="100"
Size=""
Color=""
RegistryEligible="true"
SizeRequired="false"
AuthorizedForSale="true"
SerializedItem="false"
Discountable="true"
DamageDiscountable="true"
UOMCode="UN"
Classification10="null"
Classification9="12.7 FZ">
<ShortName>Short Name</ShortName>
<LongDescription>Long Description
</LongDescription>
<MerchandiseHierarchy>5:010017001701</MerchandiseHierarchy>
<RetailStoreItem
VatCode=""
ChangeType="UPS"
AgeRestrictionId="0">
<RetailStoreID>04241</RetailStoreID>
<RegularPrice
CurrencyCode="USD"
IncludesTax="true">31.99</RegularPrice>
<POSIdentity
ChangeType="UPS"
POSItemID="0812066020547"
SupplierID="1005409"
MinimumSaleUnitCount="1"
QuantityModifiable="Optional"
PriceEntryRequired="false"
PriceModifiable="true"
SpecialOrderEligible="false"
Returnable="true"
ManufacturerFamilyCode=""
EmployeeDiscountAllowed="true"/>
</RetailStoreItem>
</Item>


2. Import ItemExport that contains UPC Delete, similar to the below:

<Item
ChangeType="UPS"
ID="000009912"
Type="Stock"
ItemCost="19.65"
Taxable="true"
POSDepartmentID="100"
Size=""
Color=""
RegistryEligible="true"
SizeRequired="false"
AuthorizedForSale="true"
SerializedItem="false"
Discountable="true"
DamageDiscountable="true"
UOMCode="UN"
Classification10="null"
Classification9="12.7 FZ">
<ShortName>Short Name</ShortName>
<LongDescription>Long Description
</LongDescription>
<MerchandiseHierarchy>5:010017001701</MerchandiseHierarchy>
<RetailStoreItem
ChangeType="UPD">
<RetailStoreID>04241</RetailStoreID>
<POSIdentity ChangeType="DEL" POSItemID="0812066020547"/>
</RetailStoreItem>
</Item>


3. Check AS_ITM_META_TAG and ID_IDN_PS tables.

4. Note that ID_IDN_PS has 0 rows, but AS_ITM_META_TAG still contains all 8 rows for item 000009912.

The UPC for Item 000009912 (0812066020547) is not removed from AS_ITM_META_TAG after processing UPC Delete extract.

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