Carriage Return And Zeroes Stored In Telephone/Phone Field (DTYPE_PHONE)

(Doc ID 521484.1)

Last updated on JULY 05, 2017

Applies to:

Siebel CRM - Version [16192] and later
Information in this document applies to any platform.


It was reported that there were some issues with telephone data format stored in the Siebel database.

Phone Number entered in GUI      : +55-11-6165-8543
Phone Number stored in database: +551161658543-00-0000-0000.

It was found that there was a carriage return appended with the numbers, along with the zeros, e.g. +551161658543|-00-0000-0000

The problem was found when a customized button "Generate Distribution List" , which on clicking generates the 'marketing Distribution list' file in the server. This file contains the different fields, including "WORK_PHONE_NUM". When this file was generated the data was moved into the next record from the end of the work phone number as it contained a carriage return.

This was found to be happening with some other phone numbers as well:
GUI                            Database
+55-(21)6591-4000     +552165914000-(00)0000-0000
+55 11 6165-8543       +551161658543 00 0000-0000

This behavior also manifests when the data is exported by EIM.


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