My Oracle Support Banner

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 FEBRUARY 25, 2019

Applies to:

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


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)


To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.