Item_mfqueue Stops When Having A Lot Of Items With Status ‘W’orksheet
(Doc ID 2210681.1)
Last updated on FEBRUARY 03, 2019
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.
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!
In this Document