Discrepancies Between ReIM Invoice Total and ReIM Invoice Lines (Doc ID 1595561.1)

Last updated on AUGUST 17, 2016

Applies to:

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

Symptoms

The issue described in this document is known to Oracle, and a fix already scheduled for future release.
This article will be updated as official patch information becomes available.

 
In Oracle Retail Invoice Matching (ReIM) 13.1.x, when posting complex deal related documents via ReIM posting, rounding is applied at that time.  The rounding is causing discrepancies between invoice total and invoice lines.


Steps to Reproduce:

1. Set im_currency_locale where currency_code = ‘GBP’ and currency_cost_dec = 2.
2, Create complex deal data in Retail Merchandising System (RMS).
3. Run related batches in RMS to get the data into STAGE complex deal tables.  Data appears as in the following example:

    STAGE_COMPLEX_DEAL_HEAD:
     28.1357

    STAGE_COMPLEX_DEAL_DETAIL table contains 4 items with values:
     10.0948
     8.4515
     6.8097
     2.7797

4. Run ReimComplexDealUpload batch.
5. Run Financial Posting batch.
6, Check the results in the following ReIM staging tables and notice that amounts do not match.

    Actual: IM_AP_STAGE_HEAD and IM_AP_STAGE_DETAIL amounts are not equal.
    Expected:
IM_AP_STAGE_HEAD and IM_AP_STAGE_DETAIL amounts should be equal.

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