My Oracle Support Banner

Wrong Exchange Rate And Exchange Date Being Used For Rcv_transactions in Foreign Currencies for PO (Doc ID 1307548.1)

Last updated on OCTOBER 02, 2023

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


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.




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

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