Item_mfqueue Stops When Having A Lot Of Items With Status ‘W’orksheet

(Doc ID 2210681.1)

Last updated on FEBRUARY 16, 2017

Applies to:

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


When attempting to publish item from ITEM_MFQUEUE having huge volume of worksheet records, performance deadlock is observed.

Steps to recreate:
1. Populate ITEM_MFQUEUE with huge volume of records with Items in worksheet status. This can be achieved by -
   a. Create a parent item.
   b. Create child items for each of the item differentiators.
   c. Attach UDAs at parent item and default to child items.

2. Notice that ITEM_MFQUEUE record publication stops even for Approved items' messages.




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