'ItemExport.xml' When Imported into Stores Database to Update an Existing Item Creates Price Change Event (Doc ID 1459287.1)

Last updated on JUNE 23, 2016

Applies to:

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

Symptoms

When there is a price change event from Retail Price Management (RPM), and at the same time a change to an existing item in Retail Merchandising System (RMS), and the 'ItemExport' and the 'PricingExtract' are imported into Back Office, a new price change event gets created apart from the price changes sent from RPM.  This causes the item's price to ring up incorrectly in Point of Service (POS).


Sample Steps to Reproduce:

1. Add item 100054575 to Back Office, and scan in POS (item price is $658.00).
2. Import the next bundle with the ItemExport.xml and PricingExport.xml as follows:

  <ItemImport
    Priority="0"    FillType="DeltaIncremental"    Version="1.0"    Batch="1"
    CreationDate="2012-05-14T20:48:28.0Z">
    <Item
       ChangeType="UPS"
       ID="100054575"
       Type="Stock"
       ItemCost="276.45"
       Taxable="false"
       POSDepartmentID="29"
       Size=""
       Color=""
       RegistryEligible="true"
       SizeRequired="false"
       AuthorizedForSale="true"
       SerializedItem="false"
       Discountable="true"
       DamageDiscountable="true"
       UOMCode="UN">
       <ShortName>Mora Gold blanket double</ShortName>
       <LongDescription>Mora Gold blanket double</LongDescription>
       <MerchandiseHierarchy>5:002901420456</MerchandiseHierarchy>
       <RetailStoreItem
          VatCode=""
          ChangeType="UPS"
          AgeRestrictionId="0">
          <RetailStoreID>09001</RetailStoreID>
          <RegularPrice
           CurrencyCode="USD"
           IncludesTax="false">658</RegularPrice>
          <POSIdentity
             ChangeType="UPS"
             POSItemID="1234560016044"
             SupplierID="296"
             MinimumSaleUnitCount="1"
             QuantityModifiable="Optional"
             PriceEntryRequired="false"
             PriceModifiable="true"
             SpecialOrderEligible="false"
             Returnable="true"
             EmployeeDiscountAllowed="true"/>
       </RetailStoreItem>
    </Item>
  </ItemImport>

 
  <?xml version="1.0" encoding="UTF-8" ?>
  <PricingImport Priority="0" FillType="FullIncremental" Version="1.0"
  Batch="1" CreationDate="2012-05-14T20:45:46.0Z"
  xsi:noNamespaceSchemaLocation="PricingImport.xsd"
  <PriceChange ChangeType="ADD" ID="117082" StartDate="2012-05-06" TemplateType="Default">
     <Item ID="100054575" TemplateType="Default">
     <Price>658</Price>
  </Item>
  </PriceChange>
  <PriceChange ChangeType="ADD" ID="117132" StartDate="2012-05-09"
  TemplateType="Default">
  <Item ID="100054575" TemplateType="Default">
  <Price>340</Price>
  </Item>
  </PriceChange>
  </PricingImport>


  3. Scan item 100054575 in POS.  Note that item still rings up as 658.00, having disregarded price change.

 

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