{"id":1092,"date":"2014-05-16T15:31:10","date_gmt":"2014-05-16T13:31:10","guid":{"rendered":"http:\/\/oracle.malin.pl\/?p=1092"},"modified":"2023-12-28T21:30:10","modified_gmt":"2023-12-28T19:30:10","slug":"debugowanie-logi-w-fnd_log_messages","status":"publish","type":"post","link":"https:\/\/oracle.malin.pl\/?p=1092","title":{"rendered":"Debugowanie &#8211; logi w FND_LOG_MESSAGES"},"content":{"rendered":"<p>1) enable the debug info by setting the following profiles:<\/p>\n<p>FND: Debug Log Enabled -&gt; Yes<br \/>\nBOA: W\u0142\u0105czono dziennik usuwania b\u0142\u0119d\u00f3w -&gt; Tak<\/p>\n<p>FND: Debug Log Level -&gt; Statement<br \/>\nBOA: Poziom dziennika usuwania b\u0142\u0119d\u00f3w -&gt; Wyci\u0105g  &lt; &#8212; Ja pier***, mistrzostwo \u015bwiata w t\u0142umaczeniu. <\/p>\n<p>FND: Debug Log Module -&gt; %<br \/>\nBOA: Modu\u0142 dziennika usuwania b\u0142\u0119d\u00f3w<\/p>\n<p>To get the log for a online process follow the following..<br \/>\nZapomnieli napisa\u0107, \u017ce trzeba si\u0119 przelogowa\u0107.<br \/>\n&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;-<\/p>\n<p>2)After enable debug profiles, open the ebTax responsibility<\/p>\n<p>3) select USER_ID from fnd_user where user_name= &lt; 'user name through which error will be reproduced&#8217;&gt;<br \/>\n4) select max(LOG_SEQUENCE) FROM FND_LOG_MESSAGES (note down req.in step 7)<\/p>\n<p><strong>5) Run your process again to reproduce the error <\/strong><\/p>\n<p>6) select max(LOG_SEQUENCE) FROM FND_LOG_MESSAGES (note down req.in step 7)<\/p>\n<p>7) SELECT *<br \/>\nFROM FND_LOG_MESSAGES LOG<br \/>\nWHERE user_id = <fnd_user_id from=\"\" step=\"\" 1=\"\"><br \/>\nAND LOG_SEQUENCE between <max log=\"\" sequence=\"\" in=\"\" step=\"\" 4=\"\"> and <\/max><max log=\"\" sequence=\"\" in=\"\" step=\"\" 6=\"\"><br \/>\nORDER BY LOG.LOG_SEQUENCE; <\/max><\/fnd_user_id><\/p>\n","protected":false},"excerpt":{"rendered":"<p>1) enable the debug info by setting the following profiles: FND: Debug Log Enabled -&gt; Yes BOA: W\u0142\u0105czono dziennik usuwania b\u0142\u0119d\u00f3w -&gt; Tak FND: Debug Log Level -&gt; Statement BOA: Poziom dziennika usuwania b\u0142\u0119d\u00f3w -&gt; Wyci\u0105g &lt; &#8212; Ja pier***, &hellip; <a href=\"https:\/\/oracle.malin.pl\/?p=1092\">Czytaj dalej <span class=\"meta-nav\">&rarr;<\/span><\/a><\/p>\n","protected":false},"author":38,"featured_media":0,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":[],"categories":[],"tags":[101,214,220],"_links":{"self":[{"href":"https:\/\/oracle.malin.pl\/index.php?rest_route=\/wp\/v2\/posts\/1092"}],"collection":[{"href":"https:\/\/oracle.malin.pl\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/oracle.malin.pl\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/oracle.malin.pl\/index.php?rest_route=\/wp\/v2\/users\/38"}],"replies":[{"embeddable":true,"href":"https:\/\/oracle.malin.pl\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=1092"}],"version-history":[{"count":3,"href":"https:\/\/oracle.malin.pl\/index.php?rest_route=\/wp\/v2\/posts\/1092\/revisions"}],"predecessor-version":[{"id":1487,"href":"https:\/\/oracle.malin.pl\/index.php?rest_route=\/wp\/v2\/posts\/1092\/revisions\/1487"}],"wp:attachment":[{"href":"https:\/\/oracle.malin.pl\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=1092"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/oracle.malin.pl\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=1092"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/oracle.malin.pl\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=1092"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}