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.

Symptoms

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.

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