| Oracle® Hyperion Financial Close Management Administrator's Guide E91357-01 |
|
 Previous |
 Next |
The following section lists the supported time zones and the import file format.
The Excel sheet lists the complete list of time zones that are supported by the application, their code and their offsets. The last column gives the import file format. Specify the time zone column in this exact format. Any other format or any other string in the time zone column of the CSV file will be rejected.
Note:
The empty columns in the Excel worksheet represent more than one time zone which is represented by same code and offset.
Example:
Table D-1 Supported Time Zones in Organization Units
| Time Zone | Code | Offset | Internal Code | How they are listed in the import file |
|---|---|---|---|---|
| Phoenix - | Mountain Time MT | (UTC-07:00) | America/Phoenix | MT (UTC-07:00) |
| Mountain Time, Canada | America/Edmonton | |||
| Chihuahua - Mexico Time 2 | America/Chihuahua | |||
| Mexico Time 2 | America/Mazatlan | |||
| Denver - Mountain Time | America/Denver |
All the above time zones are represented using MT (UTC-07:00). During import there is no way to distinguish them. In such cases, the system will assume the time zone of the first time zone available (which is the row where the code and offset are specified.) User can always change the time zone from the setup dialog after import.
Table D-2 Supported Times Zones in the Organization for Import Files
| TimeZone | Code | Offset | Internal Code | How they are mentioned in the import file |
|---|---|---|---|---|
| Midway - Samoa Time | ST | (UTC-11:00) | Pacific/Midway | ST (UTC-11:00) |
| Pago Pago - Samoa Time | Pacific/Pago Pago | |||
| Honolulu - Hawaii Time | HT | (UTC-10:00) | Pacific/Honolulu | HT (UTC-10:00) |
| Alaska Time | AKT | (UTC-09:00) | America/Anchorage | AKT (UTC-09:00) |
| Vancouver - Pacific Time (Canada) | America/Vancouver | |||
| Tijuana - Pacific Time | America/Tijuana | |||
| Los Angeles - Pacific Time | PT | (UTC-08:00) | America/Los Angeles | PT (UTC-08:00) |
| Phoenix - Mountain Time | MT | (UTC-07:00) | America/Phoenix | MT (UTC-07:00) |
| Mountain Time, Canada | America/Edmonton | |||
| Chihuahua - Mexico Time 2 | America/Chihuahua | |||
| Mexico Time 2 | America/Mazatlan | |||
| Denver - Mountain Time | America/Denver | |||
| Chicago - Central Time | CT | (UTC-06:00) | America/Chicago | CT (UTC-06:00) |
| Central Time (Canada) | America/Winnipeg | |||
| Costa Rica - Central America Time | America/Costa Rica | |||
| El Salvador - Central America Time | America/El Salvador | |||
| Guatemala - Central America Time | America/Guatemala | |||
| Managua - Central America Time | America/Managua | |||
| Regina - Central Time | America/Regina | |||
| Mexico City - Mexico Time | MT | (UTC-06:00) | America/Mexico City | MT (UTC-06:00) |
| Bogota - Colombia Time | COT | (UTC-05:00) | America/Bogota | COT (UTC-05:00) |
| Guayaquil - Ecuador Time | ECT | (UTC-05:00) | America/Guayaquil | ECT (UTC-05:00) |
| Lima - Peru Time | PET | (UTC-05:00) | America/Lima | PET (UTC-05:00) |
| New York - Eastern Time | ET | (UTC-05:00) | America/New York | ET (UTC-05:00) |
| Montreal - Eastern Time (Canada) | America/Montreal | |||
| Indianapolis - Eastern Time | America/Indianapolis | |||
| Panama - Eastern Time | America/Panama | |||
| Caracas - Venezuela Time | VET | (UTC-04:30) | America/Caracas | VET (UTC-04:30) |
| Puerto Rico - Atlantic Time | AT | (UTC-04:00) | America/Puerto Rico | AT (UTC-04:00) |
| Canada Atlantic Time | America/Halifax | |||
| Santiago - Chile Time | CLT | (UTC-04:00) | America/Santiago | CLT (UTC-04:00) |
| Buenos Aires | ART | (UTC-03:00) | America/Buenos Aires | ART (UTC-03:00) |
| Godthab - Western Greenland Time | WGT | (UTC-03:00) | America/Godthab | WGT (UTC-03:00) |
| Sao Paulo - Brasilia Time | BRT | (UTC-03:00) | America/Sao Paulo | BRT (UTC-03:00) |
| St Johns - Newfoundland Time | NT | (UTC-03:30) | America/St Johns | NT (UTC-03:30) |
| Noronha - Fernando de Noronha Time | FNT | (UTC-02:00) | America/Noronha | FNT (UTC-02:00) |
| Azores - Azores Time | AZOT | (UTC-01:00) | Atlantic/Azores | AZOT (UTC-01:00) |
| Cape Verde - Cape Verde Time | CVT | (UTC-01:00) | Atlantic/Cape Verde | CVT (UTC-01:00) |
| Casablanca - Western European Time | WET | (UTC+00:00) | Africa/Casablanca | WET (UTC+00:00) |
| Dublin - Greenwich Mean Time | GMT | (UTC+00:00) | Europe/Dublin | GMT (UTC+00:00) |
| Lisbon - Western European Time | WET | (UTC+00:00) | Europe/Lisbon | WET (UTC+00:00) |
| London - Greenwich Mean Time | GMT | (UTC+00:00) | Europe/London | GMT (UTC+00:00) |
| Nouakchott - Greenwich Mean Time | Africa/Nouakchott | |||
| Reykjavik - Greenwich Mean Time | Atlantic/Reykjavik | |||
| Coordinated Universal Time | UTC | (UTC+00:00) | Etc/UTC | UTC (UTC+00:00) |
| Lagos - Western African Time | WAT | (UTC+01:00) | Africa/Lagos | WAT (UTC+01:00) |
| Brussels - Central European Time | CET | (UTC+01:00) | Europe/Brussels | CET (UTC+01:00) |
| Algiers - Central European Time | Africa/Algiers | |||
| Amsterdam - Central European Time | Europe/Amsterdam | |||
| Belgrade - Central European Time | Europe/Belgrade | |||
| Berlin - Central European Time | Europe/Berlin | |||
| Budapest - Central European Time | Europe/Budapest | |||
| Copenhagen - Central European Time | Europe/Copenhagen | |||
| Luxembourg - Central European Time | Europe/Luxembourg | |||
| Madrid - Central European Time | Europe/Madrid | |||
| Oslo - Central European Time | Europe/Oslo | |||
| Paris - Central European Time | Europe/Paris | |||
| Prague - Central European Time | Europe/Prague | |||
| Rome - Central European Time | Europe/Rome | |||
| Stockholm - Central European Time | Europe/Stockholm | |||
| Tirane - Central European Time | Europe/Tirane | |||
| Tunis - Central European Time | Africa/Tunis | |||
| Vienna - Central European Time | Europe/Vienna | |||
| Warsaw - Central European Time | Europe/Warsaw | |||
| Zurich - Central European Time | Europe/Zurich | |||
| Cairo - Egypt Time | ET | (UTC+02:00) | Africa/Cairo | ET (UTC+02:00) |
| Harare - Central African Time | CAT | (UTC+02:00) | Africa/Harare | CAT (UTC+02:00) |
| Jerusalem - Israel Time | IT | (UTC+02:00) | Asia/Jerusalem | IT (UTC+02:00) |
| Johannesburg - South Africa Time | SAT | (UTC+02:00) | Africa/Johannesburg | SAT (UTC+02:00) |
| Athens - Eastern European Time | EET | (UTC+02:00) | Europe/Athens | EET (UTC+02:00) |
| Amman - Eastern European Time | Asia/Amman | |||
| Beirut - Eastern European Time | Asia/Beirut | |||
| Bucharest - Eastern European Time | Europe/Bucharest | |||
| Damascus - Eastern European Time | Asia/Damascus | |||
| Helsinki - Eastern European Time | Europe/Helsinki | |||
| Istanbul - Eastern European Time | Europe/Istanbul | |||
| Kiev - Eastern European Time | Europe/Kiev | |||
| Nicosia - Eastern European Time | Asia/Nicosia | |||
| Riga - Eastern European Time | Europe/Riga | |||
| Sofia - Eastern European Time | Europe/Sofia | |||
| Tallinn - Eastern European Time | Europe/Tallinn | |||
| Tripoli - Eastern European Time | Africa/Tripoli | |||
| Vilnius - Eastern European Time | Europe/Vilnius | |||
| Qatar - Arabia Time | AT | (UTC+03:00) | Asia/Qatar | AT (UTC+03:00) |
| Aden - Arabia Time | Asia/Aden | |||
| Baghdad - Arabia Time | Asia/Baghdad | |||
| Bahrain - Arabia Time | Asia/Bahrain | |||
| Kuwait - Arabia Time | Asia/Kuwait | |||
| Riyadh - Arabia Time | Asia/Riyadh | |||
| Moscow - Moscow Time | MSK | (UTC+03:00) | Europe/Moscow | MSK (UTC+03:00) |
| Nairobi - Eastern African Time | EAT | (UTC+03:00) | Africa/Nairobi | EAT (UTC+03:00) |
| Djibouti - Eastern African Time | Africa/Djibouti | |||
| Khartoum - Eastern African Time | Africa/Khartoum | |||
| Mogadishu - Eastern African Time | Africa/Mogadishu | |||
| Tehran - Iran Time | IRT | (UTC+03:30) | Asia/Tehran | IRT (UTC+03:30) |
| Baku - Azerbaijan Time | AZT | (UTC+04:00) | Asia/Baku | AZT (UTC+04:00) |
| Dubai - Gulf Time | GT | (UTC+04:00) | Asia/Dubai | GT (UTC+04:00) |
| Muscat - Gulf Time | Asia/Muscat | |||
| Kabul - Afghanistan Time | AFT | (UTC+04:30) | Asia/Kabul | AFT (UTC+04:30) |
| Karachi - Pakistan Time | PKT | (UTC+05:00) | Asia/Karachi | PKT (UTC+05:00) |
| Tashkent - Uzbekistan Time | UZT | (UTC+05:00) | Asia/Tashkent | UZT (UTC+05:00) |
| Yekaterinburg - Yekaterinburg Time | YEKT | (UTC+05:00) | Asia/Yekaterinburg | YEKT (UTC+05:00) |
| Calcutta - India Time | IT | (UTC+05:30) | Asia/Calcutta | IT (UTC+05:30) |
| Kathmandu - Nepal Time | NPT | (UTC+05:45) | Asia/Kathmandu | NPT (UTC+05:45) |
| Almaty - Alma-Ata Time | ALMT | (UTC+06:00) | Asia/Almaty | ALMT (UTC+06:00) |
| Colombo - Sri Lanka Time | LKT | (UTC+05:30) | Asia/Colombo | LKT (UTC+05:30) |
| Dhaka - Bangladesh Time | BDT | (UTC+06:00) | Asia/Dhaka | BDT (UTC+06:00) |
| Novosibirsk - Novosibirsk Time | NOVT | (UTC+06:00) | Asia/Novosibirsk | NOVT (UTC+06:00) |
| Rangoon - Myanmar Time | MMT | (UTC+06:30) | Asia/Rangoon | MMT (UTC+06:30) |
| Bangkok - Indochina Time | ICT | (UTC+07:00) | Asia/Bangkok | ICT (UTC+07:00) |
| Saigon - Indochina Time | Asia/Saigon | |||
| Jakarta - West Indonesia Time | WIT | (UTC+07:00) | Asia/Jakarta | WIT (UTC+07:00) |
| Krasnoyarsk - Krasnoyarsk Time | KRAT | (UTC+07:00) | Asia/Krasnoyarsk | KRAT (UTC+07:00) |
| Shanghai - China Time | CT | (UTC+08:00) | Asia/Shanghai | CT (UTC+08:00) |
| Taipei - China Time | Asia/Taipei | |||
| Hong Kong - Hong Kong Time | HKT | (UTC+08:00) | Asia/Hong Kong | HKT (UTC+08:00) |
| Irkutsk - Irkutsk Time | IRKT | (UTC+08:00) | Asia/Irkutsk | IRKT (UTC+08:00) |
| Kuala Lumpur - Malaysia Time | MYT | (UTC+08:00) | Asia/Kuala Lumpur | MYT (UTC+08:00) |
| Manila - Philippines Time | PHT | (UTC+08:00) | Asia/Manila | PHT (UTC+08:00) |
| Perth - Western Time (Australia) | WT | (UTC+08:00) | Australia/Perth | WT (UTC+08:00) |
| Singapore - Singapore Time | SGT | (UTC+08:00) | Asia/Singapore | SGT (UTC+08:00) |
| Seoul - Korea Time | KT | (UTC+09:00) | Asia/Seoul | KT (UTC+09:00) |
| Tokyo - Japan Time | JT | (UTC+09:00) | Asia/Tokyo | JT (UTC+09:00) |
| Yakutsk - Yakutsk Time | YAKT | (UTC+09:00) | Asia/Yakutsk | YAKT (UTC+09:00) |
| Adelaide - Central Time (SouthAustralia) | CT | (UTC+09:30) | Australia/Adelaide | CT (UTC+09:30) |
| Darwin - Central Time (Northern Territory) | Australia/Darwin | |||
| Brisbane - Eastern Time (Queensland) | ET | (UTC+10:00) | Australia/Brisbane | ET (UTC+10:00) |
| Guam - Chamorro Time | ChT | (UTC+10:00) | Pacific/Guam | ChT (UTC+10:00) |
| Sydney - Eastern Time (New South Wales) | ET | (UTC+10:00) | Australia/Sydney | ET (UTC+10:00) |
| Hobart - Eastern Time (Tasmania) | Australia/Hobart | |||
| Vladivostok - Vladivostok Time | VLAT | (UTC+10:00) | Asia/Vladivostok | VLAT (UTC+10:00) |
| Magadan - Magadan Time | MAGT | (UTC+11:00) | Asia/Magadan | MAGT (UTC+11:00) |
| Auckland - New Zealand Time | NZT | (UTC+12:00) | Pacific/Auckland | NZT (UTC+12:00) |
| Dateline Standard Time | UTC | (UTC+12:00) | Etc/GMT-12 | UTC (UTC+12:00) |
| Fiji - Fiji Time | FJT | (UTC+12:00) | Pacific/Fiji | FJT (UTC+12:00) |
| Kamchatka - Petropavlovsk-Kamchatski Time | PETT | (UTC+12:00) | Asia/Kamchatka | PETT (UTC+12:00) |
| Tongatapu - Tonga Time | TOT | (UTC+13:00) | Pacific/Tongatapu | TOT (UTC+13:00) |
