Home » Applications » Oracle Fusion Apps & E-Business Suite » Custom Security
Custom Security [message #224023] Mon, 12 March 2007 12:29 Go to next message
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
Re: Custom Security [message #224208 is a reply to message #224023] Tue, 13 March 2007 07:06 Go to previous messageGo to next message
prashant_pathak
Messages: 263
Registered: February 2006
Location: California,US
Senior Member
check the user -> employee association
Re: Custom Security [message #224493 is a reply to message #224023] Wed, 14 March 2007 07:48 Go to previous messageGo to next message
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 HTH

David
icon10.gif  Re: Custom Security [message #224495 is a reply to message #224493] Wed, 14 March 2007 07:52 Go to previous message
JoeD
Messages: 3
Registered: December 2006
Location: London
Junior Member

Cheers guys, I *think* I've found a workaround..

The code on the business group was ok though Wink

[Updated on: Wed, 14 March 2007 07:53]

Report message to a moderator

Previous Topic: how to access patches from meta link for tutors
Next Topic: Oracle Apps Different Set of Books (Inter Relation)
Goto Forum:
  


Current Time: Mon Dec 05 04:58:55 CST 2016

Total time taken to generate the page: 0.09439 seconds