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

Last updated on JUNE 01, 2016

Applies to:

Oracle Inventory Management - Version 11.5.10.0 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***

Symptoms

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.

Steps:
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.
 

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