My Oracle Support Banner

E1: 41: P41024 Work With Item Locations Writes Error "Convertchartodouble Failed" in jde.log when Deleting a Secondary Location (Doc ID 2878070.1)

Last updated on FEBRUARY 28, 2024

Applies to:

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

Symptoms

When deleting a secondary location in P41024 the following errors can be seen in the jde.log even when the delete is successful.

3166/478 WRK:TJ5903946_80000000_P41024     Mon Jun 20
13:43:33.976848 jdb_conv.c719
ConvertCharToDouble failed. Table "F43121", Column "PRUOPN"

3166/478 WRK:TJ5903946_80000000_P41024     Mon Jun 20
13:43:33.977232 jdb_conv.c719
ConvertCharToDouble failed. Table "F43121", Column "PRAOPN"

3166/478 WRK:TJ5903946_80000000_P41024     Mon Jun 20
13:43:33.977304 jdb_conv.c719
ConvertCharToDouble failed. Table "F43121", Column "PRFAP"

The issue was reported for the AS400 iSeries however, Linux is encountering the same errors.

Replication steps:

1) Inquire on item and location select the record and choose delete.

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.