My Oracle Support Banner

Full Table Scan Against The PACKITEM_BREAKOUT Table (Doc ID 1679267.1)

Last updated on JULY 10, 2017

Applies to:

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


Performance issue is observed in integrating receipt message as application is running full table scan against PACKITEM_BREAKOUT table.

Instructions to Re-create

  1. Create PO (ORDLOC Locations as WH) in RMS.
  2. Allow PO to be sent to external WH system.
  3. Receive Receipt message from external WH system (i.e. xreceipt RIB) for all items to one of the WH's on the PO.


To view full details, 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 a vibrant support community of peers and Oracle experts.