[et_pb_section bb_built=”1″ _builder_version=”3.0.106″ custom_padding=”0px||0px|”][et_pb_row _builder_version=”3.0.47″ background_size=”initial” background_position=”top_left” background_repeat=”repeat”][et_pb_column type=”4_4″][et_pb_text _builder_version=”3.2″ background_size=”initial” background_position=”top_left” background_repeat=”repeat”]<\/p>\n
There is a known bug in Forms 12c that the DATETIME item in Forms is set to a different time than what is configured in the Windows or UNIX server. Oracle Support has reported this issue in AIX, but it has been seen in both Windows and Linux as well. The easiest way to work around this bug is to configure the following environment variable to GMT in your env file (e.g. default.env):<\/p>\n
FORMS_DATETIME_LOCAL_TZ=GMT<\/p>\n
NOTE: Normally when you do not set this variable, the system defaults to GMT, but this is necessary in 12c.<\/p>\n
This should correct the time issues, but if for any reason any datetime fields are out of sync still, you may also need to set the following variable to GMT:<\/p>\n
FORMS_DATETIME_SERVER_TZ=GMT<\/p>\n
Source: Oracle Support document ID 2139346.1<\/strong><\/p>\n [\/et_pb_text][\/et_pb_column][\/et_pb_row][et_pb_row custom_padding=”0px||0px|” custom_margin=”30px||0px|” background_position_1=”top_left” background_repeat_1=”no-repeat” _builder_version=”3.0.51″][et_pb_column type=”4_4″][et_pb_cta title=”Still working with legacy applications” button_url=”https:\/\/www.pitss.org\/solutions\/legacy-application-modernization\/” button_text=”LEGACY APPLICATION MODERNIZATION” background_color=”#222222″ _builder_version=”3.0.52″ text_orientation=”left” custom_padding=”45px|50px|45px|50px” custom_button=”on” button_font=”Abel|||on|” border_style=”solid”]<\/p>\n Recent research revealed that 14% of surveyed organizations were undergoing or planning to undergo an application modernization project in 2016. Is your business on the path to a modern application?<\/p>\n [\/et_pb_cta][\/et_pb_column][\/et_pb_row][\/et_pb_section]<\/p>\n","protected":false},"excerpt":{"rendered":" There is a known bug in Forms 12c that the DATETIME item in Forms is set to a different time than what is configured in the Windows or UNIX server. Oracle Support has reported this issue in AIX, but it has been seen in both Windows and Linux as well. The easiest way to work […]<\/p>\n","protected":false},"author":5,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_et_pb_use_builder":"on","_et_pb_old_content":" There is a known bug in Oracle Forms 12c that the DATETIME item in Forms is set to a different time than what is configured in the Windows or UNIX server. Oracle Support has reported this issue in AIX, but it has been seen in both Windows and Linux as well. The easiest way to work around this bug is to configure the following environment variable to GMT in your env file (e.g. default.env):<\/p> FORMS_DATETIME_LOCAL_TZ=GMT<\/p> NOTE: Normally when you do not set this variable, the system defaults to GMT, but this is necessary in 12c.<\/p> This should correct the time issues, but if for any reason any datetime fields are out of sync still, you may also need to set the following variable to GMT:<\/p> FORMS_DATETIME_SERVER_TZ=GMT<\/p> Source: Oracle Support document ID 2139346.1<\/strong><\/p>","_et_gb_content_width":"","footnotes":""},"categories":[22,14,19,10],"tags":[89,51,41,25,3,23,17,24],"class_list":["post-8755","post","type-post","status-publish","format-standard","hentry","category-forms","category-resolve-issues","category-unix-linux","category-windows","tag-12c","tag-aix","tag-configuration","tag-customer-support-request","tag-faq","tag-forms","tag-linux","tag-windows"],"_links":{"self":[{"href":"https:\/\/pitss.org\/us\/wp-json\/wp\/v2\/posts\/8755","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/pitss.org\/us\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/pitss.org\/us\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/pitss.org\/us\/wp-json\/wp\/v2\/users\/5"}],"replies":[{"embeddable":true,"href":"https:\/\/pitss.org\/us\/wp-json\/wp\/v2\/comments?post=8755"}],"version-history":[{"count":6,"href":"https:\/\/pitss.org\/us\/wp-json\/wp\/v2\/posts\/8755\/revisions"}],"predecessor-version":[{"id":11271,"href":"https:\/\/pitss.org\/us\/wp-json\/wp\/v2\/posts\/8755\/revisions\/11271"}],"wp:attachment":[{"href":"https:\/\/pitss.org\/us\/wp-json\/wp\/v2\/media?parent=8755"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/pitss.org\/us\/wp-json\/wp\/v2\/categories?post=8755"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/pitss.org\/us\/wp-json\/wp\/v2\/tags?post=8755"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}