My Oracle Support Banner

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.




To view full details, 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 a vibrant support community of peers and Oracle experts.