My Oracle Support Banner

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

Last updated on FEBRUARY 03, 2019

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

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document
Symptoms
Cause
Solution
References


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