Full Table Scan Against The PACKITEM_BREAKOUT Table
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
- Create PO (ORDLOC Locations as WH) in RMS.
- Allow PO to be sent to external WH system.
- Receive Receipt message from external WH system (i.e. xreceipt RIB) for all items to one of the WH's on the PO.
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