My Oracle Support Banner

R12/ 11i: OIE: How Is The Exchange Rate Date Determined When Exporting / Importing an Expense Report into Accounts Payable ? (Doc ID 1495460.1)

Last updated on DECEMBER 03, 2019

Applies to:

Oracle Internet Expenses - Version 11.10.5.2 to 12.1.3 [Release 11 to 12.1]
Information in this document applies to any platform.

Goal

When exporting a foreign currency expense report from Internet Expenses to Payables, how is the default exchange rate date determined
to convert the reimbursement amount to functional currency amount ?

It will use the date of the related expense line in the expense report.

Is it possible to amend the setup so that the default exchange rate and date are based on the GL date entered in the Expense Report Export program ?

Example :
Ledger Functional Currency is EUR

Expense Report Reimbursement Currency RUB
Expense Report Line Receipt Currency USD Line Currency Code RUB

The Start Date / End Date for the expense report line are both 22/08/12
The Expense Report Header has DEFAULT_EXCHANGE_RATE 0.025185111 and DEFAULT_EXCHANGE_DATE 22/08/12 to convert between RUB and EUR.

Is it possible to set the default exchange rate date (to convert between RUB and EUR) to the GL Date at the time the Expense Report Export program is run ?
 

Solution

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
Goal
Solution


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