OracleAppsBlog
A day in the life of an Oracle Applications Consultant

Friday, June 18, 2004

Speeding up Oracle Hrms API debugging

One of my personal favorites is a little trick to speed up development and debugging of Oracle Hrms API’s.

The code behind the API’s has lots of trace statements. You can turn it on by calling “hr_utility.trace_on;”. But the output is now only available through a tool called PYUPIP. This is the one support asks many times for.

Just add one extra call to the previous one, and the trace messages are rerouted to dbms_output.

BEGIN
  hr_utility.set_trace_options(‘TRACE_DEST:DBMS_OUTPUT’);
  hr_utility.trace_on;
END;