PurgePriceHistories Job Hangs and Times Out
Last updated on AUGUST 17, 2016
Applies to:Oracle Retail Store Inventory Management - Version 13.1.6 to 13.1.9 [Release 13.1]
Information in this document applies to any platform.
In Oracle Retail Store Inventory Management (SIM) 13.1.x, the PurgePriceHistories batch hangs and and aborts after a lengthy time executing. In the reproducible scenario, there are 15 million records in the LE_HST_ITM_SLS_PRC table.
Steps to Reproduce:
- Set the value for 'Days to Hold Price History' to 90 days.
- Have approximately 15 million records in LE_HST_ITM_SLS_PRC table.
- Run batch job "PurgePriceHistories.sh".
- Notice that the job runs for a long time before aborting.
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
Million Knowledge Articles and hundreds of Community platforms