- 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 "