My Oracle Support Banner

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 NOVEMBER 07, 2018

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

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Symptoms
Changes
Cause
Solution


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.