RPMtoORPOSPublishBatch.sh Batch Generates Wrong Change Type for Multi-Buy Promotion (Doc ID 2174311.1)

Last updated on APRIL 24, 2017

Applies to:

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

Symptoms

RPMtoORPOSPublishBatch.sh batch generates data into RPM_ORPOS_CMPLX_PROMO_PUBLISH table with wrong Change Type.

It was generated as "Buy$NorMoreOfXgetYatZ$off" instead of "Buy$NorMoreOfXforZ$off".


Steps to Recreate:

  1. Create a multi-buy promotion for "Buy $300 of item(s) from buy list and get $30 off".
  2. Approve the promotion and notice that payload tables are populated.
  3. Run RPMtoORPOSPublishBatch.sh and notice that Change_Type in RPM_ORPOS_CMPLX_PROMO_PUBLISH table was generated as "Buy$NorMoreOfXgetYatZ$off" instead of "Buy$NorMoreOfXforZ$off".


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