Last updated on JULY 28, 2017
Applies to:Oracle Advanced Pricing - Version 12.1.3 and later
Information in this document applies to any platform.
We use pricing modifiers which compose the price of our products based on some characteristics, and additionally for some customers we need to apply a formula over the price, to convert price from USD to local currency ( COP in case of Colombia). This because for those customers we manage the prices in USD, but orders and invoices need to be generated in Local currency, so we need to get price conversion to local currency. For this we have created a pricing attribute: USD TO COP, which uses following funtion to look for the right exchange rate to use: GL_CURRENCY_API.GET_RATE('USD','COP',SYSDATE,'1165').
Based on this price gets converted to Local currency when entering the order, however we need order to get repriced when shipping it, because we need to use exchange rate corresponding to shipping date.
Right now users are manually launching the repricing function from the order, before shipping it, and that is properly updating price, however that is very time consuming task as we manage too many orders and shipments per day. So we are looking for a way to get the order repriced at shipping. We did a test using the seeded Line Flow - Generic, with Repricing at Fulfillment work flow, but price remained the same, instead of being updated to use the exchange rate of the shipping date
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
Million Knowledge Articles and hundreds of Community platforms