Performance Issues While Looking up VPN Item Price in SIM (Doc ID 2158593.1)

Last updated on JULY 11, 2016

Applies to:

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

Symptoms

The issue described in this document is known to Oracle, and a fix is already scheduled for future release. This article will be updated as official patch becomes available.

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.

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