Who's Online
0 registered (), 10 Guests and 8 Spiders online.
Key: Admin, Global Mod, Mod
Newest Members
Slev, Madhu, Schwa, RKD, arunkumarprs
1220 Registered Users
Recent Posts
Sickness/Maternity Data Conversion
by pat
1 second ago
Error in 12.1.3 instance
by pat
28/11/16 04:15 PM
Autumn Statement 2016 - Flat Rate Scheme for PSCs
by hpatel15
28/11/16 12:44 PM
BEN_93811_OVERLAPPIN
G_RATES

by CT
24/11/16 10:14 AM
Participation Process: Absence errors
by PeterP
24/11/16 08:48 AM
Duplicate Person Records
by delboy
23/11/16 02:42 PM
Access the Run Results / Balances during a pay run
by delboy
21/11/16 10:39 AM
ITD Balance and Balance Adjustments
by paulgos
14/11/16 01:40 PM
Grades and Grade Rates
by delboy
10/11/16 10:54 AM
Oracle HCM Cloud interface to Success Factors
by cojohnson
07/11/16 06:44 PM
Top Posters (30 Days)
CT 14
delboy 10
PeterP 5
paulgos 4
pat 3
Slev 3
MikeG2 2
SBi 2
Vigneswar Battu 1
RKD 1
(Views)Popular Topics
Pension Auto Enrolment 3,657,170
PAYE RTI 350,878
New PCSPS regime for 2015 - Alpha, Compendia etc 100,020
Family Pack K issues thread 68,275
CREATE_GRADE api returns:PLS-00306: wrong number o 56,612
Enhanced Retro & Release 12 55,259
Still trying to locate... 48,632
Creating hr jobs ORA-20001: HR_289477_JOB_GROUP_ID 47,581
Adding a taskflow button to a form 46,606
HR_PF.K RUP4 43,360
Page 1 of 2 1 2 >
Topic Options
Rate This Topic
#847 - 08/08/05 03:40 PM Self Service Absence DFF Value set
jhatten Offline
hacker

Registered: 15/03/05
Posts: 95
Loc: London
We have got an absence dff which is used to link an absence to specific assignment. The dff uses a table validation value set to generate a pick list of all an employees current assignments. . .The problem is in Self Service this thing runs like a dog my theory is that fnd_profile.value('PER_PERSON_ID') is null in SS (see code below). . .Can anyone confirm if fnd_profile.value works in Self Service and if not is there an alternative? And… .Do you know if userenv(‘sessionid’) works in self service (I’d like to get rid of the use of sysdate). . . .SELECT lower(PPF.full_name || '(' || haout.name || . decode(pj.name null null ' -' || pj.name) || ')') .FROM per_people_f ppf . per_assignments_f paf . per_jobs pj . hr_all_organization_units_tl haout .WHERE paf.person_id = nvl(fnd_profile.value . ('PER_PERSON_ID') paf.person_id) .AND paf.person_id = ppf.person_id .AND paf.payroll_id IS NOT NULL .AND paf.organization_id = haout.organization_id .AND haout.language = USERENV('LANG') .AND TRUNC(SYSDATE) BETWEEN ppf.EFFECTIVE_START_DATE AND . ppf.EFFECTIVE_END_DATE .AND paf.effective_start_date = .(SELECT MAX(paf2.effective_start_date) .FROM per_assignments_f paf2 .WHERE paf2.assignment_id = paf.assignment_id .AND paf2.effective_start_date <= TRUNC(sysdate) .) .AND paf.job_id = pj.job_id (+) . .Cheers . .Jay

Top
#848 - 09/08/05 09:24 AM Re: Self Service Absence DFF Value set
jmoyano Offline
hacker

Registered: 14/03/05
Posts: 97
Loc: Manchester
Jay . .from what I rememeber userenv(‘sessionid’) doesn't work in SS. We needed to pass a parameter (the same as Web ADI) in order to change sysdate when needed. . .Regards . .Jairo

Top
#849 - 09/08/05 11:50 AM Re: Self Service Absence DFF Value set
jhatten Offline
hacker

Registered: 15/03/05
Posts: 95
Loc: London
Jairo . .Thanks for the reply - from what I can work out so far fnd_profile.value does not work in Self Servive and :$PROFILES$. won't work until we get FND.H into production...bugger! . .Jay

Top
#850 - 12/08/05 09:42 AM Re: Self Service Absence DFF Value set
renglish Offline
warming-up

Registered: 14/03/05
Posts: 18
Can you not use FND_GLOBAL.employee_id ? .I know this work in SSHR.

Top
#851 - 12/08/05 11:23 AM Re: Self Service Absence DFF Value set
jhatten Offline
hacker

Registered: 15/03/05
Posts: 95
Loc: London
Several pints I do now owe you - oh great one. . .PS. even better is fnd_global works in SSHR and PUI and there's a fnd_global.session_id....COME ON!!!!

Top
#852 - 12/08/05 11:46 AM Re: Self Service Absence DFF Value set
renglish Offline
warming-up

Registered: 14/03/05
Posts: 18
Let me write that down. .Glad I could help.

Top
#853 - 12/08/05 01:13 PM Re: Self Service Absence DFF Value set
jhatten Offline
hacker

Registered: 15/03/05
Posts: 95
Loc: London
Bob . .I may have to revoke those beer tokens... fnd_global.employee_id brings back the the user's person_id. What I need is the person_id of the employee the user is entering an absence for (i.e. a supervisor entering an absence for one of his plebs) any ideas... . .fnd_global.session_id works a treat though. . .J

Top
#854 - 12/08/05 01:46 PM Re: Self Service Absence DFF Value set
renglish Offline
warming-up

Registered: 14/03/05
Posts: 18
Are you in a wf and therefore able to use wf_engine.GetItemAttrNumber(CURRENT_PERSON_ID) ?

Top
#855 - 12/08/05 02:22 PM Re: Self Service Absence DFF Value set
jhatten Offline
hacker

Registered: 15/03/05
Posts: 95
Loc: London
Rob . .The code is in a table validation value set attached to the Additional Absence dff that has been added (via personalization) to the standard SS Absence page. . .Do you reckon wf_engine is available and if so how do I get hold of the itemtype itemkey to pass to wf_engine.GetItemAttrNumber. . .Cheers ears . .Jay

Top
#856 - 12/08/05 03:40 PM Re: Self Service Absence DFF Value set
renglish Offline
warming-up

Registered: 14/03/05
Posts: 18
I doubt you could call wfengine implicitly from SQL. Although I have never tried. Not sure I can help you any more. Sorry.

Top
Page 1 of 2 1 2 >

Moderator:  Administrator, Geoff Dixon 
Forum Stats
1,221 Registered Members
48 Forums
2,133 Topics
11,563 Posts

Most users ever online: 68 @ 15/08/12 04:43 AM
Today's Birthdays
Glen Palmer (41)
Recent vacancies
PM required for 6 months contract
by delboy
15/11/16 08:33 AM
Top Posters
CT 2039
bcooper 1252
delboy 1184
paulgos 416
SBi 411
Geoff Dixon 382
Vigneswar Battu 270
Gus 252
pat 236
vkumar 223
December
S M T W T F S
1 2 3
4 5 6 7 8 9 10
11 12 13 14 15 16 17
18 19 20 21 22 23 24
25 26 27 28 29 30 31