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 FEBRUARY 04, 2019

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.

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
Cause
Solution
References


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