Currency Conversion is Not Happening for PRIM_TRAN_AMOUNT in IM_FINANCIALS_STAGE Table During Receipt Write Off (Doc ID 2002262.1)

Last updated on NOVEMBER 17, 2015

Applies to:

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

Symptoms

When a receipt is written off, PRIM_TRANS_AMOUNT value in IM_FINANCIALS_STAGE table is getting posted in terms of Purchase Order (PO) currency instead of location currency.

Steps to Recreate:
1. Create a Purchase Order (PO) against a location having currency different from primary currency.
2. Receive the PO fully.
3. Notice that TRAN_DATA postings are created correctly.
4. Make sure that the receipt is eligible for write off.
5. Run reimreceiptwriteoff batch and notice that the value for PRIM_TRANS_AMOUNT value in IM_FINANCIALS_STAGE table is getting posted in terms of Purchase Order (PO) currency instead of location currency.

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