My Oracle Support Banner

Often Executed SQL Retrieving Many Records Into Java (Doc ID 2521131.1)

Last updated on JULY 28, 2019

Applies to:

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

Symptoms

While printing item tickets, if MSOB (Multiple Sets of Books) setting is enabled, supplier organization details are fetched based on organization ID which caused performance slowness.

The following query is routinely the single highest resource consumer in the database.


Every ticket print causes this query to execute

Cause

To view full details, 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 a vibrant support community of peers and Oracle experts.