Saturday, November 21, 2009

Oracle Apps Logging techniques

  • Set "FND: Debug Log Level" Profile for your user and view log messages using

    SELECT *

    FROM fnd_log_messages

    WHERE user_id = 1231 /*your FND_USER user_id here*/

    AND TIMESTAMP > SYSDATE - .3

    ORDER BY log_sequence DESC

  • HRMS provide PYUPIP utility to gather trace in APIs. But we need to be careful while using it as if trace is not collected, it hangs up there. The way to turn on and off trace are

hr_utility.trace_on(null, '');

api_call;

hr_utility.trace_off;

The trace can be collected in a unix session in "log_file" as

$PAY_TOP/bin/PYUPIP apps/apps "" > log_file