Update Relationship in Customers Screen Error - This Record In The Table Hz_parties Cannot Be Locked (Doc ID 1565046.1)

Last updated on JULY 12, 2017

Applies to:

Oracle Trading Community - Version 12.1.3 and later
Oracle Receivables - Version 12.1.3 to 12.1.3 [Release 12.1]
Information in this document applies to any platform.

Symptoms

In R12.1.3

Attempting to end date an existing relationship for a party on Customers page and receive the following error:

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


Steps to Reproduce:
Responsibility:  Receivables
Navigation:  Customers > Customers
In the Customers Search page, enter Registry Id and click on Go button.
Click on the Customer Name link and then click on Party Relationships tab.
Update the existing party relationship by entering the end date.
Click on Save button, and the error message occurs.

or

Sales Dashboard
Click on Customer hyperlink
Search customer > click customer to open
click Business Relationship tab > update existing relationship
click Apply button

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