My Oracle Support Banner

EAI Siebel Adapter Query does NOT provide "+1" prefix for USA/Canada phone number read from DTYPE_PHONE BC field. (Doc ID 2067042.1)

Last updated on NOVEMBER 22, 2019

Applies to:

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


Using the EAI Siebel Adapter Query to fetch Siebel Business Objects data including phone numbers. For example: to generate Siebel Reports using Oracle BI Publisher.

The phone numbers sent from Siebel CRM to Oracle BI Publisher for populating Reports template
does not include Country code for USA (+1) for phone numbers, stored and displayed in Siebel UI in international format.
As result the generated Oracle BI Publisher report does not include country code for the impacted Country (+1 for the USA.
The other Country codes are seems not impacted - are passed properly. E.g. +49 for Germany

Country code for the USA (+1) appear in the phone numbers in Siebel Message (that is  provided to Oracle BI Publisher to generate reports).


To view full details, 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 a vibrant support community of peers and Oracle experts.