Performance Issue in NewItemLocbatch

(Doc ID 2289567.1)

Last updated on OCTOBER 23, 2017

Applies to:

Oracle Retail Price Management - Version 14.1 to 14.1.3 [Release 14.1]
Information in this document applies to any platform.


NewItemLocbatch has a performance issue.

Steps to Recreate:

1. Create many items in RMS (like 50,000 item-locations) and approve them.

2. Run RPM NewItemLocation batch.

3. Check if items are inserted to RPM_FUTURE_RETAIL table.

Note: Observed that NIL batch taking long time (from 15 min to 2+ hours).


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