My Oracle Support Banner

MNT File Created By PCS Has MIN_QTY=1 Even For UOM Items (Doc ID 2960135.1)

Last updated on JULY 07, 2023

Applies to:

Oracle Retail Xstore Office Cloud Service - Version 22.0 and later
Oracle Retail Pricing Cloud Service - Version NA and later
Oracle Retail Merchandising Foundation Cloud Service - Version NA and later
Information in this document applies to any platform.

Symptoms

In XOCS V21 Integrated with MFCS:

Users are seeing issues with the firing of promos created in RPM due to the MinQty defaulting to 1. For Unit of measure items that use weight such as KG, the promotion doesn't trigger since the minimum quantity set for the promotion is 1 and .500 for example is less than 1.

Steps to Reproduce:

1. Create promotion in PCS system with KG item
2. Run RPM_PROMOTION_CACHE_ADHOC_PROCESS
3. Wait 30 minutes interval for XOCS to pick up the promotion
4. When deployment is downloaded to Xstore POS run dataloader2.sh/.bat
5. Check the table PRC_DEAL_ITEM
6. MIN_QTY is set to 1

Expected: When an applicable UOM item is sold, the promotion is still triggered

Actual: Since the min quantity is defaulted to 1 on creation, the promotion is not triggered for UOM items.

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.