1. set below profiles value at user level<br />
<br />
<span id="kmPgTpl:r1:ot71" class="kmContent" style="font-size:small;color:Black;">FND: Debug Log Enabled -> Yes<br />
FND: Debug Log Level -> Statement<br />
FND: Debug Log Module -> csd% <br />
( this is for CSD module, for INV module, you need to set is as inv%)<br />
FND: Message Level Threshold - Debug High<br />
FND: Debug Log Filename -> blank.<br />
(Note: After you setup. please log out and log in oracle system)<br />
2. <br />
<span id="kmPgTpl:r1:ot71" class="kmContent" style="font-size:small;color:Black;">select max(log_sequence)<br />
into v_max_log_sequence<br />
from fnd_log_messages<br />
(it is better to get the max sequence before your issue, it will reduce the bandwidth( the lines of log file which you focus on ) )<br />
3. reproduce the issue in the oracle system<br />
<br />
4.<br />
select module, MESSAGE_TEXT, log_sequence, timestamp<br />
from fnd_log_messages<br />
where log_sequence > 460054742-- enter the max log sequence from step 2<br />
order by log_sequence <br />
</span></span><br />
来自 “ ITPUB博客 ” ，链接：https://blog.itpub.net/31407706/viewspace-2151315/ ，如需转载，请注明出处，否则将追究法律责任。
请登录后发表评论
登录
全部评论
