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 184.108.40.206 to 220.127.116.11 [Release 7 to 7.2]
Information in this document applies to any platform.
Client on v18.104.22.168 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