My Oracle Support Banner

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).


To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.