My Oracle Support Banner

[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

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
Symptoms
Cause
Solution
References


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.
My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.