My Oracle Support Banner

WS: 42: Due to the Size of the Variable Field $NEWH Error RNX9001 Generates in A9.3.1 and Above (P4205) (Doc ID 2595123.1)

Last updated on OCTOBER 02, 2019

Applies to:

JD Edwards World Sales Order Management - Version A9.3 cume 1 and later
Information in this document applies to any platform.


In A9.3.1 and above, an issue is being encountered due to the size defined for the variable field $NEWH added to Confirm Shipments (P4205).

Some customized code was added to Confirm Shipments (P4205) and during testing, a pristine line of code generated the error:

  RNX9001 - The target for a numeric operation is too small to hold the result.

The line of code that crashed is:

1267.70 C Eval $NEWH = LIHCOM + @LQ($Y)

Both LIHCOM and @LQ are defined as 15 0

It crashed because LIHCOM contained a value of 1590000, which is not an unreasonably large number for a field defined as 15 0 field. However, $NEWH can only handle a number up to 999999 as it is defined as 15 9

This is the only line of code where $NEWH is receiving a value, the other two instances are the declaration and a conditional statement at line 1268.50 to issue the warning when PO 15 is set to "1" and the conditions have been met.

The program will always crash as soon as LIHCOM or @LO or the sum of the 2 fields exceeds 999999.

RNX9001 - The target for a numeric operation is too small to hold the result at statement 1267.70




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.