UPC Delete on ItemExport Is Not Removing Data from AS_ITM_META_TAG Table
(Doc ID 2115785.1)
Last updated on JANUARY 19, 2018
Applies to:
Oracle Retail Back Office - Version 14.0 and laterInformation 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>
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>
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
To view full details, sign in with your My Oracle Support account. |
|
Don't have a My Oracle Support account? Click to get started! |