TCA API Error: Hz_Party_Pub.Update_Party_Relationship When Passing Value for LAST_UPDATED_DATE Errors With: This record in table hz_parties cannot be locked as it has been updated by another user. (Doc ID 863313.1)

Last updated on APRIL 04, 2025

Applies to:

Symptoms

When using Hz_Party_Pub.Update_Party_Relationship and LAST_UPDATE_DATE is set to SYSDATE, the code errors with:

This record in table hz_parties cannot be locked as it has been updated by another user.

The following sample code was used to call the API:

when run, it returns:

Encountered ERROR!!!!!!
-----------------------
This record in table hz_parties cannot be locked as it has been updated by another user.

If l_party_last_update_date Date := NULL,  the API completes with no error.

Changes

Cause

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