Tuesday, May 13, 2008

Timezone in APPS

For time zone support to be activated, the system administrator must ensure that each of the following is true:

  • Oracle E-Business Suite version 11i10 or higher
  • Oracle RDBMS 9i or higher
  • The database must be configured to use the time zone file 'timezlrg.dat' rather than the 'timezone.dat' file
  • The database must be started in the standard corporate time zone
  • Profile 'Server Timezone' (SERVER_TIMEZONE_ID) must be set at the Site level, and must be set to the same standard corporate time zone as the database
  • Profile 'Client Timezone' (CLIENT_TIMEZONE_ID) must be set at the user level
  • Profile 'Enable Timezone Conversions' (ENABLE_TIMEZONE_CONVERSIONS) must be set to 'Yes' ('Y') at the Site level.
  • Profile 'Concurrent: Multiple Time Zones' (CONC_MULTI_TZ) should be set to 'No' (N) at the Site level