My Oracle Support Banner

TCA API HZ_PARTY_CONTACT_V2PUB.UPDATE_ORG_CONTACT Is Not Updating Contact Status At Address Level (Doc ID 330825.1)

Last updated on OCTOBER 13, 2022

Applies to:

Oracle Trading Community - Version 11.5.10 to [Release 11.5]
Information in this document applies to any platform.


The API procedure hz_party_contact_v2pub.update_org_contact is not updating contact status at address level. The API is completing successfully but it is not updating status in the hz_cust_account_roles table. It only updates the "status" column in hz_org_contacts table to Inactive.

When updating the contact status through Customers form (ARXCUDCI), on back end the following two columns are set to 'I' in the hz_cust_account_roles table:
   1. current_role_state
   2. status

Which API should be used to inactive customer's address level contacts ?


To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.