My Oracle Support Banner

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

Last updated on NOVEMBER 22, 2019

Applies to:

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


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.


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

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