My Oracle Support Banner

Siebel Marketing: Issue While Removing One Occurence Of Recurring Activity (Doc ID 2183659.1)

Last updated on APRIL 14, 2020

Applies to:

Siebel Marketing - Version 15.7 [IP2015] and later
Information in this document applies to any platform.


With the creation of some denormalized columns in S_ACT_EMP and CX_ACT_BU table Marketing functionality of scheduling repeating activities has been impacted.

When a Campaign in Siebel Marketing is scheduled it is failing with the Error.

¿Error/Warning : Error invoking service 'Campaign Execution', method
'UpdateActivity' at step 'Update Schedule Activity'.(SBL-BPR-00162)
An error has occurred writing to a record.
Please continue or ask your systems administrator to check your application
configuration if the problem persists.(SBL-DBC-00111)

Reproduction steps:

1) On Business component [Action] create a custom field [Test Activity Status] mapped to EVT_STAT_CD (no further properties are needed)
2) Compile the changes
3) Create a new recurring activity (e.g. daily for two weeks or so, does not really matter)
4) Remove one occurrence, this will generate the SQL error




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.