Unable To Purge Relationship Parties (Doc ID 1308935.1)

Last updated on JULY 18, 2017

Applies to:

Oracle Customers Online - Version 12.1.3 and later
Information in this document applies to any platform.

Symptoms

Party Purge Program Purge does NOT purge the Relationship Data as it did for Organization and Person party type.

In current release, when you run Party Purge Program, the party data will be
deleted from hz_parties table. But when Run Party Purge Program, the
RELATIONSHIP type party is only marked as M.

Create a customer "Jackie Org C" - Customer Number 5951
Create a contact Jackie C
Create a customer "Jackie Org CC" - Customer Number 5952
Create a contact Jackie CC

SQL> select party_name, party_id, status, party_type from hz_parties
          where party_name in
          ('Jackie Org C', 'Jackie Org CC', 'Jackie C', 'Jackie CC',
           'Jackie C-Jackie Org C-57753', 'Jackie CC-Jackie Org CC-57756');

PARTY_NAME PARTY_ID S PARTY_TYPE
---------------------------------------- ---------- - ------------------
Jackie C 403335 A PERSON
Jackie C-Jackie Org C-57753 403336 A PARTY_RELATIONSHIP
Jackie CC 403341 A PERSON
Jackie CC-Jackie Org CC-57756 403342 A PARTY_RELATIONSHIP
Jackie Org C 403333 A ORGANIZATION
Jackie Org CC 403339 A ORGANIZATION

Run Party Merge to Merge
Jackie C to Jackie CC, also merge Jackie C-Jackie Org C-57753 to Jackie CC-Jackie Org CC-57756

After merge:

PARTY_NAME PARTY_ID S PARTY_TYPE
---------------------------------------- ---------- - ------------------
Jackie C 403335 M PERSON
Jackie C-Jackie Org C-57753 403336 M PARTY_RELATIONSHIP
Jackie CC 403341 A PERSON
Jackie CC-Jackie Org CC-57756 403342 A PARTY_RELATIONSHIP
Jackie Org C 403333 A ORGANIZATION
Jackie Org CC 403339 A ORGANIZATION

Log onto Customers Data Librarian
Navigate to "Data Quality" -> Purge Request
1. Create Purge Request
    Here we can only choose Person and Organization for the Party Type,
    You don't have choice to purge the Party Relationship
2. Create a purge request to purge the 'Merged' parties.
3. Notice that the merged Person parties and other merged related information
    has been deleted.
4. Query the hz_parties table by using the following query.
    SELECT * FROM HZ_PARTIES WHERE STATUS ='M'
5. Notice that the merged 'PARTY_RELATIONSHIP' parties still exists
    in the parties table.

Changes

 

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