Sapurge - INSERT INTO Sa_tran_item_temp Slow As Not Using Partitioning
(Doc ID 2819763.1)
Last updated on NOVEMBER 05, 2021
Applies to:Oracle Retail Sales Audit - Version 16.0.3 and later
Information in this document applies to any platform.
sapurge - INSERT INTO sa_tran_item_temp slow as not using partitioning
In the sapurge program, the INSERT INTO sa_tran_item_temp statement in the delete_cust_ord_tran_detail function does not use store and day in the JOINs of SA_TRAN_HEAD and SA_TRAN ITEM.
Steps To Recreate:
1) Run sapurge batch in volume environment.
2) Notice that the batch is not using partitioning..
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