{"id":1162,"date":"2018-01-12T17:10:02","date_gmt":"2018-01-12T09:10:02","guid":{"rendered":"http:\/\/www.oracle.name\/?p=1162"},"modified":"2019-04-16T12:22:47","modified_gmt":"2019-04-16T04:22:47","slug":"oracle-ebs%e5%a6%82%e4%bd%95%e8%bf%bd%e8%b8%aa%e7%94%a8%e6%88%b7%e7%99%bb%e5%bd%95ip%ef%bc%88form%e5%b1%82%ef%bc%89","status":"publish","type":"post","link":"https:\/\/www.llku.com\/?p=1162","title":{"rendered":"Oracle EBS\u5982\u4f55\u8ffd\u8e2a\u7528\u6237\u767b\u5f55IP\uff08Form\u5c42\uff09"},"content":{"rendered":"<p>\n\t<span style=\"background-color:#FFFF00;\">\u8bf4\u660e\uff1a\u4e00\u822c\u4e0d\u5efa\u8bae\u5f00\u542f\u767b\u5f55\u5ba1\u8ba1\uff0c\u56e0\u4e3a\u8fd9\u4f1a\u5360\u7528\u5927\u91cf\u7684\u7cfb\u7edf\u8d44\u6e90\u3002<\/span>\n<\/p>\n<p>\n\t\u4ee5\u4e0b\u64cd\u4f5c\u90fd\u901a\u8fc7\u7cfb\u7edf\u7ba1\u7406\u5458\u804c\u8d23\u8fdb\u884c\u64cd\u4f5c\u3002\n<\/p>\n<p>\n\t1. \u5f00\u542f\u914d\u7f6e\u6587\u4ef6&ldquo;\u767b\u5f55\uff1a\u5ba1\u8ba1\u5c42&rdquo;\uff0c\u6839\u636e\u9700\u8981\u662f\u5168\u5c40\uff0c\u8fd8\u662f\u7528\u6237\u5c42\uff1b\n<\/p>\n<p>\n\t2. \u542f\u7528\u5e76\u53d1\u7ba1\u7406\u5668\u4e2d&ldquo;OAM Generic Collection Service:XXXX&rdquo;,\u6b64\u670d\u52a1\u9ed8\u8ba4\u4e0d\u542f\u52a8\uff0c\u76f4\u63a5\u5728\u524d\u53f0\u754c\u9762\u67e5\u8be2\u51fa\u6765\u6fc0\u6d3b\u5373\u53ef\uff1b\n<\/p>\n<p>\n\t<a href=\"http:\/\/www.llku.com\/?attachment_id=1166\" rel=\"attachment wp-att-1166\"><img loading=\"lazy\" alt=\"\" class=\"alignnone size-medium wp-image-1166\" height=\"197\" src=\"http:\/\/www.llku.com\/wp-content\/uploads\/2018\/01\/OAM-300x197.jpg\" width=\"300\" srcset=\"https:\/\/www.llku.com\/wp-content\/uploads\/2018\/01\/OAM-300x197.jpg 300w, https:\/\/www.llku.com\/wp-content\/uploads\/2018\/01\/OAM.jpg 749w\" sizes=\"(max-width: 300px) 100vw, 300px\" \/><\/a>\n<\/p>\n<p>\n\t3. \u901a\u8fc7\u4ee5\u4e0b\u547d\u4ee4\u67e5\u8be2\uff0c\u53ef\u4ee5\u9650\u5236\u9700\u8981\u67e5\u8be2\u7684\u7528\u6237\u7684\u7528\u6237\u540d\u7b49\u76f8\u5173\u4fe1\u606f\u3002\n<\/p>\n<p>\n\tSELECT L.LOGIN_ID,<br \/>\n\t&nbsp; &nbsp; &nbsp; &nbsp;L.USER_ID,<br \/>\n\t&nbsp; &nbsp; &nbsp; &nbsp;L.START_TIME LOGIN_TIME,<br \/>\n\t&nbsp; &nbsp; &nbsp; &nbsp;NVL(F.START_TIME, NVL(R.START_TIME, L.START_TIME)) FORM_TIME,<br \/>\n\t&nbsp; &nbsp; &nbsp; &nbsp;USR.USER_NAME,<br \/>\n\t&nbsp; &nbsp; &nbsp; &nbsp;RSP.RESPONSIBILITY_NAME,<br \/>\n\t&nbsp; &nbsp; &nbsp; &nbsp;FRM.USER_FORM_NAME,<br \/>\n\t&nbsp; &nbsp; &nbsp; &nbsp;(SELECT IPADDRESS<br \/>\n\t&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; FROM FND_OAM_FORMS_RTI OFRI<br \/>\n\t&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;WHERE 1 = 1<br \/>\n\t&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;AND (TO_CHAR(OFRI.PID) = NVL(SF.PROCESS, SR.PROCESS) OR<br \/>\n\t&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;NVL(SF.PROCESS, SR.PROCESS) =<br \/>\n\t&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;CONCAT(CONCAT(TO_CHAR(OFRI.PID), &#39;:&#39;),<br \/>\n\t&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;TO_CHAR(OFRI.THREADID)))<br \/>\n\t&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;AND ROWNUM &lt;= 1) IPADDRESS,<br \/>\n\t&nbsp; &nbsp; &nbsp; &nbsp;R.RESP_APPL_ID,<br \/>\n\t&nbsp; &nbsp; &nbsp; &nbsp;R.RESPONSIBILITY_ID,<br \/>\n\t&nbsp; &nbsp; &nbsp; &nbsp;F.FORM_ID,<br \/>\n\t&nbsp; &nbsp; &nbsp; &nbsp;F.FORM_APPL_ID,<br \/>\n\t&nbsp; &nbsp; &nbsp; &nbsp;L.PID,<br \/>\n\t&nbsp; &nbsp; &nbsp; &nbsp;L.PROCESS_SPID,<br \/>\n\t&nbsp; &nbsp; &nbsp; &nbsp;DECODE(NVL(SF.SID, -999), -999, &#39;RESP_LEVEL&#39;, &#39;FORM_LEVEL&#39;) SESSION_LEVEL,<br \/>\n\t&nbsp; &nbsp; &nbsp; &nbsp;NVL(F.AUDSID, R.AUDSID) AUDSID,<br \/>\n\t&nbsp; &nbsp; &nbsp; &nbsp;NVL(SF.SID, SR.SID) SID,<br \/>\n\t&nbsp; &nbsp; &nbsp; &nbsp;NVL(SF.SERIAL#, SR.SERIAL#) SERIAL#,<br \/>\n\t&nbsp; &nbsp; &nbsp; &nbsp;NVL(SF.PROCESS, SR.PROCESS) PROCESS<br \/>\n\t&nbsp; FROM FND_RESPONSIBILITY_TL &nbsp; &nbsp; &nbsp;RSP,<br \/>\n\t&nbsp; &nbsp; &nbsp; &nbsp;FND_FORM_TL &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;FRM,<br \/>\n\t&nbsp; &nbsp; &nbsp; &nbsp;FND_USER &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; USR,<br \/>\n\t&nbsp; &nbsp; &nbsp; &nbsp;FND_LOGINS &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; L,<br \/>\n\t&nbsp; &nbsp; &nbsp; &nbsp;FND_LOGIN_RESP_FORMS &nbsp; &nbsp; &nbsp; F,<br \/>\n\t&nbsp; &nbsp; &nbsp; &nbsp;GV$SESSION &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; SF,<br \/>\n\t&nbsp; &nbsp; &nbsp; &nbsp;FND_LOGIN_RESPONSIBILITIES R,<br \/>\n\t&nbsp; &nbsp; &nbsp; &nbsp;GV$SESSION &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; SR<br \/>\n\t&nbsp;WHERE 1 = 1<br \/>\n\t&nbsp; &nbsp;AND L.LOGIN_ID = R.LOGIN_ID(+)<br \/>\n\t&nbsp; &nbsp;AND R.LOGIN_ID = F.LOGIN_ID(+)<br \/>\n\t&nbsp; &nbsp;AND R.LOGIN_RESP_ID = F.LOGIN_RESP_ID(+)<br \/>\n\t&nbsp; &nbsp;AND L.LOGIN_TYPE = &#39;FORM&#39;<br \/>\n\t&nbsp; &nbsp;AND L.USER_ID = USR.USER_ID<br \/>\n\t&nbsp; &nbsp;AND R.RESPONSIBILITY_ID = RSP.RESPONSIBILITY_ID(+)<br \/>\n\t&nbsp; &nbsp;AND R.RESP_APPL_ID = RSP.APPLICATION_ID(+)<br \/>\n\t&nbsp; &nbsp;AND RSP.LANGUAGE(+) = USERENV(&#39;LANG&#39;)<br \/>\n\t&nbsp; &nbsp;AND F.FORM_ID = FRM.FORM_ID(+)<br \/>\n\t&nbsp; &nbsp;AND F.FORM_APPL_ID = FRM.APPLICATION_ID(+)<br \/>\n\t&nbsp; &nbsp;AND FRM.LANGUAGE(+) = USERENV(&#39;LANG&#39;)<br \/>\n\t&nbsp; &nbsp;AND F.AUDSID = SF.AUDSID(+)<br \/>\n\t&nbsp; &nbsp;AND R.AUDSID = SR.AUDSID(+) &#8212; AND L.LOGIN_ID = :P_LOGIN_ID\n<\/p>\n<p>\n\t<a href=\"http:\/\/www.llku.com\/?attachment_id=1168\" rel=\"attachment wp-att-1168\"><img loading=\"lazy\" alt=\"\" class=\"alignnone size-medium wp-image-1168\" height=\"73\" src=\"http:\/\/www.llku.com\/wp-content\/uploads\/2018\/01\/sql\u7ed3\u679c-300x73.jpg\" width=\"300\" srcset=\"https:\/\/www.llku.com\/wp-content\/uploads\/2018\/01\/sql\u7ed3\u679c-300x73.jpg 300w, https:\/\/www.llku.com\/wp-content\/uploads\/2018\/01\/sql\u7ed3\u679c-768x186.jpg 768w, https:\/\/www.llku.com\/wp-content\/uploads\/2018\/01\/sql\u7ed3\u679c.jpg 920w\" sizes=\"(max-width: 300px) 100vw, 300px\" \/><\/a>\n<\/p>\n<p>\n\t4. \u6839\u636e\u5f97\u51fa\u7684&quot;PROCESS&quot;,\u901a\u8fc7\u5e94\u7528\u7528\u6237\u53bb\u64cd\u4f5c\u7cfb\u7edf\u76f8\u5e94\u76ee\u5f55\u67e5\u8be2\u76f8\u5173IP\u4fe1\u606f\uff0c\u5982\u4e0b\u547d\u4ee4\uff1a\n<\/p>\n<p>\n\tcd $FORMS_TRACE_DIR\n<\/p>\n<p>\n\t\u53ef\u4ee5\u770b\u5230\u7cfb\u7edf\u751f\u6210\u4e86\u76f8\u5e94PROCESS\u540d\u5b57\u7684rti\u6587\u4ef6\uff0c\u5982\u4e0b\u56fe\u6240\u793a(\u53ef\u901a\u8fc7log\u6587\u4ef6\u8fdb\u53bb\u67e5\u76f8\u5e94PROCESS\u5bf9\u5e94\u7684IP)\uff1a\n<\/p>\n<p>\n\t<a href=\"http:\/\/www.llku.com\/?attachment_id=1163\" rel=\"attachment wp-att-1163\"><img loading=\"lazy\" alt=\"\" class=\"alignnone size-medium wp-image-1163\" height=\"58\" src=\"http:\/\/www.llku.com\/wp-content\/uploads\/2018\/01\/IP-300x58.jpg\" width=\"300\" srcset=\"https:\/\/www.llku.com\/wp-content\/uploads\/2018\/01\/IP-300x58.jpg 300w, https:\/\/www.llku.com\/wp-content\/uploads\/2018\/01\/IP-768x148.jpg 768w, https:\/\/www.llku.com\/wp-content\/uploads\/2018\/01\/IP.jpg 809w\" sizes=\"(max-width: 300px) 100vw, 300px\" \/><\/a>\n<\/p>\n<p>\n\t\u540c\u65f6\u53ef\u4ee5\u627e\u5230em_86653.rti\u6587\u4ef6\uff0c\u7136\u540ecat\u8be5\u6587\u4ef6\u7684\u5185\u5bb9\uff0c\u5982\u4e0b\u56fe\u6240\u793a\uff1a\n<\/p>\n<p>\n\t<a href=\"http:\/\/www.llku.com\/?attachment_id=1164\" rel=\"attachment wp-att-1164\"><img loading=\"lazy\" alt=\"\" class=\"alignnone size-medium wp-image-1164\" height=\"109\" src=\"http:\/\/www.llku.com\/wp-content\/uploads\/2018\/01\/time-300x109.jpg\" width=\"300\" srcset=\"https:\/\/www.llku.com\/wp-content\/uploads\/2018\/01\/time-300x109.jpg 300w, https:\/\/www.llku.com\/wp-content\/uploads\/2018\/01\/time.jpg 702w\" sizes=\"(max-width: 300px) 100vw, 300px\" \/><\/a>\n<\/p>\n<p>\n\t\u81f3\u6b64\u53ef\u4ee5\u67e5\u8be2\u51fa\u767b\u5f55\u7528\u6237\u767b\u5f55form\u7684\u76f8\u5e94IP\u4fe1\u606f\u3002\n<\/p>\n<p>\n\t\u53c2\u8003\uff1ahttps:\/\/www.cnblogs.com\/quanweiru\/p\/8570732.html\n<\/p>\n<p>\n\t&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; https:\/\/blog.csdn.net\/mchdba\/article\/details\/45749131\n<\/p>\n<p>\n\t&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; https:\/\/www.cnblogs.com\/hopedba\/p\/5895106.html\n<\/p>\n<p>\n\t&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; https:\/\/bbs.csdn.net\/topics\/10450699\n<\/p>\n<p>\n\t&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; https:\/\/blog.csdn.net\/mchdba\/article\/details\/68625963<\/p>\n","protected":false},"excerpt":{"rendered":"<p>\u8bf4\u660e\uff1a\u4e00\u822c\u4e0d\u5efa\u8bae\u5f00\u542f\u767b\u5f55\u5ba1\u8ba1\uff0c\u56e0\u4e3a\u8fd9\u4f1a\u5360\u7528\u5927\u91cf\u7684\u7cfb\u7edf\u8d44\u6e90\u3002 \u4ee5\u4e0b\u64cd\u4f5c\u90fd\u901a\u8fc7\u7cfb\u7edf\u7ba1\u7406\u5458\u804c\u8d23\u8fdb\u884c\u64cd\u4f5c\u3002 1. \u5f00\u542f &hellip; <a href=\"https:\/\/www.llku.com\/?p=1162\" class=\"more-link\">\u7ee7\u7eed\u9605\u8bfb<span class=\"screen-reader-text\">Oracle EBS\u5982\u4f55\u8ffd\u8e2a\u7528\u6237\u767b\u5f55IP\uff08Form\u5c42\uff09<\/span> <span class=\"meta-nav\">&rarr;<\/span><\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":[],"categories":[31,1],"tags":[187,188],"_links":{"self":[{"href":"https:\/\/www.llku.com\/index.php?rest_route=\/wp\/v2\/posts\/1162"}],"collection":[{"href":"https:\/\/www.llku.com\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.llku.com\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.llku.com\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.llku.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=1162"}],"version-history":[{"count":12,"href":"https:\/\/www.llku.com\/index.php?rest_route=\/wp\/v2\/posts\/1162\/revisions"}],"predecessor-version":[{"id":1480,"href":"https:\/\/www.llku.com\/index.php?rest_route=\/wp\/v2\/posts\/1162\/revisions\/1480"}],"wp:attachment":[{"href":"https:\/\/www.llku.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=1162"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.llku.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=1162"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.llku.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=1162"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}