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