Performance Issue on ORDER_RCV_SQL Package (Doc ID 1626652.1)

Last updated on JULY 11, 2017

Applies to:

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

Symptoms

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.



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