Reimposting Batch Adjusting Amounts Incorrectly When Header Doesn't Match Detail Lines (Doc ID 2268337.1)

Last updated on MAY 23, 2017

Applies to:

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

Symptoms

reimposting batch adjusting amounts incorrectly when header doesn't match detail lines
Steps:
Make sure you have CURRENCY_COST_DEC as 2 for USD in im_currency_locale.

1- Create an Order
2- Create an obligation (non-merch) for the order header with the below 2 lines
  i- component 1 value 234.625
  ii- component 2 value 66.2259
Total as 300.8509 USD.
4- Download invoice using edidlinv
5- upload invoice to reim using reimediinvupload
6- Check im_doc_head for the total 300.8509
7- Check im_doc_non_merch for the 2 components with the above values
8- Run reimposting

Result:
Reimposting puts 2 warnings in IM_POSTING_DOC_ERRORS:
(A/P Header - total detail amounts) <= balancing tolerance of 1. IM_AP_STAGE_DETAIL entry for TRAN_CODE NMRCH, LINE_TYPE_LOOKUP_CODE MISCELLANEOUS, and SEQ_NO 1002 was adjusted by .01 from the original amount of 234.63.
(A/P Header - total detail amounts) <= balancing tolerance of 1. IM_AP_STAGE_DETAIL entry for TRAN_CODE NMRCH, LINE_TYPE_LOOKUP_CODE MISCELLANEOUS, and SEQ_NO 1002 was adjusted by .02 from the original amount of 234.64.

Obviously in the first line the adjustment is correct of 0.1, but it is added instead of subtracting so the difference grew by 0.2, as per the second line.
As per im_ap_stage_detail the amounts are 234.66 and 66.23

Changes

 

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