Incorrect Calculation of PRIM_TRANS_AMOUNT Column in IM_FINANCIALS_STAGE

(Doc ID 2003249.1)

Last updated on AUGUST 17, 2016

Applies to:

Oracle Retail Invoice Matching - Version 13.2.4 and later
Information in this document applies to any platform.


We find that the calculation of PRIM_TRANS_AMOUNT column in IM_FINANCIALS_STAGE is incorrect.  The current calculation in the system: PRIM_TRANS_AMOUNT = transAmount / currencyRate

Steps to Reproduce:

  1. Create a purchase order (PO) and add 1 item.
  2. Ship and receive the item.
  3. Set CLOSE_OPEN_SHIPMENT_DAYS to 1 for the supplier of the PO.
  4. Change the vdate of the system (vdate + 10 days).
  5. Run receiptwriteoff batch.
  6. Notice that PRIM_TRANS_AMOUNT computation is incorrect (amount/exchange rate).


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