Posting Table Shows Wrong Exchange Rate (Doc ID 2256540.1)

Last updated on APRIL 24, 2017

Applies to:

Oracle Retail Invoice Matching - Version 15.0 and later
Information in this document applies to any platform.

Symptoms

Posting table are showing incorrect Exchange rate.

Steps To Recreate:

Case 1: Without currency change

1. Created document with Supplier Currency USD

Supplier Currency USD
Location Currency QAR
Primary Currency QAR

2. See that exchange rate comes to 0.27

3. Save the document and run the posting batch.

4. See that the exchange rate shows as 3.703703704 in IM_AP_STAGE_HEAD table . It does (1/.27)= 3.7


Case 2 : With currency change

1. Created document with Supplier Currency USD

Supplier Currency QAR
Location Currency QAR
Primary Currency QAR
Changed Currency USD


2. See that exchange rate comes to 1.

3. Change the currency to USD.

4. See that exchange rate comes to 3.704

5. Save the document and run the posting batch.

6. See that the exchange rate shows as 0.27 in IM_AP_STAGE_HEAD table . It does (1/3.704)= .27.

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