Notes Greater Than 255 Characters in Demantra are not Saved Even Though There are no Error Messages Presented to the User (Doc ID 1110614.1)

Last updated on MARCH 28, 2016

Applies to:

Oracle Demantra Deduction and Settlement Management - Version 7.1.0.1 to 7.2.0.3 [Release 7 to 7.2]
Information in this document applies to any platform.

Symptoms


Client on v7.1.0.1 enters in a note into a Demantra worksheet that is > 255 characters and receives no notice that it failed to save (re-running the worksheet reveals that the note is gone).

The following error is observed in the Collaborator.log

2010-05-19 16:03:26,114 jrpp-10 ERROR appserver.error :: appserver.error
java.sql.SQLException: ORA-12899: value too large for column "XXX"."NOTES"."NOTE_DESC" (actual: 263, maximum: 255)

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