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

Last updated on SEPTEMBER 01, 2016

Applies to:

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


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) 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.

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: 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



Cause

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