Performance Issue While Querying PO Number In Mobile Apps

(Doc ID 1638978.1)

Last updated on AUGUST 21, 2016

Applies to:

Oracle Inventory Management - Version 12.1.1 to 12.1.3 [Release 12.1]
Oracle Purchasing - Version 12.1.1 to 12.1.3 [Release 12.1]
Information in this document applies to any platform.


When entering or querying a PO number in Mobile Apps a performance issue is encountered. This takes 3 minutes and the following SQL is causing the performance issue:


The issue can be reproduced at will with the following steps:

  1. Telnet > All Mobile Warehouse Manager Resp.                      
  2. Select > Inbound > Receive                                        
  3. Select > PO                                                      
  4. Enter > Org. Code                                                
  5. Enter > PO number & query. At this moment the performance issue is observed.


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