Miscellaneous Information About Oracle BI Applications Deployments
Oracle Business Intelligence Applications Installation Guide for Informatica PowerCenter Users
3.9.2 Using Initialization Blocks
lists some of the initialization blocks common to all Oracle BI Applications
and their purposes. Initialization blocks that are specific to each Oracle BI Applications
area are not listed here.
To view the initialization blocks provided with Oracle BI Applications, open the
Variable Manager in the Oracle Business Intelligence Enterprise Edition
Administration Tool. For instructions, see Oracle Business Intelligence Server
3.9.3 Creating Custom Indexes in Siebel Source Databases for Incremental Load
To maximize performance for Siebel CRM, you can implement indexes using SQL files
that are available in the ORACLE_HOME\biapps\dwrep directory.
the SQL files that are appropriate for the specified applications.
Initialization Blocks and Their Purposes
Calculates user's responsibilities from the database.
Authenticates against the database and verifies the user exists as a
operational application user.
Gets the translated value of metadata strings for the user's locale. This
initialization block is critical to Intelligence Dashboards in international
Sets the user's locale specification in the Oracle BI Server.
Gets user's login properties, such as full name, from the database. This
initialization block also sets the logging level of the users. By default, the
log level is 0 for all users. If you wish to generate Oracle BI query logs
for all users, this initialization block should be updated by changing the
default value as well as the value in the initialization SQL.
Sets the variable OLTP_LANG_ID by querying the operational
Queries the operational application database to get the organization
membership for each user. It sets the variable ORGANIZATION.
Primary Owner ID
Sets the primary owner ID based on the user login ID.
Primary Position ID
Queries the operational application database to set the variable
Sets several time-based variables such as CURRENT_YEAR.
ETL Run Date
Retrieves the ETL run date.
Retrieves the default currency.
SQL files for Siebel transactional databases
SQL File Name