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.
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.
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
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.
It is impacting warehouse labor users productivity. Most of the time they are waiting while receiving the goods.
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
Million Knowledge Articles and hundreds of Community platforms