ER: Need Multi-Threaded Support for SALESPROCESS.KSH (Main Processing of Staged Sale/Return Transactions) (Doc ID 2129708.1)

Last updated on APRIL 24, 2016

Applies to:

Oracle Retail Merchandising System - Version 14.0.3 and later
Information in this document applies to any platform.

Goal

In Oracle Retail Merchandising System (RMS), the SALESPROCESS.KSH (Main Processing of Staged Sale/Return Transactions) script rejects many sales files with 'R' status (possibly due to a Oracle 12c database issue).  If this happens, you need to generate a lot of reject files (hundreds of them) and process them on the next batch run.  You process sales on an hourly basis, so if reject file processing takes a lot of time, then you cannot process the rejected sales in the next hourly; this could adversely impact the full batch schedule.  Hence, we require a multi-threaded mode for this batch process.
 

Solution

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