Duplicate Promotions Are Not Deleted At Once When Deleted Via DIMP (Doc ID 1637963.1)

Last updated on NOVEMBER 02, 2016

Applies to:

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

Symptoms

When duplicate promotion records are imported into Back Office (BO) , the DEL change type extracts do not delete all the duplicate records at once.

Steps to Reproduce:

 1. Import the same promotion twice into BO:

<PricePromotion ChangeType="ADD"
ID="1179" PromoCompID="3052" PromoCompDetlID="2185"
StartDateTime="2013-08-26T00:00:00.0Z"
EndDateTime="2013-09-29T23:59:59.0Z" Type="AmountOff" Priority="1"
TemplateType="Default">
<Name>SPA130826</Name>
<Description>SPA Interface</Description>
<DiscountAmount>1</DiscountAmount>
<Item ID="000003700">
<Price>8.99</Price>
</Item>
</PricePromotion>


<PricePromotion ChangeType="ADD"
ID="1179" PromoCompID="3048" PromoCompDetlID="2089"
StartDateTime="2013-08-26T00:00:00.0Z"
EndDateTime="2013-09-29T23:59:59.0Z" Type="AmountOff" Priority="1"
TemplateType="Default">
<Name>SPA130826</Name>
<Description>SPA Interface</Description>
<DiscountAmount>4</DiscountAmount>
<Item ID="000005304">
<Price>19.99</Price>
</Item>
</PricePromotion>


2025 1179 TPC 000005304 01110 26-AUG-13 12.00.00.000000000 AM 29-SEP-13 11.59.59.000000000 PM 1 4 AMT 19.99      1179   3048 2089 -1
2022 1179 TPC 000005304 01110 26-AUG-13 12.00.00.000000000 AM 29-SEP-13 11.59.59.000000000 PM 1 4 AMT 19.99      1179   3048 2089 -1
2020 1179 TPC 000003700 01110 26-AUG-13 12.00.00.000000000 AM 29-SEP-13 11.59.59.000000000 PM 1 1 AMT 8.99       1179   3052 2185 -1
2024 1179 TPC 000003700 01110 26-AUG-13 12.00.00.000000000 AM 29-SEP-13 11.59.59.000000000 PM 1 1 AMT 8.99       1179   3052 2185 -1

2. Import the following (ChangeType="DEL") into BO:

<?xml version="1.0" encoding="UTF-8" ?>
<PricingImport Priority="0" FillType="FullIncremental" Version="1.0" Batch="1" CreationDate="2013-11-26T22:00:18.0Z" xsi:noNamespaceSchemaLocation="PricingImport.xsd" xmlns:xsi="" title="Click (or CTRL+Click if using Firefox) to view" name="contextTextUrl_1395372400507" target="_blank">http://www.w3.org/2001/XMLSchema-instance">
<PricePromotion ChangeType="DEL" ID="1179" PromoCompID="3052" PromoCompDetlID="2185" StartDateTime="2013-11-26T00:00:00.0Z" EndDateTime="2013-11-26T00:00:00.0Z" Type="AmountOff" Priority="1" TemplateType="Default">
<Name>DELETE</Name>
<Description>DELETE</Description>
<DiscountAmount>0</DiscountAmount>
<Item ID="000005304">
<Price>0</Price>
</Item>
</PricePromotion>
<PricePromotion ChangeType="DEL" ID="1179" PromoCompID="3048" PromoCompDetlID="2089" StartDateTime="2013-11-26T00:00:00.0Z" EndDateTime="2013-11-26T00:00:00.0Z" Type="AmountOff" Priority="1" TemplateType="Default">
<Name>DELETE</Name>
<Description>DELETE</Description>
<DiscountAmount>0</DiscountAmount>
<Item ID="000003700">
<Price>0</Price>
</Item>
</PricePromotion>
</PricingImport>

 
2024 1179 TPC 000003700 01110 26-AUG-13 12.00.00.000000000 AM 29-SEP-13 11.59.59.000000000 PM 1 1 AMT    8.99     1179    3052     2185    -1
2025 1179 TPC 000005304 01110 26-AUG-13 12.00.00.000000000 AM 29-SEP-13 11.59.59.000000000 PM 1 4 AMT    19.99    1179    3048     2089    -1

Changes

 

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