OraFAQ Forum: Oracle Fusion Apps & E-Business Suite

Home » Applications » Oracle Fusion Apps & E-Business Suite » Custom Security

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Custom Security [message #224023]

Mon, 12 March 2007 12:29

JoeD
Messages: 3
Registered: December 2006
Location: London

Junior Member

Hi,

I’m trying to write some custom security code that would allow users to only see employees from their own assignment category in SSHR, so when they log into SSHR and use My List – only employees from the same organization are called back.

The code works for my organization but other employees cannot see their own organization but can see mine, is there some reason for this for instance does it inherit the assignment from the creator?!

The code is:

ASSIGNMENT.organization_id in (select paf.organization_id
from per_all_people_f ppf,
per_all_assignments_f paf
where ppf.business_group_id = 41
and sysdate between ppf.effective_start_date and ppf.effective_end_date
and sysdate between paf.effective_start_date and paf.effective_end_date
and ppf.person_id = paf.person_id
and ppf.person_id = fnd_global.employee_id)

any help would be much appreciated!

Thanks,

Joe

Report message to a moderator

Re: Custom Security [message #224208 is a reply to message #224023]

Tue, 13 March 2007 07:06

prashant_pathak
Messages: 263
Registered: February 2006
Location: California,US

Senior Member

check the user -> employee association

Report message to a moderator

Re: Custom Security [message #224493 is a reply to message #224023]

Wed, 14 March 2007 07:48

David.K.Dickson
Messages: 413
Registered: October 2005
Location: Surrey, England

Senior Member

JoeD wrote on Mon, 12 March 2007 17:29

The code works for my organization but other employees cannot see their own organization but can see mine, is there some reason for this for instance does it inherit the assignment from the creator?!

The code is:
.
where ppf.business_group_id = 41
.

Now, I am not a programmer and I know nothing at all about HR, but I would start by looking at this line.

Cool