Notes Greater Than 255 Characters in Demantra are not Saved Even Though There are no Error Messages Presented to the User
Last updated on MARCH 28, 2016
Applies to:Oracle Demantra Deduction and Settlement Management - Version 220.127.116.11 to 18.104.22.168 [Release 7 to 7.2]
Information in this document applies to any platform.
Client on v22.214.171.124 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)
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
Million Knowledge Articles and hundreds of Community platforms