21328091 FRM-40831: Truncation Occured: Value Too Long For Field TARGET (Doc ID 2037808.1)

Last updated on MARCH 08, 2017

Applies to:

Oracle Quality - Version 12.2.4 and later
Information in this document applies to any platform.

Symptoms

On : 12.2.4 version, SUPPORT

When attempting to enter quality results the following error occurs.

ERROR
-----------------------
FRM-40831: Truncation occured: Value too long for field TARGET


STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Responsibility: Quality or WIP
2. When doing a move transaction or directly enter quality results
3. See that the above error occurs.

Issue is not due to Setup.The Character limit of below Item is hardcoded as 30 and the Specification is having the Target value of 150 characters.

Form : QLTRSMDF.fmb
Block : Q_SPECS
Item : TARGET
Properties : Datatype- char,Maximum Length - 30.

Form : WIPTXSFM.fmb
Block : Q_SPECS
Item : TARGET
Properties : Datatype- char,Maximum Length - 30

This is the issue at form Maximum limit is set to 30, where it should have been 150 characters.

Need to change the Maximum Length for the item TARGET as 150 which is correct as per the specification and also the Table QA.QA_SPEC_CHARS which is having length of 150 characters.

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