"KillAndFill" Item Import Does Not Delete Records From Price Change Tables (Doc ID 2214383.1)

Last updated on DECEMBER 29, 2016

Applies to:

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

Symptoms

Fill Type KillAndFill on an Item Import deletes records only from table MA_ITM_TMP_PRC_CHN , however , records from the following tables are not deleted :

MA_ITM_CLR_PRC_CHN
TR_CHN_CLR_PRC
TR_CHN_TMP_PRC

Steps to Reproduce:

1. Import the following "PricePromotion" and "Clearance" :

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