My Oracle Support Banner

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

Last updated on AUGUST 06, 2018

Applies to:

Siebel CRM - Version [16192] and later
Siebel Sales Enterprise - Version 16.18 [IP2016] to 16.18 [IP2016] [Release V16]
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.


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

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.