Performance Issue upon Running SAPREPOST Batch for SAEXPRMS POST and SAEXPSIM POST (Doc ID 2293708.1)

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.

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

Changes

 

Cause

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