{"id":1070,"date":"2014-01-08T18:41:36","date_gmt":"2014-01-08T16:41:36","guid":{"rendered":"http:\/\/oracle.malin.pl\/?p=1070"},"modified":"2014-01-08T18:41:36","modified_gmt":"2014-01-08T16:41:36","slug":"fnd-debug-log-debugowanie","status":"publish","type":"post","link":"https:\/\/oracle.malin.pl\/?p=1070","title":{"rendered":"FND Debug Log &#8211; debugowanie"},"content":{"rendered":"<p>Debug messages s\u0105 zapisywane w\u00a0FND_LOG_MESSAGES.<\/p>\n<p>\u017beby przeprowadzi\u0107 debugowanie przez logowanie b\u0142\u0119d\u00f3w w\u00a0FND_LOG_MESSAGES trzeba\u00a0:<\/p>\n<p>1) ustawi\u0107 profile:<\/p>\n<p><strong>1) AFLOG_LEVEL<\/strong><\/p>\n<p><strong>FND: Debug Log Level<\/strong><\/p>\n<p><strong>PL BOA: Poziom dziennika usuwania b\u0142\u0119d\u00f3w<\/strong><\/p>\n<p>Following possible values are available, but I suggest you set this to &#8222;Statement&#8221; level when debugging code.<br \/>\nLEVEL_UNEXPECTED : Internal Level Id is 6<br \/>\nLEVEL_ERROR : Internal Level Id is 5<br \/>\nLEVEL_EXCEPTION : Internal Level Id is 4<br \/>\nLEVEL_EVENT : Internal Level Id is 3<br \/>\nLEVEL_PROCEDURE : Internal Level Id is 2<br \/>\nLEVEL_STATEMENT : Internal Level Id is 1<\/p>\n<p><strong>2)\u00a0AFLOG_ENABLED<\/strong><\/p>\n<p><strong>FND: Debug Log Enabled<\/strong><\/p>\n<p><strong>BOA: W\u0142\u0105czono dziennik usuwania b\u0142\u0119d\u00f3w<\/strong><br \/>\nSet this profile to Yes<\/p>\n<p><strong>3)\u00a0AFLOG_MODULE <\/strong><\/p>\n<p><strong>FND: Debug Log Module<\/strong><\/p>\n<p><strong>BOA: Modu\u0142 dziennika usuwania b\u0142\u0119d\u00f3w<\/strong><br \/>\nSet this to %<br \/>\n2 \u00a0Zalogowa\u0107 si\u0119 do aplikacji i zreprodukowa\u0107 b\u0142\u0105d<\/p>\n<p>3) odczyta\u0107 logi<\/p>\n<pre>\r\nSELECT *\r\nFROM fnd_log_messages\r\nWHERE user_id = 1111 \u00a0\/*tw\u00f3j id z FND_USER *\/\r\nAND TIMESTAMP &gt; SYSDATE - .3\r\nORDER BY log_sequence DESC<\/pre>\n","protected":false},"excerpt":{"rendered":"<p>Debug messages s\u0105 zapisywane w\u00a0FND_LOG_MESSAGES. \u017beby przeprowadzi\u0107 debugowanie przez logowanie b\u0142\u0119d\u00f3w w\u00a0FND_LOG_MESSAGES trzeba\u00a0: 1) ustawi\u0107 profile: 1) AFLOG_LEVEL FND: Debug Log Level PL BOA: Poziom dziennika usuwania b\u0142\u0119d\u00f3w Following possible values are available, but I suggest you set this to &hellip; <a href=\"https:\/\/oracle.malin.pl\/?p=1070\">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":[40],"tags":[213,101,212,214],"_links":{"self":[{"href":"https:\/\/oracle.malin.pl\/index.php?rest_route=\/wp\/v2\/posts\/1070"}],"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=1070"}],"version-history":[{"count":1,"href":"https:\/\/oracle.malin.pl\/index.php?rest_route=\/wp\/v2\/posts\/1070\/revisions"}],"predecessor-version":[{"id":1071,"href":"https:\/\/oracle.malin.pl\/index.php?rest_route=\/wp\/v2\/posts\/1070\/revisions\/1071"}],"wp:attachment":[{"href":"https:\/\/oracle.malin.pl\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=1070"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/oracle.malin.pl\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=1070"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/oracle.malin.pl\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=1070"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}