My Oracle Support Banner

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:

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


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';

p_organization_rec.party_rec.category_code := 'PROSPECT'

A new profile record is not created.




To view full details, 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 a vibrant support community of peers and Oracle experts.