My Oracle Support Banner

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!

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