Injector Ignores Currency Code Provided in the Staging Table for a Link Code Price Change
Last updated on JULY 14, 2017
Applies to:Oracle Retail Price Management - Version 13.2.5 to 13.2.9 [Release 13.2]
Information in this document applies to any platform.
In Oracle Retail Price Management (RPM) 13.2.x, the Price Injector ignores the Currency Code provided in the staging table for a link code price change. The regular price change injector forces a currency code when the price change is for a link code; however, the injector will not use the currency code provided to filter and will not create the price change with the provided currency code. Rather, it gets the currency code from the zone/location, which is incorrect.
Due to the nature of link codes, when you enter a price change for link codes in the online RPM application, a currency code is required. Because link codes can include multiple items spanning multiple locations, there needs to be a means for filtering which zones/locations the price change should be created for.
Steps to Reproduce:
- Upload a record into the RPM_STAGE_PRICE_CHANGE table for a link code price change at a location. Be sure to include a currency code that DOES NOT match the currency code for the location.
- Run the injectorPriceEventBatch.sh to process the staged price change record and create a price Change (in RPM_PRICE_CHANGE).
- Notice that the record in the staging table (RPM_STAGE_PRICE_CHANGE) has been successfully processed and a price_change_id now exists.
- Look at the price change created by the injector in RPM and notice that the currency on the price change is from the location. It does not match the currency in the staging table, which should be used for filtering.
- Notice that if you try to key the same price change in the online application, RPM will not allow you to do so. Once you enter the link code and the currency code, all zone/locations that do not match the currency code will be filtered. You received a ‘No data matching your search exists’ message if you try to use a location with a currency other than the currency entered on the link code price change.
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