Supplier Registration Request Throws "Unable To Lock The Record." (Doc ID 1617984.1)

Last updated on MAY 17, 2017

Applies to:

Oracle Supplier Lifecycle Management - Version 12.1.3 and later
Information in this document applies to any platform.

Symptoms

When accessing and updating a new supplier requests, the following error occurs.

ERROR
-----------------------
"Unable to lock the record. Cause: The record is being modified".

This error is thrown only when the user tries to save any changes performed in the supplier registration request.  This issue occurs only when the Buyer user is creating the new supplier request and navigates to the supplier profile attributes page from the 'Supplier Request' Page. If the user does not navigate to the profile attributes page, the concurrent process updates on the same supplier request by the Buyer User and Supplier Management Administrator works as expected.

Fnd debug log:
---------------
-- Log File --
.
.
OAF LOG: Event : Get Attribute Value, in: oracle.apps.fnd.framework.webui.OAFormValueHelper: View:null ,Attribute:_fwkActBtnName_UpdateImage_updateAttributes$$serverUnvalidated , Return Value without datatype conversion :null
OAF LOG: Event : Get Attribute Value, in: oracle.apps.fnd.framework.webui.OAFormValueHelper: View:null ,Attribute:_fwkActBtnName_UpdateImage_updateAttributes$$serverUnvalidated , Return Value:null
OAF LOG: Event : Get Attribute Value, in: oracle.apps.fnd.framework.webui.OAFormValueHelper: View:null ,Attribute:_AM_TX_ID_FIELD , Return Value without datatype conversion :null
OAF LOG: Event : Set Attribute Value, in: oracle.apps.fnd.framework.webui.OAFormValueHelper: OldValue:null ,New Value:11
OAF LOG: Event : Get Attribute Value, in: oracle.apps.fnd.framework.webui.OAFormValueHelper: View:null ,Attribute:_FORM , Return Value without datatype conversion :null
OAF LOG: Event : Set Attribute Value, in: oracle.apps.fnd.framework.webui.OAFormValueHelper: OldValue:null ,New Value:DefaultFormName
OAF LOG: Event : Get Attribute Value, in: oracle.apps.fnd.framework.webui.OAFormValueHelper: View:null ,Attribute:lovAutoClearHFTaxRegCountry , Return Value without datatype conversion :N
OAF LOG: Event : Call Process Form Data, in: oracle.apps.pos.onboard.webui.FlexRegApproverPGCO: Entering Process Form Data
OAF LOG: Event : Get Attribute Value, in: oracle.apps.fnd.framework.webui.OAMessageTextInputHelper: View:SuppRegVO ,Attribute:SupplierName , Return Value without datatype conversion :Bug_Test_SUP_2811_1
OAF LOG: Event : Get Attribute Value, in: oracle.apps.fnd.framework.webui.OAMessageChoiceHelper: View:SuppRegVO ,Attribute:SupplierType , Return Value without datatype conversion :null
OAF LOG: Event : Set Attribute Value, in: oracle.apps.fnd.framework.webui.OAMessageChoiceHelper: OldValue:null ,New Value:VENDOR
OAF LOG: Event : Get Attribute Value, in: oracle.apps.fnd.framework.webui.OAMessageChoiceHelper: View:SuppRegVO ,Attribute:RegistrationPurpose , Return Value without datatype conversion :FULL_ONBOARD
getProfileOptionValue: name=AFLOG_BUFFER_MODE; levelID=10001; levelValue=0; levelValueApplID=0
"Unable to lock the record.

Cause: The record is being modified by another user."
oracle.apps.fnd.common.WebAppsContext.getFNDGlobal(): BEGIN
oracle.apps.fnd.common.WebAppsContext.getFNDGlobal(): END
oracle.apps.fnd.common.WebAppsContext.getFNDGlobal(): BEGIN
oracle.apps.fnd.common.WebAppsContext.getFNDGlobal(): END
oracle.apps.fnd.common.WebAppsContext.getFNDGlobal(): BEGIN
oracle.apps.fnd.common.WebAppsContext.getFNDGlobal(): END
getProfileOptionValue: name=ORG_ID; levelID=10003; levelValue=50638; levelValueApplID=177
getProfileOptionValue: name=ORG_ID; levelID=10001; levelValue=0; levelValueApplID=0
.
.
7: [BCAMImpl.applyClassificationChanges] expDate = null
7: [BCAMImpl.applyClassificationChanges] expDateW = null
7: [BCAMImpl.applyClassificationChanges] applicable = N
7: [BCAMImpl.applyClassificationChanges] applicableW = N
"OAF LOG: Event : Check Errors, in: oracle.apps.fnd.framework.webui.OAPageErrorHandler: Exception: Unable to lock the record.

Cause: The record is being modified by another user. ,In VO: null"
"OAF LOG: Event : Check Errors, in: oracle.apps.fnd.framework.webui.OAPageErrorHandler: Exception: Unable to lock the record.

Cause: The record is being modified by another user."
getProfileOptionValue: name=OAM_UALERT_SHOW_ICON; levelID=10004; levelValue=1110; levelValueApplID=0
getProfileOptionValue: name=OAM_UALERT_SHOW_ICON; levelID=10003; levelValue=50638; levelValueApplID=177
getProfileOptionValue: name=OAM_UALERT_SHOW_ICON; levelID=10002; levelValue=177; levelValueApplID=0
getProfileOptionValue: name=OAM_UALERT_SHOW_ICON; levelID=10001; levelValue=0; levelValueApplID=0
"OAF LOG: Event : Check Errors, in: oracle.apps.fnd.framework.webui.OAPageErrorHandler: Exception: Unable to lock the record.

Cause: The record is being modified by another user. ,In Bean: null"
getProfileOptionValue: name=FND_CUSTOM_OA_DEFINTION; levelID=10004; levelValue=1110; levelValueApplID=0
===============================================================
Root Application Module
  ViewUsageName: ValidateAttachCategoryVO2
  isPreparedForExecution: true
  whereClause: null
  whereParam0: Vendor


STEPS
-----------------------
The issue can be reproduced at will with the following steps:

We have observed this error in the following scenarios:
1. User tries to update some values (like internal notes) and saves
2. User clicks on the update profile attribute page

Steps:
------
1. Login as Buyer User and access Supplier Data Librarian responsibility --> Register New Supplier
2. Click continue in the next page
3. In the next screen fill all the required values and click on save and continue ( Please note at this point itself a request is created and it is available in the Supplier Management Administrator TO-DO List of New Supplier Requests)
4. In the next page click on the update icon in the Profile attribute section
5. The attribute page is displayed
6. Now click on the profile management link to navigate to supplier home page or close the browser to end the session
7. Login as Supplier Management Administrator User --> Supplier Home --> TO-DO List --> New Supplier Requests
8. Notice that the new request is shown first in the list. Click on the review icon
9. The request opens up and try to update any values (internal notes) and save
10. Error is thrown

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