When Cancelling Promo Component The User And Date Is Not Captured In RPM_PROMO_DTL table (Doc ID 2138907.1)

Last updated on JULY 05, 2017

Applies to:

Oracle Retail Price Management - Version 14.1.1 and later
Information in this document applies to any platform.

Symptoms

APPROVAL_DATE and APPROVAL_ID not populated for Cancelled promo detail records.

  1. Create a simple promo at parent item/zone or Department/zone level and approve it.
  2. Cancel the promo for some of the Item/loc combinations.
  3. Query RPM_PROMO_DTL and note that APPROVAL_DATE and APPROVAL_ID is not updated.
  4. There is no way of knowing by whom or when the promo was approved.

Changes

 

Cause

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 hundreds of Community platforms