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.
Performance issue on ORDER_RCV_SQL Package
Steps to Recreate
- Shut down the RIB Receiving topic.
- Queue up several hundred RIB Receiving messages.
- Start up the RIB Receiving topic.
- 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!