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