Promotion Cancellation Does Not Update RPM_PROMO_ITEM_LOC_EXPL.DETAIL_END_DATE
(Doc ID 2056872.1)
Last updated on FEBRUARY 19, 2021
Applies to:Oracle Retail Price Management - Version 13.1.7 and later
Information in this document applies to any platform.
When cancelling a large promotion component, that many promo details remain in Pending Cancel state with the end_date set to (end of) vdate, but the RPM_PROMO_ITEM_LOC_EXPL.DETAIL_END_DATE is not updated (it remains set to the original promotion end date).
This results in subsequent promotions failing conflict checking because they "overlap" with the *cancelled* promotion.
Steps to Reproduce
1. Create two promotion components/details, one for many item-locations and one for a single location.
2. Approve the promotion and run the batches PEE, PEERMS.
3. Cancel the promotions before the RPM_PROMO_DTL.END_DATE. Note that promotion detail is in Pending Cancel state and end_date of promo detail is trunc(vdate).
4. Note that RPM_PROMO_ITEM_LOC_EXPL.DETAIL_END_DATE for the large promotion is still set to the original end date, while the detail_end_date for the small promotion is trunc(vdate).
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!