Data Import with Changetype "DEL" Does Not Delete Duplicate Price Change Events
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.
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.
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