Item UPCS Are Deleted In POSIDENTITY Table When RMS Sends DEL For Any One UPC (Doc ID 1392212.1)

Last updated on MAY 02, 2017

Applies to:

Oracle Retail Back Office - Version 13.0 to 13.3 [Release 13.0 to 13.3]
Oracle Retail Merchandising System - Version 13.0 to 13.2 [Release 13.0 to 13.2]
Information in this document applies to any platform.

Symptoms

When Retail Merchandising System ( RMS) deletes a barcode associated with an item , Backoffice (BO) deletes all the other barcodes as well from the POS Identity table.

Steps to Reproduce :

1.Item A has 3 barcodes in RMS. For example , Item 900000041 has barcodes 900000041  and 5000253161997 associated to it  .
2. If one of the barcodes ,  is sent with delete status from RMS , BO deletes the other barcodes associated with the item.

In the ItemExport.xml below , Item 900000041 has an associated barcode 5000253161997  which has been deleted in RMS .

<Item
ChangeType="UPD"
ID="900000041"
Type="Stock"
ItemCost="3.88"
Taxable="true"
POSDepartmentID="164"
Size=""
Color=""
RegistryEligible="true"
SizeRequired="false"
AuthorizedForSale="true"
SerializedItem="false"
Discountable="true"
DamageDiscountable="true"
UOMCode="UN"> <ShortName>SAMPLE Avalon 411</ShortName>
<LongDescription>SAMPLE Avalon 411</LongDescription>
<RetailStoreItem
ChangeType="UPD">
<RetailStoreID>04241</RetailStoreID>
<POSIdentity ChangeType="DEL" POSItemID="5000253161997"/>
</RetailStoreItem>
</Item>

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