Reimediinvupload Batch Fails With an Error : Field Must Be Greater Than Zero:EDIUpload. Line: Total Cost

(Doc ID 2311055.1)

Last updated on OCTOBER 08, 2017

Applies to:

Oracle Retail Merchandising System - Version 14.0.2 and later
Information in this document applies to any platform.

Symptoms

 When EDIDLINV batch is executed it is populating the total order cost to zero .As a result of this Reimediinvupload batch fails with below error:


Steps to Reproduce:

  1. Create a Return To Vendor (RTV) for a regular item having zero unit cost.
  2. Approve the RTV and ship it.
  3. Verify that the invoice is generated in INVC_HEAD table.
  4. Run the EDIDLINV batch to extract the invoice.
  5. Upload the file into ReIM, batch aborts with "Field must be greater than zero" error.

 

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