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


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!

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