Wrong Exchange Rate Being Posted in IM_AP_STAGE_HEAD For Document When Using Foreign Currency Supplier

(Doc ID 2340456.1)

Last updated on DECEMBER 19, 2017

Applies to:

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

Symptoms

Wrong Exchange rate posted in IM_AP_STAGE_HEAD for documents by using foreign currency supplier.

When stand alone documents (Non-merch, Debit memo, Credit memo documents) are created in ReIM without referring any order number for foreign currency supplier, IM_AP_STAGE_HEAD.EXCHANGE_RATE is getting posted as 1.

Steps To Recreate:

   1. Create a stand alone document (Non-merch, Debit memo, Credit memo documents) in ReIM without giving order number for supplier having currency code different than your local currency.
   2. In IM_DOC_HEAD note that exchange rate will be equal to that in your CURRENCY_RATES.EXCHANGE_RATE.
   3. Run ReIMPosting Batch.  Notice that EXCHANGE_RATE in IM_AP_STAGE_HEAD has been posted with value 1.

Changes

 

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