Home » Applications » Oracle Fusion Apps & E-Business Suite » Oracle HRMS Workflow reporting from SQL
Oracle HRMS Workflow reporting from SQL [message #257212] Tue, 07 August 2007 15:11 Go to next message
Messages: 39
Registered: June 2005
Does anyone know how I could write a report at the SQL level to return a count of HR manager self service transactions submitted in a particular date range?

I know that transactions in progress are stored in hr_api_transactions, but after they are completed, they are removed from that table, so I'm not sure how to report on them.

I have something like this for the currently active transactions in that table:

select  count(item_key) as transactions
        ,decode(process_name,'HR_TERMINATION_JSP_PRC','Termination','HR_MANAGER_JSP_PRC','Change Manager','HR_TRANSFER_JSP_PRC','Change Job') as type
from apps.hr_api_transactions
where item_type = 'HRSSA'
and creation_date between 
to_date('07/01/2007', 'MM/DD/RRRR') AND 
to_date('07/31/2007', 'MM/DD/RRRR') 
group by decode(process_name,'HR_TERMINATION_JSP_PRC','Termination','HR_MANAGER_JSP_PRC','Change Manager','HR_TRANSFER_JSP_PRC','Change Job')

This returns a nice count, but as I said, this only includes transactions that were never completed successfully.


Re: Oracle HRMS Workflow reporting from SQL [message #257376 is a reply to message #257212] Wed, 08 August 2007 04:01 Go to previous message
Messages: 413
Registered: October 2005
Location: Surrey, England
Senior Member
I have no idea, but if I had to tackle this problem myself, I would start with the eTRM's which can be found at http://etrm.oracle.com/.

Good luck.

Cool HTH

Previous Topic: who can help me
Next Topic: Foreign Currency SOB setup
Goto Forum:

Current Time: Sat Aug 19 19:38:09 CDT 2017

Total time taken to generate the page: 0.15690 seconds