Performance Issue upon Running SAPREPOST Batch for SAEXPRMS POST and SAEXPSIM POST
Last updated on AUGUST 04, 2017
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).
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