My Oracle Support Banner

ARHPARTYPUR - TCA Purge Identified Parties Performance Issue (Doc ID 1436754.1)

Last updated on JANUARY 26, 2017

Applies to:

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

Symptoms

ARHPARTYPUR module: TCA Purge Identified Parties is taking 3 minutes or more with nothing to purge

Following queries are showing as top queries in tkprof:

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'

DELETE FROM HZ_PARTIES
WHERE
PARTY_ID IN (SELECT PARTY_ID 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


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