[Marketing] Campaign Load Fails When Load Number Exceeds 999
(Doc ID 1986640.1)
Last updated on MARCH 02, 2017
Applies to:Siebel Marketing - Version 188.8.131.52  and later
Information in this document applies to any platform.
On : 184.108.40.206  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..
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
|This document is being delivered to you via Oracle Support's Rapid Visibility (RaV) process and therefore has not been subject to an independent technical review.|