Please Wait.. Message While Doing The Receiving Through MSCA

(Doc ID 2165270.1)

Last updated on JULY 26, 2016

Applies to:

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

Symptoms

On : 12.1.3 version

In Oracle Inventory Management, one RTP may fail if two RTPs for different releases of same BPA are running almost at the same time.

Scenario
----------
User has a large Blanket Purchase Agreement(BPA) with around 10000 items. As per the process user will create the releases and ASNs for this BPA.
Once user receive the shipments from Suppliers then user receive by using the ASNs.
When ever user receive the ASN and click on 'Done' button in the receiving information page of MSCA then get error: 'Please wait...' message.
Try to replicate the issue by generating the logs. Based on the analysis, came to know that the receipt on ASN is locking the parent BPA and processing the receipt and releasing the hold.
As the BPA is large and having 10000 lines and users receive lot of ASNs that belongs to this BPA.
So for every user and ASN receipt combination, Oracle is locking and unlocking the BPA. So if one user is doing the receipt and another user is getting getting 'Please wait.. ' message.

Below is SQL query which is trying to get the lock on the BPA.
select po_header_id into :b0
from po_headers_all
where po_header_id=:b1 for update of po_header_id

The ASN receipt is trying the acquire lock on entire BPA instead of the release associated to the ASN.

ERROR
-----------------------
 'Please wait...'

STEPS
-----------------------
Inbound processing

BUSINESS IMPACT
-----------------------
It is impacting warehouse labor users productivity. Most of the time they are waiting while receiving the goods.

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