My Oracle Support Banner

Ship Confirm Error: This action cannot be performed for delivery DEL_NAME because locks could not be obtained on some of its lines or containers. (Doc ID 2032595.1)

Last updated on DECEMBER 03, 2019

Applies to:

Oracle Shipping Execution - Version 12.1 and later
Information in this document applies to any platform.
WSH_DLVY_LINE_LPN_LOCK

Symptoms

When trying to execute Ship Confirm, the following error is invoked.

Error

This action cannot be performed for delivery DEL_NAME because locks could not be obtained on some of its lines or containers.

Error Name: WSH_DLVY_LINE_LPN_LOCK

Steps

  1. User A is editing the delivery detail which is assigned to delivery A.
  2. User B is trying to Ship Confirm the delivery A.
  3. The following error is invoked.

    Error: This action cannot be performed on all selected records.

    Error: This action cannot be performed for delivery DEL_NAME because  locks could not be obtained on some of its lines or containers.
    ------------------------------------
    Error: The action can not be performed because the selected records could not be locked.

Note: This is one example to reproduce the issue when WSH_DELIVERY_DETAILS table or WSH_DELIVERY_ASSIGNMENTS table cannot be locked during Ship Confirm process. You can also see the same error when you execute Ship Confirm via API (WSH_DELIVERIES_PUB.DELIVERY_ACTION).

 

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


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