During Mobile MWA Receiving, Purchase Order PO List of Values LOV Hangs With Message: 'Please Wait'
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) */
-- DOCTYPE PO
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