Discrepancies Between ReIM Invoice Total and ReIM Invoice Lines
Last updated on AUGUST 17, 2016
Applies to:Oracle Retail Invoice Matching - Version 18.104.22.168 and later
Information in this document applies to any platform.
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_DETAIL table contains 4 items with values:
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.
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