Where Are Time Zone Specifications Stored?

Time zone specifications are stored in their own file.

Whenever a time zone specification is displayed in a list, or as the value of a session variable or element in the instanceconfig.xml file, the specification originates from the TimeZones.xml file, located in:

orahome/bi/bifoundation/timezone

The TimeZones.xml file contains nearly all time zones from around the world. You need not add zones to this file, but you can edit this file if you care to. You can delete those zones that users in your organization do not use.

Specifying Time Zone Values

Various editors show the ampersand that appears in time zone values in one of two ways: either the ampersand character itself or its escape sequence. Use care when entering a time zone value, as follows:

  • When you use the ampersand in the value of a session variable, include the ampersand character (&) in the value, such as Pacific Time (US & Canada); Tijuana.

  • When you use the ampersand in the value of an element in the Oracle BI Presentation Services configuration file (instanceconfig.xml), include the escape sequence for the ampersand in the value, such as Pacific Time (US & Canada); Tijuana.