[Marketing] Campaign Load Fails When Load Number Exceeds 999 (Doc ID 1986640.1)

Last updated on MARCH 02, 2017

Applies to:

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

Symptoms

On : 8.1.1.9 [23016] version, Siebel Marketing

ACTUAL BEHAVIOR
---------------
[Marketing] Campaign load fails when load number exceeds 999

The customer reported an issue when loading campaigns in marketing. When the load number reached a number greater than 999, the campaign load failed. The issue seemed to be with the space in the load number. The load number is incremented automatically by 1 at each campaign load (for a particular campaign). As such, the load number generated after "999" comes with a space: "1 000", "1 001" etc. The load campaign hence fails with the following error messages:

Invalid character value for cast specification.
SBL-EAI-04376: La méthode 'Execute' du BC 'Marketing Camp Con' (composant d'intégration 'Campaign Contact') a renvoyé l'erreur suivante : "L'expression de requête du champ 'Load Number' est incorrecte. Revoyez-la et recommencez.

Translated as - SBL-EAI-04376: Method 'Execute' BC 'Camp Marketing Con' (Integration Component 'Campaign Contact') returned the following error: "The query expression of the field 'Load Number' is incorrect Review it and start again..

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