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

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms