Often Executed SQL Retrieving Many Records Into Java
(Doc ID 2521131.1)
Last updated on DECEMBER 04, 2019
Applies to:Oracle Retail Store Inventory Management - Version 14.1 and later
Information in this document applies to any platform.
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
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!