Performance Issue in NewItemLocbatch (Doc ID 2289567.1)

Last updated on JULY 31, 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.

Symptoms

NewItemLocbatch has a performance issue.

Steps to Recreate:

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

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

Cause

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