Performance Issue upon Running SAPREPOST Batch for SAEXPRMS POST and SAEXPSIM POST
(Doc ID 2293708.1)
Last updated on FEBRUARY 25, 2019
Applies to:Oracle Retail Sales Audit - Version 14.1.1 and later
Information in this document applies to any platform.
SAPREPOST (Pre/Post Helper Processes for ReSA Batch Programs) for SAEXPRMS (Sales Export to RMS) POST and SAEXPSIM (Sales Export to SIM) POST takes time to complete when there are huge number of records in the SA_EXPORT_LOG (15 million+ records).
Steps to reproduce:
1) Ensure there is huge number of records in SA_EXPORT_LOG.
2) Execute SAPREPOST SAEXPRMS POST, SAPREPOST SAEXPSIM POST.
3) Note that the batch takes a long time to complete (3+ hours).
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