Performance Issue With New Item Loc Ranging During Po Creation

(Doc ID 2247000.1)

Last updated on JULY 31, 2017

Applies to:

Oracle Retail Merchandising System - Version 15.0 to 15.0.1 [Release 15.0]
Information in this document applies to any platform.


After applying the <Patch 25050121> and adding about 5 million rows, performance of ITEM_LOC ranging is very slow.


  1. Make sure there are lot of records on ITEM_LOC table.
  2. Create a PO for item/location which have not been ranged.
  3. Notice that during the creation it takes lot of time to range the item/location.




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