Self-Service Reports

Self-Service Reports

Overview

1.    Usually for seeing output of any Report we need to run Concurrent Program, but we can view the output of Report without running concurrent program manually. As we register our OAF web page or Form under function è sub menu è menu è Responsibility

Similarly we can register our normal report in above flow and can view the output in front end without running any concurrent program.   
Steps

1.     Understanding requirement

For Example: xxx General Payslip Self Service Report

This report was need under Employee Self-Service Responsibility in Front End

2.     Prepare the Report specific to current 'USER_ID'

----------our report query taking employee_number based on current USER_ID

employee_number IN

                (SELECT employee_number

                   FROM per_all_people_f

                  WHERE person_id IN

                           (SELECT employee_id

                              FROM fnd_user

                             WHERE user_id IN

                                      (SELECT FND_PROFILE.VALUE ('USER_ID')

                                         FROM DUAL)))

-------------------------------------------

Report Trigger Before Form--------------

-------------------------------------------

function BeforePForm return boolean is

l_application_id NUMBER;

l_resp_id NUMBER;

l_user_id NUMBER;

begin

l_user_id := FND_PROFILE.VALUE('USER_ID');

l_resp_id := FND_PROFILE.VALUE('RESP_ID');

l_application_id := FND_PROFILE.VALUE('RESP_APPL_ID');

fnd_global.apps_initialize(l_user_id,l_resp_id,l_application_id);

SRW.USER_EXIT('FND SRWINIT');

return (TRUE);

end;

-------------------------------------------

Report Trigger After Form---------------

-------------------------------------------

function AfterPForm return boolean is

begin

 srw.user_exit('FND SRWEXIT');

 return (TRUE);

end;

Normal Reports created short name is XXPAYSLIP_NEW_SS    

Registered under HRMS request group.

3.     Create a function.

PropertiesèType : SSWA jsp function

Web HTMLèHTML Call :

OA.jsp?akRegionApplicationId=0&akRegionCode=FNDCPPROGRAMPAGE&programApplName=PER&programName=XXPAYSLIP_NEW_SS&programRegion=Hide&scheduleRegion=Hide&notifyRegion=Hide&printRegion=Hide

We need to pass

programApplName (Responsibility short name under which report is registerd)

and programName (Our Report short name)

4.     Assigning this function to Menu : Employee Self-Service.

5.     Done.

Automatic Train is created in OAF web page:

Once Employee Submits, report output will be displayed