Performance Issue While Querying PO Number In Mobile Apps
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:
- Telnet > All Mobile Warehouse Manager Resp.
- Select > Inbound > Receive
- Select > PO
- Enter > Org. Code
- 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