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

Last updated on NOVEMBER 22, 2016

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).


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

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