Wrong Exchange Rate And Exchange Date Being Used For Rcv_transactions in Foreign Currencies for PO

(Doc ID 1307548.1)

Last updated on OCTOBER 25, 2017

Applies to:

Oracle Inventory Management - Version to 12.1.3 [Release 11.5.10 to 12.1]
Information in this document applies to any platform.
Form:RCVRCERC.FMB - Enter Receipts
Executable:RVCTP - Receiving Transaction Processor
Executable:POXPOIV - Pay On Receipt AutoInvoice

***Checked for relevance on 30-SEPT-2014***


Find Purchase Orders receipts in foreign currency have a wrong date and wrong rate.
As a consequence when matching an invoice to a Receipt and/or running Pay on Receipt the wrong currency rate is being used.

Expected Behavior:
Expect currency rate and currency date at the time of receipt to be used.

The issue can be reproduced at will with the following steps:

1. Enter and approve purchase order in foreign currency on 13-JAN-2011
At shipment level ensure that Invoice Match Option is set to Receipt
1.1 At header level
      Currency = EUR
      Rate Date = 13-JAN-2011
      Rate = 3.1354
1.2  At Shipment level
  Invoice Match Option = Receipt

2. Receive the purchase order on Enter Receipts form on 27-FEB-2011. At this date
the conversion rate between functional currency and foreign currency has changed.

3. Run Pay on receipt .

4. The rate on the invoice has the rate of the Purchase Order not the actual rate in time of receipt.


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