My Oracle Support Banner

Sapreexp Needs To Be Multi-threaded (Doc ID 3008172.1)

Last updated on MARCH 04, 2024

Applies to:

Oracle Retail Sales Audit - Version 16.0.3 to 16.0.3 [Release 16.0]
Information in this document applies to any platform.


On : 16.0.3 version, Other

SAPREEXP needs to be multi-threaded, With number of stores, number of ReSA Totals and number of systems to which ReSA data (i.e totals) are exported, the SAPREEXP program can process upwards of 30,000 store/day/export records which then will process 200+ totals for updating of export information. Since SAPREEXP is single threaded, it can take 45 - 60 minutes to run. Since the driving cursor is obtaining STORE_DAY_SEQ_NO, it would be easy to implement threading by store (i.e. V_RESTART_STORE) so that this batch can be threaded and finish in a few minutes.




To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.