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 JULY 12, 2017

Applies to:

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

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 := 'Jackie Corp';

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

A new profile record is not created.

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