Multi-currency Price List Takes The Wrong Conversion Rate (Doc ID 1381510.1)

Last updated on MAY 01, 2023

Applies to:

Symptoms

On : 12.1.3 version, Price List

ACTUAL BEHAVIOR
---------------
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

ERRORS
---------------
Line processing messages are shown for all order lines.

Error(s) occurred 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.

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

STEPS
-----------------------
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
To: CNY
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
Name: USD MULTI CURRENCY CONVERSION
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: XXX
Two order lines both with price list = Standard Price List..
Line one, item: YYYY, 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 YYYY $ 675.00 CNY 6.463 4,361.65

RIGHT YYYY $ 675.00 CNY 6.79 4,583.25

Changes

Cause

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