Promotions Publishing Over And Over Again
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