Wrong Currency Conversion Date When Doing The Delivery (Doc ID 738251.1)

Last updated on JANUARY 24, 2011

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

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