Last updated on MARCH 02, 2017
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 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)
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
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