My Oracle Support Banner

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.

Symptoms

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.

Changes

 

Cause

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
Symptoms
Changes
Cause
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.