E1: 31P: PRP Ends On AS400 with MCH1210 ESCAPE 40 CONVERTTOBULKINSERTBUFFER Error (Doc ID 2058379.1)

Last updated on DECEMBER 28, 2015

Applies to:

JD Edwards EnterpriseOne Requirements Planning - Version 9.1 to 9.1 [Release 9.1]
Information in this document applies to any platform.

Symptoms

On : 9.1 version, MRP

R3482 and R3483 look like are still processing,with status "P", in WSJ in E1 but on the iSeries they are dead. Looks like the issue may have started after upgrade from TR 9.1.4.7 to 9.1.5.2, as the two UBEs worked fine in previous 9.1.4.7.  The two UBEs work fine on the fat client. The issue is just with the iSeries.  

ERROR
-----------------------
MCH1210 Escape 40 ConvertToBulkInsertBuffer statement 75 receiver Value too small to hold result.

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
For ETO project planning, PRP, over data items with quantity on hand (such as 12606000.000000) in excess of 6 digits, system attempts a Msg Type A insert with description “Allocate Inventory to Project”.  
The insert fails.  
Error above is issued and job ends abruptly. 

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