ReIM 16.0 - Getting Error While Consuming RTV Debit Memo EDI File When Total Cost Has Decimal Values

(Doc ID 2314183.1)

Last updated on OCTOBER 12, 2017

Applies to:

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

Symptoms

ReIM 16.0 - Getting error while consuming RTV debit memo EDI file when total cost has decimal values
While consuming the EDI file by running EDI Injector batch, getting error as DETAIL_COST-"Some of the Detail Cost is unaccounted for in the Total Cost" when we have decimal values in Total cost.

for an example:
RTV is created for Qty- 59.46, Unit cost - 171.921 but in the file Total cost is 10222.4227 for this qty and cost. But the system throws above error while consuming the same as the exact multiplication of this qty and cost will be 10222.42266(5 decimals)
And we cannot have 5 decimals in EDI file. So we had to reduce the qty and adjust the cost decimals manually in the file to consume the debit memo in ReIM.

Steps to reproduce:

1. Create an RTV with Qty and unit cost which will result in 5 digit TOTAL_COST value
2. Run EDIDLINV batch in RMS - EDI file will be downloaded
3. Consume the EDI file by running EDI Injector batch in ReIM
4. The record gets failed in ReIM Validation as Header total cost and Detail cost is not exactly matching(5th decimal difference)

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