Performance Issue in NewItemLocbatch
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
Million Knowledge Articles and hundreds of Community platforms