Sapurge Batch Is Running long
(Doc ID 2695955.1)
Last updated on AUGUST 03, 2020
Applies to:Oracle Retail Sales Audit - Version 16.0.2 and later
Information in this document applies to any platform.
Index needed on SA_GL_REF_DATA for sapurge.
Steps To Recreate:
1) Make sure SA_GL_REF_DATA has upwards of 30 million records.
2) Run sapurge to remove 1 days worth (3000 store/day records) of data
3) Notice SQL to remove data from KEY_MAP_GL and SA_GL_REF_DATA do full table scans on SA_GL_REF_DATA and take time.
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