My Oracle Support Banner

Unexpected OFFER_COND_MERCH_ID Published By BDI Promotions Flow When Cancelling An Item From Offer (Doc ID 2765551.1)

Last updated on OCTOBER 28, 2022

Applies to:

Oracle Retail Pricing Cloud Service - Version 19.0 and later
Information in this document applies to any platform.


When cancelling an item from an active offer, OfferCondMerchCancel message is referencing a new OFFER_COND_MERCH_ID (primary key) which was never sent before and generates data inconsistency in downstream systems.

Steps to reproduce: 

1.Create and approve an offer having more than one Item.
2.Make it active.
3.Once active, go to the offer and cancel one of the items.
4.Run the BDI promotions export process.


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

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