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.

Goal

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?

Solution

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