Performance Issue on ORDER_RCV_SQL Package
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.
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