My Oracle Support Banner

TCA Purge Identified Parties (ARHPARTYPUR) Poor Performance (Doc ID 2267047.1)

Last updated on FEBRUARY 03, 2019

Applies to:

Oracle Trading Community - Version 12.1.3 and later
Information in this document applies to any platform.

Symptoms

TCA Purge Identified Parties is taken too long affecting the incompatible programs like TCA Business Object Events: Raise Events

Tho DELETE statements have performance issue : DELETE FROM HZ_RELATIONSHIPS WHERE (SUBJECT_ID IN (SELECT CANDIDATE_PARTY_ID FROM HZ_PURGE_CANDIDATES WHERE BATCH_ID=:B1 AND STATUS='IDENTIFIED') OR OBJECT_ID IN (SELECT CANDIDATE_PARTY_ID FROM HZ_PURGE_CANDIDATES WHERE BATCH_ID=:B1 AND STATUS='IDENTIFIED')) AND STATUS = 'M'

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
 1. Bug Summary
 2. Fixed Files
 3. Recommended Patches
 4. Solution Steps
References


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