Deadlocks observed while trying to invoke adjustInventory API.

Technote (troubleshooting)


Deadlocks are observed while trying to invoke adjustInventory API.


Deadlocks are detected as shown in the error trace below :

java.sql.SQLException: ORA-00060: deadlock detected while waiting for resource
at oracle.jdbc.driver.T4CTTIoer.processError( at oracle.jdbc.driver.T4CTTIoer.processError( at oracle.jdbc.driver.T4C8Oall.processError( at oracle.jdbc.driver.T4CTTIfun.receive(
at oracle.jdbc.driver.T4CTTIfun.doRPC(
at oracle.jdbc.driver.T4C8Oall.doOALL(
at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement. java:205)

Resolving the problem

Enabling below mentioned property will help in resolving the problem, as it will lock items in alphabetical order.

yfs.yfs.inventory.sortandlock=Y in or yfs.inventory.sortandlock=Y in

Setting this property to Y will prevent dead locks on YFS_Inventory_Item table during
order creation and when synchronizing changes from a shipment back to the order. This
parameter is only used if the order contains a logical kit, or when a shipment lines are created for different orders.

Setting this property to Y will result into holding lock on YFS_Inventory_Item table for longer period. So, this may degrade overall system performance. Because of this reason, this property should be set to Y only if excessive dead locks are occurring on YFS_Inventory_Item table.

Document information

More support for:

Sterling Order Management

Software version:


Operating system(s):

Platform Independent

Reference #:


Modified date:


Translate my page

Content navigation