§ About

This web log documents the daily experiences and learnings of Oracle Applications Consultants and Implementor's. OracleAppsBlog was founded by Richard Byrom, an Independent Oracle Applications Consultant and Solutions Architect. Richard Byrom Consulting can provide you with services in the following areas:

Bids and Proposals

Business Consulting and Analysis

Information Technology (IT) Strategy

Solutions Architecting

Enterprise Resource Plannning (ERP) Implementations

Writing and Presenting

This Blog has been categorised according to the different industries and modules that apply to Oracle Applications.

§ Most recent entries

Tuesday, December 14, 2004

Enabling Timezone feature in Oracle 11i

Timezone (with day light savings!) feature is available in Oracle 9i Release 2 onwards. This post attempts to describe the steps required to enable Timezone functionality in Oracle Service module.

Recently I was at a client site and the client is desperately looking for this feature mainly to handle increasing number of client calls from multiple timezones. When customer support personnel attend a client call, it is important to know the client’s timezone and talk in terms of their timezone. It is also helpful to see all the date/time information in local timezone to better perceieve about the actual start time or scheduled start time for any activity. The database timezone is setup as GMT but the user wants to setup their own timezone based on their work location. This is exactly what Oracle 11i provides ( with Oracle database 9i Release 2 onwards).

After playing with the setups for few hours with some help from the dba I was able to make the timezone feature work in the client’s test instance (11.5.9). We also noticed that new functionality has been added in the calendar popup window to convert date/time into a different timezone. Here is how the new calendar window looks:

The following are the setup steps:

Oracle Environment variable Setup ( DBA Setup)

Please make sure that timezlrg.dat file exists in the database $ORACLE_HOME directory.