My Oracle Support Banner

Webservice Call to Modify PO Fails due to PO Record being Locked (Doc ID 2697805.1)

Last updated on JULY 25, 2022

Applies to:

Oracle Retail Merchandising Foundation Cloud Service - Version 19.0 and later
Information in this document applies to any platform.


When PurchaseOrderManagementBeanPortBinding > modifyHeader SoapUI web service call is invoked, it is successful but it does not complete the processing (commit) for 2-3 minutes.

If you invoke modifyHeader one more time, it fails with faultstring "Table SVC_ORDHEAD with key values %s2 , %s3 is locked by another user."

If you invoke modifyDetail SoapUI web service call within the 2-3 minutes after invoking modifyHeader, it fails with faultstring "The record containing Order Number %s1 is locked by another user and cannot be updated.".


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.