Friday 1 June 2012

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

1 comment:

  1. hello
    i try this but i need to show the result without all these steps i mean after submit show the result i do not how monitor screen for concurrent how i can this ?

    ReplyDelete