Trying to create an Absence Report and restrict view to session login HR/ HR Generalist

Question

Hi,

Am trying to Create an Absence Report. I want to create a filter criteria where the Report have to populate results according to Department which are under that Particular Signed in Hr Generalist.

Please help me creating this filter or Security criteria.

Thank you.

Venkata Yaswanth Ramisetty · Answer

Hi,

We got the same requirement and I thought and implemented the below approach..

1. Create helper report. Report with employee number/ username, department

2. In the main report, use a filter where department in (select department from helper report)

3. Based on above result, you will get all the departments.. So, we need to restrict based on the user who logs in.

4. In helper report, add a filter where username/ employee number in VALUEOF(NQ_SESSION."DESCRIPTION"). This will return the department of the specific user who logs in.

5. The user will be created in console right? So, in the console, for the users, under description, provide their login username/ employee number based on your helper report field.

6. For other users, report should display all the departments details. for that in the helper report itself provide VALUEOF(NQ_SESSION."DESCRIPTION") or (1=1).

Hope this helps..

Thanks,

Yaswanth

John_K · Answer

Have you set up security profiles in EBS to secure the user to just the employees they are allowed to see?

Robert Angel · Answer

Sorry, I have not implemented the exact filter that you describe, and I suspect that your requirement is specific to your business, so to achieve this you really need someone locally who can write sql in conjunction with a functional HR specialist and yourself to explain your exact requirement.

The key question you need answering is how is it configured in your e-business system to associate an 'HR generalist' with department or department(s).

If someone can write SQL code that when given the 'HR Generalist' returns Departments covered by that person, then you can achieve your requirement.

Good Luck!