My Oracle Support Banner

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

Last updated on AUGUST 10, 2020

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

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
Symptoms
Cause
Solution
 1. Bug Summary
 2. Fixed Files
 3. Recommended Patches
 4. Solution Steps
References


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