{"id":767,"date":"2013-04-17T09:01:40","date_gmt":"2013-04-17T01:01:40","guid":{"rendered":"http:\/\/j178.mtgbb.com\/?p=767"},"modified":"2013-04-17T09:01:40","modified_gmt":"2013-04-17T01:01:40","slug":"%e6%9f%a5%e8%a9%a2-form-session-timeout","status":"publish","type":"post","link":"https:\/\/j178.mtgbb.com\/?p=767","title":{"rendered":"\u67e5\u8a62  form session timeout"},"content":{"rendered":"<p>\u8cc7\u6599\u4f86\u6e90\uff1a<a href=\"http:\/\/dbadirectsolutions.blogspot.tw\/2010\/04\/how-to-find-forms-session-timeout-on.html\" title=\"\u9019\u88e1\" target=\"_blank\">\u9019\u88e1<\/a><\/p>\n<pre lang=\"oracle8\">\r\nSELECT disabled_flag,\r\n       to_char(first_connect, 'MM\/DD\/YYYY HH:MI:SS') start_time,\r\n       to_char(SYSDATE, 'HH:MI:SS') current_time,\r\n       user_name,\r\n       session_id,\r\n       round((SYSDATE - last_connect) * 24 * 60) mins_idle,\r\n       fnd_profile.value_specific('ICX_SESSION_TIMEOUT',\r\n                                  a.user_id,\r\n                                  a.responsibility_id,\r\n                                  a.responsibility_application_id,\r\n                                  a.org_id,\r\n                                  NULL) timeout\r\n  FROM icx_sessions a, fnd_user b\r\n WHERE a.user_id = b.user_id\r\n       AND last_connect > SYSDATE - 1 \/ 24;\r\n<\/pre>\n","protected":false},"excerpt":{"rendered":"<p>\u8cc7\u6599\u4f86\u6e90\uff1a\u9019\u88e1 SELECT disabled_flag, to_char(first_connect, &#8216;M &hellip;<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[22],"tags":[57],"class_list":["post-767","post","type-post","status-publish","format-standard","hentry","category-oracle-erp","tag-oracle-erp"],"_links":{"self":[{"href":"https:\/\/j178.mtgbb.com\/index.php?rest_route=\/wp\/v2\/posts\/767","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/j178.mtgbb.com\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/j178.mtgbb.com\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/j178.mtgbb.com\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/j178.mtgbb.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=767"}],"version-history":[{"count":0,"href":"https:\/\/j178.mtgbb.com\/index.php?rest_route=\/wp\/v2\/posts\/767\/revisions"}],"wp:attachment":[{"href":"https:\/\/j178.mtgbb.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=767"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/j178.mtgbb.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=767"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/j178.mtgbb.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=767"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}