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

Last updated on MARCH 02, 2017

Applies to:

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

Symptoms

With the creation of some denormalized columns in S_ACT_EMP and CX_ACT_BU tabl 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 [CDC 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


Cause

Sign In with your My Oracle Support account

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

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms