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 MARCH 13, 2018

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).

 

Changes

 

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