Performance Issues While Looking up VPN Item Price in SIM

(Doc ID 2158593.1)

Last updated on OCTOBER 12, 2017

Applies to:

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


 In the Store Inventory Management (SIM) application, we find that the application slows down while looking up price of a VPN item.

Steps to Recreate:

1. Log in to SIM PC
2. Select Lookup -> Item Lookup
3. Search with a VPN number

At this point, the query with all the items associated with VPN is being fired and slow response can be noticed via database statistics and performance reports.


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