[Marketing] Campaign Load Fails When Load Number Exceeds 999
Last updated on MARCH 02, 2017
Applies to:Siebel Marketing - Version 220.127.116.11  and later
Information in this document applies to any platform.
On : 18.104.22.168  version, Siebel Marketing
[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..
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