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 18.104.22.168  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:
+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