"RPMtoORPOSPublishBatch.sh" And "RPMtoORPOSPublishExport.sh" Extracts the Same Pricing Information to Point of Service with Every Execution on the Same Day

(Doc ID 726963.1)

Last updated on OCTOBER 12, 2017

Applies to:

Oracle Retail Price Management - Version 12.0.6 to 12.0.8 [Release 12.0]
Information in this document applies to any platform.
***Checked for relevance 25-July-2013***

Goal

Retail Price Management (RPM) was designed for nightly price changes to flow to a Point Of Service (POS) system. A batch script exists that calls a SQL statement to pull price changes out of RPM and it sends a price change file to POS.  This script pulls all price changed effective today going forward.

If this program is run several times a day (e.g. every 10 minutes) so that emergency price changes can go to POS, then it seems all price changes will go to POS several times a day.

Need to know how to have the emergency price changes processed every 10 minutes without re-sending a complete picture of all future price changes.

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