My Oracle Support Banner

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.

Symptoms

 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).

Cause

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
Symptoms
Cause
Solution
References


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