My Oracle Support Banner

Line Flow -Generic, With Repricing At Fulfillment Not Update Price Based On Pricing Modifier (Doc ID 1620688.1)

Last updated on AUGUST 20, 2020

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


To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.