Local Timezone Setting

Oracle EBS includes as standard a feature called User-Preferred Time Zone Support. In general, all users interact with the system in the “corporate time zone”, which will normally be the time zone of the headquarters of the client, and the time zone in which the database runs. The client may have their presence in other countries with different timezone such as India, England etc. whose timezone is different from corporate timezone.

Employing the user-preferred time zone feature enables users to specify their local time zone for both display and entry of date-with-time fields.

Key benefits :

• Users see date-with-time fields in their preferred (local) time zone, and can enter dates with time in this time zone
• Date fields without a time component are not affected by this feature
• The data in the database continues to be stored in the standard corporate time zone

For user-preferred time zone support to operate correctly, all of the following must be true:

• Profile option 'Server Timezone' must be set at site level, and must be set to the same standard corporate time zone as the database. I am setting this up to EST/Eastern Timezone
• Profile option 'Enable Timezone Conversions' must be set to 'Yes' (or 'Y') at site level

• Profile option 'Client Timezone'  must be set at user level. This is applicable to Oracle Forms based UIs. For example, I have set here Client Timezone to IST/India Timezone

• Profile 'Concurrent: Multiple Time Zones'  must be set to 'No' at the site level

• Preference ‘Timezone’ must be set at user level. This is applicable to HTML based UIs. To set this up, you need login in the browser and click 'Preferences' and set the Timezone to 'IST' as shown below.