OracleAppsBlog
A day in the life of an Oracle Applications Consultant

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;

Posted by Thierry Vergult on 06/18 at 02:00 AM
  1. Can you give more details of this PYUPIP tool Thierry i.e. what does it do and where can it be downloaded?

    Posted by Richard Byrom  on  06/18  at  03:13 AM
  2. PYUPIP is a pro*C executable in the $PAY_TOP/bin directory. It comes with the installation. It communicates with the database via a dbms pipe.

    But you need server access to launch it and see the trace output.

    If you reroute the trace data to dbms output, you have it in front of you right away, integrated with your plsql tool of choise.

    Posted by .(JavaScript must be enabled to view this email address)  on  06/19  at  02:07 AM

Add Comment Information Here

Please note that comments will only be accepted from valid members of this site who provide feedback that is beneficial to readers of the blog. ALL comments (even those from members) will be subject to moderation.

Smileys

Notify me of follow-up comments?

Submit the word you see below: