APPLIES TO:

Oracle Inventory Management - Version: 11.5.10 to 12.1.3 - Release: 11.5 to 12.1
Information in this document applies to any platform.
FORM:RCVTXERT.FMB - Enter Receiving Transactions GUI

SYMPTOMS

For Purchase orders created in foreign currency that have Invoice match option set to 'Receipt', the currency conversion date for the DELIVER transactions get defaulted from the PO instead of the RECEIVE transaction.
The currency conversion date for the RECEIVE transaction is defaulted correctly as per the receipt date.
This issue occurs only for POs with shipments having multiple distributions.

Steps
------
The issue can be reproduced at will with the following steps:
1. Create and approve PO in foreign currency with Match Approval Level =
3-Way and Invoice Match Option = Receipt; Create Multiple distributions
1.1 At header level
      Currency = ZAR
      Rate Type = Corporate
      Rate Date = 11-JAN-2010
      Rate = .496163

1.2 At line level
One time item

1.3. At Shipment level
Match Approval Level = 3-Way
Invoice Match Option = Receipt
Receipt routing = Standard Receipt

1.4 At distribution level
create 2 distributions for shipment with Expense destination

2. On Enter Receipts form RCVRCERC When doing receiving it is possible to
change rate date
At Line level
Currency tab
Rate date is defaulting to today date
   Currency = ZAR
   Rate Type = Corporate
   Rate Date = 20-OCT-2010

Change rate date to 20 AUG 2010
   Rate Date = 20-AUG-2010
   Rate = .502417

So receive transaction has in rcv_transactions table
Currency_Code        ZAR
Currency_Conversion_Type    Corporate
Currency_Conversion_Rate    .502417
Currency_Conversion_Date    08-20-2010 00:00

3. On Enter Receiving transactions form RCVTXERT, when doing Deliver
transaction it is not possible to change rate date
but when splitting the distribution lines system it is not taking the rate
that has been used for the receipt.
Receiving Transactions form shows in Currency tab
multiple distributions
Quantity        Currency   Rate Type   Rate Date   Rate
.01    (+ sign) ZAR        Corporate   20-AUG-2010 .502417
.005            ZAR        Corporate   11-JAN-2010 .502417
.005            ZAR        Corporate   11-JAN-2010 .502417

--so the Rate Date is defaulting from PO exchange rate date
(but the Rate is the PO Receipt rate)

Once RVCTP is run
The deliver transactions have in rcv_transactions table
Transaction_Type    DELIVER
Currency_Code        ZAR
Currency_Conversion_Type    Corporate
Currency_Conversion_Rate    .496163
Currency_Conversion_Date    01/11/2010 00:00
Routing_Header_Id    1

so there are differences between receive and deliver transactions
which should not exist.

CAUSE

Logic used to default the currency conversion date for match option 'Receipt' was same as logic for match option 'PO', causing incorrect date derivation.

This is explained in the following bug:
Bug 7364535 - Wrong Currency Conversion Date When Doing Th

SOLUTION

For 11.5.10:
Apply Patch 7391299.

Issue is fixed in files:
RCVRCCUR.pld 115.10.11510.8
RCVCOTRX.pld 115.201.11510.51

For 12.0:
Fixed Files:
RCVCOTRX.pld - 120.32.12000000.31
RCVRCCUR.pld - 120.1.12000000.3

However, there is no one-off patch available for this issue. The fix is included in Patch 8478486:R12.INV.A - Oracle Inventory and Receiving (PO): Release 12.0, Rollup Patch 7

REFERENCES

BUG:10221994 - DELIVER TRANSACTIONS DO NOT HAVE RATE DATE / EXCHANGE RATE OF RECEIVE TXN