My Oracle Support Banner

Data Import with Changetype "DEL" Does Not Delete Duplicate Price Change Events (Doc ID 2198952.1)

Last updated on APRIL 23, 2018

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 (BO), when a permanent price change is sent more than once from the Oracle Retail Price Management (RPM), multiple records are inserted into the PERMANENT_PRICE_CHANGE table.  If RPM sends a price change with ChangeType as "DEL", only one occurrence of the records is deleted.

Steps to Reproduce:

1. Import a price import as per below to the Back office through data import (DIMP).

<?xml version=""1.0"" encoding=""UTF-8"" ?>
<PricingImport Priority=""0"" FillType=""FullIncremental"" Version=""1.0""
Batch=""1"" CreationDate=""2016-05-11T11:19:16.0Z""
xsi:noNamespaceSchemaLocation=""PricingImport.xsd""
xmlns:xsi=""http://www.w3.org/2001/XMLSchema-instance"">
<PriceChange ChangeType=""ADD"" ID=""1121485"" StartDate=""2016-05-11""
TemplateType=""Default"">
<Item ID=""908"" TemplateType=""Default"">
<Price>100</Price>
</Item>
</PriceChange>
</PricingImport>


2. Check the PERMANENT_PRICE_CHANGE table and note that one record related to the above Price Change was inserted correctly.
3. Re-import the same PricingImport XML to the Back Office.
4. Check the PERMANENT_PRICE_CHANGE table and note that a new record was inserted correctly.
5. Import the following to the Back Office through DIMP.

<?xml version=""1.0"" encoding=""UTF-8"" ?>
<PricingImport Priority=""0"" FillType=""FullIncremental"" Version=""1.0""
Batch=""1"" CreationDate=""2016-05-11T12:09:03.0Z""
xsi:noNamespaceSchemaLocation=""PricingImport.xsd""
xmlns:xsi=""http://www.w3.org/2001/XMLSchema-instance"">
<PriceChange ChangeType=""DEL"" ID=""1121485"" StartDate=""2016-05-11""
TemplateType=""Default"">
<Item ID=""908"" TemplateType=""Default"">
<Price>100</Price>
</Item>
</PriceChange>
</PricingImport>


6. Check the PERMANENT_PRICE_CHANGE table and note that only one record was deleted.

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!


In this Document
Symptoms
Cause
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.