Oracle® Business Intelligence Applications Installation and Configuration Guide > Preinstallation and Predeployment Considerations for Oracle BI Applications > Miscellaneous Information About Oracle Business Intelligence Applications Deployments >

Preconfigured Mapping for the SA System Subject Area


For Oracle's Siebel Applications customers, Table 24 describes the preconfigured mappings for the SA system subject area. Fields that are not available in Oracle's Siebel transactional database will default to values shown in the table.

  • Overriding Defaults. You can add user-specific values for these fields, by creating an extension table to the S_USER table. to store the user-specific defaults for these fields. Additionally, you can change any of the default values. The metadata for the following logical table can be modified to include any physical extension table.

    SA User.(User)

    For instructions, refer to the documentation about configuring tables and columns for Oracle's Siebel Business Applications.

  • Setting Provider Information. Typically, the cell phone and the fax numbers in the Oracle Business Analytics Warehouse do not contain a provider name. Therefore, the Pager will typically be a numeric value such as 555-483-3843. To append a provider to this address, use the following guidelines:
    • If the entire company has the same provider, then you can append the provider in the column mappings.
    • If users can have different providers, you need to create an extension table. For instructions, refer to the documentation about configuring tables and columns for Oracle's Siebel business applications.
Table 24. Preconfigured Mappings for the User Table in the SA System Subject Area
Logical Column
Physical Table
Expression
Comments

Cell Phone

 

''

It might be mapped to S_CONTACT.CELL_PH_NUM if this field contains SMTP address.

Cell Phone Priority

 

''

Defaults to N

Display Name

S_CONTACT

"Real Time OLTP"."".SIEBEL.S_CONTACT_User.FST_NAME || ' ' || "Real Time OLTP"."".SIEBEL.S_CONTACT_User.LAST_NAME

First Name concatenated with Last Name

Email

S_CONTACT

EMAIL_ADDR

 

Email Priority

 

'HNL'

Defaults to N

Email Type

 

'html'

Defaults to HTML

Group Name

S_RESP

NAME

 

Handheld

 

''

Defaults to an empty string

Handheld Priority

 

''

Defaults to an empty string

Language

 

'en'

Defaults to 'en'

Locale

 

'en'

Defaults to 'en'

Logon

S_USER

LOGIN

 

Pager

 

''

It could be mapped to S_CONTACT.PAGER_PH_NUM if this field contains SMTP address

Pager Priority

 

''

Defaults to N

Time Zone

S_TIMEZONE

NAME

 

Oracle® Business Intelligence Applications Installation and Configuration Guide Copyright © 2007, Oracle. All rights reserved.