Carriage Return And Zeroes Stored In Telephone/Phone Field (DTYPE_PHONE)
(Doc ID 521484.1)
Last updated on MAY 15, 2021
Applies to:Siebel CRM - Version 184.108.40.206  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 : +yy-xx-xxxx-xxxx
Phone Number stored in database: +yyxxxxxxxxxx-00-0000-0000.
It was found that there was a carriage return appended with the numbers, along with the zeros, e.g. +yyxxxxxxxxxx|-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:
+yy xx xxxx-xxxx +yyxxxxxxxxxx 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