Complex Promotions Created or Modified are Not Getting Published to POS
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.
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.
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