Carriage Return And Zeroes Stored In Telephone/Phone Field (DTYPE_PHONE)
Last updated on JULY 05, 2017
Applies to:Siebel CRM - Version 22.214.171.124  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:
+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