Multi-currency Price List Takes The Wrong Conversion Rate

(Doc ID 1381510.1)

Last updated on JANUARY 31, 2018

Applies to:

Oracle Advanced Pricing - Version 12.1.3 and later
Oracle Order Management - Version and later
Information in this document applies to any platform.
Form:OEXOEORD.FMB - Sales Orders
Form:OEXOETEL.FMB - Quick Sales Orders
Multi Currency
Multi currency


On : 12.1.3 version, Price List

Find that a sales order line is not using the correct conversion rate.
It appears to be using the Corporate exchange rate.
The following order line exception messages are shown

Line processing messages are shown for all order lines.

Error(s) occrred in Oracle Pricing: No conversion rate found.
Required Action: For Oracle General Ledger conversion types, set up the conversion rate for the From Currency USD, To Currency CNY, Conversion Date 20-OCT-11, and Conversion Type 1000.

It is expected to use the newly defined exchange rate.
Conversion_type: 1000
user_conversion_type: Pricing Conversion

The issue can be reproduced at will with the following steps:
1. Setup the conversion daily rates
Responsibility: Order Management Super User (or equivalent)
Navigate to: Setup > Financials > Currencies > Rates > Daily
Custom rate defined as:
From: USD
Date: 01-JUL-2011
Type: Pricing Conversion
USD To CNY 6.79
CNY To USD: .147275405

select * from apps.GL_DAILY_CONVERSION_TYPES;
Conversion_type: 1000
user_conversion_type: Pricing Conversion

2. Setup the Multi-Currency Conversion List
Base Currency: USD
updated the Conversion Type on the Multicurrency Price List
and end date the old ONE.

2Curr Code Start Date End Date Conv Type Type Conv Date
CNY 01-JAN-09 30-JUN-11 1000 Fixed 01-JAN-10
CNY 01-JUL-11 1000 Fixed 01-JUL-11

Doing this the expected result will be that every Sales Order inserted in CNY Currency will use the new Pricing Conversion.

3. Sales Order Test
Responsibility: Order Management Super User (or equivalent)
Navigate to: Orders, Returns > Sales Orders
Tested with sales order: 81014857
Two order lines both with price list = Standard Price List..
Line one, item: 934-000049-001, List Price: 4361.65
The list price (in USD) has been calculated using the CORPORATE RATE and NOT the PRICING CONVERSION

Item USD PRICE Order Curr FX Rate FX Price
WRONG 934-000049-001 $ 675.00 CNY 6.463 4,361.65

RIGHT 934-000049-001 $ 675.00 CNY 6.79 4,583.25


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