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

Symptoms

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.

Changes

 The HINTS on code below:

ELSE(section)
  --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) */
  -- DISTINCT
  -- DOCTYPE PO

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

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