12 Configuring Time Zone Settings

This chapter describes how to configure time zone settings in Oracle Communications Order and Service Management (OSM). This is an optional configuration task.

Configuring Time Zone Settings

The database that OSM uses should always be set to a time zone that does not use daylight savings time. See "Installing and Configuring the Oracle RAC Database" in OSM Installation Guide for more information.

The oms_timezone parameter, in the om_parameter table of the database, must also be set to a time zone that does not use daylight savings time. This setting must be defined in seconds offset to UTC (Coordinated Universal Time, formerly Greenwich Mean Time) for the time zone for your OSM database. For example, if you are setting this parameter for Eastern Standard Time, use the value -18000 (60 seconds x 60 minutes = 3600 seconds–or one hour–x 5 for five hours offset from UTC/GMT). The oms_timezone parameter is used by the OSM database.

The OSM server uses the database_timezone_offset parameter in the oms-config.xml file. This must be set to be exactly the value used for the oms_timezone parameter in the om_parameter table.