During Mobile MWA Receiving, Purchase Order PO List of Values LOV Hangs With Message: 'Please Wait'

(Doc ID 1919233.1)

Last updated on MAY 15, 2016

Applies to:

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


In MWA, receiving functions, when querying Purchase Order list of values, the system hangs with message "Please Wait" suggesting a performance issue.

When a user enters/scans a PO number to make a mobile receipt, it takes 1-2 minutes for the form to advance past the PO line in the mobile form on a PO. This is entering a known PO, not querying. This delay seems to be on larger PO's.


 The HINTS on code below:

  --Both Inventory Item Id and Item Desc are Null
  --And also Both Item Id and Item Desc won't be passed together.
  --SELECT /*+index(POH PO_HEADERS_U2) */

on function: INV_UI_RCV_LOVS.GET_DOC_LOV has been removed by customer and it's working as expected.


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