Error (SBL-DAT-00235) is created when saving an agenda record (Doc ID 954932.1)

There is an issue with using DVM in the Agenda functionality, The field is too long error message (SBL-DAT-00235) is created when saving a record if certain rulesets are used.

To reproduce the issue with Siebel 7.8.2.12 SIA against standard SRF and Sample db

1. create following action set in Runtime event administration screen:

name = InvokeValidation
active = Y

action...

name = Test
sequence = 1
action type = BusService

business service name =Data Validation Manager
business service method = Validate
business service context = "Rule Set Name", "Test", "Enable Log", "Y"


2. Set up following runtime events in Runtime event administration screen

object type = Applet
object = eCalendar Detail Applet
event = PreInvokeMethod
subsevent = ModifyInstance
actionset name = InvokeValidation

object type = Applet
object = eCalendar Detail Applet
event = PreInvokeMethod
subsevent = ModifyAll
actionset name = InvokeValidation

reload runtime events

3. Create Data Validation Manager Ruleset in DVM administration screen:

name = Test
buscomp = Action
busobject = Action

rule...

sequence = 1
name = One
expression = [Opportunity Id] IS NOT NULL
buscomp = Action
apply to = Current Record
return code = Opportunity is mandatory

activate ruleset


To test:

Go to Calendar screen and in default "HI Activity Outlook Calendar View" view click new button

specify a description and make it Repeat Frequency = daily

click Save This One button

appointment record will be saved and displayed in the daily calendar

drill down on the activity and modify it in the eCalendar Detail Applet eg. enter a comment

click the Save All button

instread of getting expected DVM message as opportunity field is empty get following error message

Value too long for field 'Object Id' (maximum size 15).(SBL-DAT-00235)

This is related to DVM logging as if it is not enabled in the call to Validate method of Data Validation Manager by the runtime event the error does not occur.

This only occurs if editing an repeating activity.

Cause

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