Promotions Publishing Over And Over Again

(Doc ID 2098614.1)

Last updated on JANUARY 22, 2016

Applies to:

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


In the package RPM_NO_RIB_PRICE_PUBLISH_SQL, the cursor C_ITEM_LOC_SR has the following statement in the where clause:

The " >= " is the problematic part.

When a new item/location is ranged it only creates the entries necessary for the item/locations ranged, but because of the greater than equal sign instead of just equal, it's pulling data for item/locations AFTER the range transaction and not just for the specific payload transaction.

Is this logic working as designed?


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