Complex Promotions Created or Modified are Not Getting Published to POS

(Doc ID 2343596.1)

Last updated on JANUARY 02, 2018

Applies to:

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

Symptoms

Complex promotions created or modified are not getting published to POS.

Steps To Recreate:

1. In RPM_SYSTEM_OPTIONS set DO_NOT_RUN_CC_FOR_CP_APPROVAL to 1 and CC_DIRECT_PAYLOAD_POPULATION to 1.
2. Create a complex promotion and approve it.
3. Entries are made in RPM_PROMO_DTL_PAYLOAD, RPM_PRICE_EVENT_PAYLOAD, RPM_PROMO_ITEM_PAYLOAD and RPM_PROMO_LOCATION_PAYLOAD. But no entries in RPM_PROMO_ITEM_LOC_SR_PAYLOAD which is expected.
4. Run RPMtoORPOSPublishBatch.
Note that RPM_ORPOS_COMPLX_PROMO_PUBLISH table is not populated for this promotion.

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