E1: 49: P4981 - SQL Exception Message Due To >999 F0911 JELNs Created By R4981 (Doc ID 1954688.1)

Last updated on JUNE 23, 2016

Applies to:

JD Edwards EnterpriseOne Transportation Management - Version 9.0 to 9.0 [Release 9.0]
Information in this document applies to any platform.

Symptoms

9.0 version, Transportation


When trying to do a freight adjustment via P4981 against an FT document
number that has more than 999 F0911 line numbers (JELN > 999), P4981 can not
perform the freight adjustment and issues the following error Message:
SQL_EXCEPTION_OCCURRED An SQL exception occurred: Data truncation.

ERROR
-----------------------
JAS_MSG346: JAS database failure: [SQL_EXCEPTION_OCCURRED] An SQL exception occurred: Data truncation



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