My Oracle Support Banner

Delete From Sa_bank_ach Not Thread Specific For Sapurge Job (Doc ID 2819838.1)

Last updated on NOVEMBER 08, 2021

Applies to:

Oracle Retail Sales Audit - Version 16.0.3 and later
Information in this document applies to any platform.

Symptoms

Delete from sa_bank_ach not Thread Specific for sapurge job.

Steps To Recreate:
1) Multi-thread sapurge.
2) Run sapurge
3) Notice all threads run the DELETE FROM sa_bank_ach statement and notice contention, as there is no different between DELETE statement for each thread

Changes

 

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