Miscellaneous Information About Oracle BI Applications Deployments
Preinstallation and Deployment Requirements for Oracle BI Applications
3-33
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 35
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