E1: 17: R17731 Fails in Decimal Environment of More than 5 Decimals for QTYINV (Doc ID 1933290.1)

Last updated on NOVEMBER 17, 2016

Applies to:

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

Symptoms

9.0
8.98.4.2

UBE R17731 ends in error and is getting this error message in the logs:

OS400QL009 - OpenSQLCursor:Open SQL cursor: Crsr81. QSQLMSG *LIBL - SQL0302 - Conversion error on variable or parameter &2

and further down, it receives these errors:

34783/1292 MAIN_THREAD Wed Oct 1 10:39:45.616336 jdecache.c1502
CAC0001025 - Application code leaked 5 caches which were detected when freeing environment JPY900 (EnvHandle SPP:0000 :0000 :0:80:11) for user JCALDWELL.
34783/1292 MAIN_THREAD Wed Oct 1 10:39:46.338912 jdb_ctl.c1810
JDB4100005 - Application code leaked 1 data pointers which were detected when freeing environment JPY900 (EnvHandle SPP:0000 :0000 :0:80:11) for user JCALDWELL.

turned on debug logs and re-run the R17731 UBE and the SQL statement that is failing is this:
SELECT * FROM CRPDTA/F3111 WHERE ( ( WMDOCO = 2238881.000000 AND WMQNTA <> 99999999999990000.000000 AND WMCOMM <> SPACE ) ) ORDER BY WMUKID ASC

It appears that the WMQNTA parameter is too large for the WMQNTA field in the F3111. Is this what is causing the errors? We tried applying ESU JL22572, but we get the same error. I had the user try just one work order instead of multiple, and he gets the same error message. Please advise on how to resolve these errors so the UBE completes successfully. I will attach the JDE and JDEDEBUG logs as well as print screens of his Processing Options and Data selection. Thank you.

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