Technology Stack - EBS (MOSC)

MOSC Banner

Oracle Forms 10g FRM-40831 error

edited Aug 20, 2021 11:06AM in Technology Stack - EBS (MOSC) 3 commentsAnswered

Hi

I'm having trouble with "FRM-40831 Truncation occurred, value too long for field" error.

The error started to appear once test environment Oracle App Server and OS (windows) NLS was set to AMERICAN_AMERICA.AL32UTF8.

In production where the field does not give error it is set to ESTONIAN_ESTONIA.BLT8MSWIN1257.

Both underlying databases are AMERICAN_AMERICA.AL32UTF8.

The field length in question shows max length 30 chars and data length semantics is set to null (in both environments).

The length of the data from the database that goes into the text field is 33 chars.

The data itself has some estonian specific characters like "ö" and couple of "/" and spaces.

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

EBS TechStack Tags

Instructions for posting

×

1. Select a discussion category from the picklist.


2. Enter a title that clearly identifies the subject of your question.


3. In the body, insert detailed information, including Oracle product and version.


Please abide by the Oracle Community guidelines and refrain from posting any customer or personally identifiable information (PI/CI).


Cloud / Fusion customers - Our Cloud community has moved! Please go to Cloud Customer Connect .


New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center