TCA API Issue: HZ_PARTY_V2PUB.update_organization Creates a New Organization Profile Record Each Time an Update is Made (Doc ID 282186.1)

Last updated on MARCH 13, 2024

Applies to:

Symptoms

You are using HZ_PARTY_V2PUB.update_organization API to update information regarding a Party and notice that when you alter the Party name it creates a new Record in HZ_ORGANIZATION_PROFILES for each update. However, if you modify another field, for example Category Code, a new profile record is not created.

Why are new records created?

Steps to Reproduce:
Please note that IDs are hard-coded for demonstration purposes, you will have to modify these values for your instance.

This shows that one record has been added. However, when you run a similar test using the script above and replacing:
p_organization_rec.organization_name := 'Company Name';

with:
p_organization_rec.party_rec.category_code := 'PROSPECT'

A new profile record is not created.

Changes

Cause