Product promotion with same product multiple time
When user is doing chnage of promotion dfrom Promotion 1 to Promotion2 whish are configured as shown below,
Promotion 1:
Business Line
Streamyx
BB Phone VAS
BB Phone VAS
Email
Hotspot
Hotspot
Promotion 2:
Business Line
Streamyx
BB Phone VAS
BB Phone VAS
Email
Hotspot
Hotspot
Expected Result:
2 BB Phone VAS and 2 Hotspot should have PROM_INTEG_ID, PROMOTION_ID, PROM_ITEM_ID
Actual Result:
Only one of BB Phone VAS and Hotspot have the PROM_INTEG_ID, PROMOTION_ID, PROM_ITEM_ID.
Is this is expected behavior that when a promotion is having a product multiple time and when it is replaced with another promotion which is also having that product multiple time then PROM_INTEG_ID, PROMOTION_ID, PROM_ITEM_ID columns will get values for only one product and other product will have these values as null.