Human Capital Management - EBS (MOSC)

MOSC Banner

How to get the PYUPIP trace for APIs directly into DBMS_OUTPUT?

You can use the below commands to get the PYUPIP trace for APIs into DBMS output.

hr_utility.set_trace_options('TRACE_DEST:DBMS_OUTPUT');
hr_utility.trace_on;

<Here, you call your API>

--
-- Call the below command just after API call ends
--
hr_utility.trace_off;


For eg:

--
-- Your wrapper code
--
DECLARE
   --
   -- Variables declaration goes here..
   --

BEGIN
   --
   -- Your code here..
   --
   ...
   ...

  
   --
   -- Add the below commands just before calling the API
   --
   hr_utility.set_trace_options('TRACE_DEST:DBMS_OUTPUT');
   hr_utility.trace_on;

   HR_APPRAISALS_API.CREATE_APPRAISAL (
      p_effective_date                =>  TRUNC(SYSDATE),

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center