Poor Performance of RMS Batch DEALFINC
Last updated on AUGUST 17, 2016
Applies to:Oracle Retail Merchandising System - Version 126.96.36.199 to 13.1.9 [Release 13.1]
Information in this document applies to any platform.
In Oracle Retail Merchandising System (RMS) 13.1.x, the DEALFINC batch has a critical performance problem when processing a large volume of data.
Steps to Reproduce:
- Create cross references in FIF_GL_CROSS_REF table for ~10 million records.
- Create 8 fixed deals with collect date for tomorrow.
- Run the batch to process the deal.
- Verify that DEALFINC batch hangs after several hours of processing.
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