Price Change Consumer Price History Delete Logic Is Wrong and Should Include Store and Item (Performance Issue) (Doc ID 1991474.1)

Last updated on SEPTEMBER 25, 2015

Applies to:

Oracle Retail Store Inventory Management - Version 13.2.4 to 13.2.9 [Release 13.2]
Information in this document applies to any platform.

Symptoms

The issue described in this document is known to Oracle, and a fix is already scheduled for future release.
This article will be updated as official patch becomes available.

In the Store Inventory Management (SIM) application, we find that price change consumer deletes from price history using column ID_EV instead of column PRICE_CHANGE_ID. The query should also be including store ID and item ID to greatly improve performance.  Note that there are no indexes existing on LE_HST_ITM_SLS_PRC.ID_EV column, adding to performance issues.


Steps to Reproduce:


1. Send ClrPrcChgDel, MultiBuyPromoDel, or RegPrcChgDel from RPM to SIM
2. Observe sessions in database taking a long time to execute DELETE FROM LE_HST_ITM_SLS_PRC WHERE ID_EV = ? while the parameter being passed in the code is from PRICE_CHANGE_ID
3. Observe stuck threads in WebLogic server due to query execution taking longer than stuck_thread_max

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