Search This Blog

Wednesday, April 6, 2016

To submit Concurrent Request using the (SSHR) OAF Page:

To submit Concurrent Request using the SSHR Page:


2.
SSWA jsp function

3.

For a Particular Program:
OA.jsp?akRegionApplicationId=0&akRegionCode=FNDCPPROGRAMPAGE&programApplName=XXCUST&programName=XXEMPNOC&programRegion=Hide&scheduleRegion=Hide&notifyRegion=Hide&printRegion=Hide

For any Program:
OA.jsp?akRegionApplicationId=0&akRegionCode=FNDCPPROGRAMPAGE&scheduleRegion=Hide&notifyRegion=Hide&printRegion=Hide

4. Attach the function to the Responsibility Menu of Self service.
5. it will not show directly to the Selfservice Menu we need to add under Custom Menu named
AE Self Service Functions Custom

6. Set the Profile Option at Site Level “MO: Operating Unit” , if not set will get an error in the page. (Doc ID 393560.1)

For Parameters:

Payroll_id :
Default Type: SQL Statement
SELECT PAAF.PAYROLL_ID FROM PER_ALL_ASSIGNMENTS_F PAAF, PAY_ALL_PAYROLLS_F PPF WHERE TRUNC(SYSDATE) BETWEEN PAAF.EFFECTIVE_START_DATE AND PAAF.EFFECTIVE_END_DATE AND PAAF.PRIMARY_FLAG = 'Y' AND PERSON_ID IN (SELECT EMPLOYEE_ID FROM FND_USER WHERE USER_ID = fnd_profile.value('USER_ID')) AND ROWNUM =1AND PAAF.PAYROLL_ID = PPF.PAYROLL_ID

Person Id: (hidden)
Default Type SQL Statement
SELECT EMPLOYEE_ID FROM FND_USER WHERE USER_ID = fnd_profile.value('USER_ID') AND ROWNUM = 1

Payroll_Action_id: (in rdf report AFTER PARAMETER FORM)
select distinct paa.payroll_action_id--, ptp.time_period_id
  into :p_payroll_action_id
from
per_all_assignments_f paaf,
pay_payroll_actions ppa,
per_time_periods ptp,
pay_assignment_actions paa
where
ptp.time_period_id = ppa.time_period_id
and paaf.assignment_id = paa.assignment_id
and paa.payroll_action_id = ppa.payroll_action_id
--and paa.payroll_action_id = 2035382
and paaf.person_id = :p_person_id--26876
and ptp.time_period_id = :p_time_period_id-- 5010
 

No comments:

Post a Comment