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
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¬ifyRegion=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
hello
ReplyDeletei 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 ?