Item_mfqueue Stops When Having A Lot Of Items With Status ‘W’orksheet
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