My Oracle Support Banner

Performance Issue on ORDER_RCV_SQL Package (Doc ID 1626652.1)

Last updated on FEBRUARY 18, 2019

Applies to:

Oracle Retail Merchandising System - Version 13.2.5 and later
Information in this document applies to any platform.


Performance issue on ORDER_RCV_SQL Package

Steps to Recreate

  1. Shut down the RIB Receiving topic.
  2. Queue up several hundred RIB Receiving messages.
  3. Start up the RIB Receiving topic. 
  4. Note the amount of time spent in cursor C_PARENT_SHIPMENT of GET_SHIP_INFO function of  ORDER_RCV_SQL package.


To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.