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 OCTOBER 13, 2022
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!