E1: 41: Item Location Extraction (R41021ZX) Produces Numerous Conversion Errors AFter 9,999 Records Populated

(Doc ID 2381929.1)

Last updated on APRIL 09, 2018

Applies to:

JD Edwards EnterpriseOne Inventory Management - Version 9.1 and later
Information in this document applies to any platform.

Symptoms

Interop UBE R41021ZX, Item Location Extraction, produces numerous conversion errors. The customer used R41021ZX to bulk export Item Location data. The report stops populating the F41021Z1 table once 9999 records have been extracted and the job log starts recording errors. Looking at the results in F4102Z1, it appears EDLN is incremented start at 1000 and ending at 9999000. No more records can be inserted once the EDLN counter hits 10,000,0000.

The joblog errors indicate: OS400QL016 - ExecuteSQLRequest: QSQLMSG *LIBL - SQL0406 - Conversion error on assignment to column &2.

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