My Oracle Support Banner

Promotion ID is Incorrectly Saved in Database Table for Fixed Deals Referenced Promotions (Doc ID 2736881.1)

Last updated on DECEMBER 27, 2020

Applies to:

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


Promotion ID is incorrectly saved in Database table "DEAL_PROM" for fixed deals referenced promotions.

When creating a fixed deal and adding a promotion as a reference, the list of values is based on existing Price Cloud Service (PCS) promotions. When saving this deal, the link deal-promotion is saved in table DEAL_PROM but the PROMO_ID saved in the table is different from the one seen in the screen and from PCS.

Steps To Recreate:
1- create fixed deal
2- add promotion to the fixed deal
3- search promotion from list of values (e.g. select promo id 150)
4- saved fixed deal.
5- check table DEAL_PROM for the above deal and confirm the promo_id is not 150.


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.