Can DOCCLOSE Batch Be Multithreaded ? (Doc ID 1102404.1)

Last updated on MAY 10, 2017

Applies to:

Oracle Retail Merchandising System - Version 12.0.5 and later
Information in this document applies to any platform.
The Note is specific to India Localization Customers Only.
checked for relevance on 08-June-2012
checked for relevance on 03-December-2015
Checked for relevance on 21-January-2014
Checked for relevance on 10-May-2017


Goal

Can DOCCLOSE batch be multi-threaded ?

Retail Merchandising System (RMS) Operations Guide indicates that DOCCLOSE is not designed for multithreading,but the code for Docclose indicates otherwise.

The driving cursor as extracted below from docclose.pc file :


EXEC SQL DECLARE c_unique_doc CURSOR FOR
SELECT doc,
doc_type,
rowid
FROM doc_close_queue
WHERE doc_type = :as_doc_type
AND doc > NVL(TO_NUMBER(:ps_restart_doc), -999)
AND restart_thread_return(doc, :ps_num_threads) = :ps_thread_val
ORDER BY doc;

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