Apr 19, 2012

Good Trick to speed up Oracle HRMS API debugging


One good trick to ease development and debugging of Oracle Hrms API's.
The code behind any HRMS API has lots of trace statements.
Usual way of getting these debug statements is by enabling PYUPIP trace.
Alternatively if you know all the API parameters, you can turn on the trace by calling it in the following way.

BEGIN 
  hr_utility.set_trace_options('TRACE_DEST:DBMS_OUTPUT'); 
  hr_utility.trace_on; 
  <API call>
  hr_utility.trace_off; 
END;


Trace messages can be redirected to DB pipe using the following code snippet. It assumes DB pipe is already open and running.

BEGIN
  HR_UTILITY.TRACE_ON(NULL,'CRE_BATCH');
   <API CALL;>
  HR_UTILITY.TRACE_OFF;
END;

No comments:

Post a Comment