My Oracle Support Banner

Posting Table Shows Wrong Exchange Rate (Doc ID 2256540.1)

Last updated on FEBRUARY 03, 2019

Applies to:

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

Symptoms

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.

Changes

 

Cause

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
Symptoms
Changes
Cause
Solution
References


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