ETL 9.2: Manager Self-Service Report Time> Timesheet Employee ID Returns All Employees In Error (Doc ID 1670530.1)

Last updated on JULY 13, 2016

Applies to:

PeopleSoft Enterprise HCM Time and Labor - Version 9.2 and later
Information in this document applies to any platform.

Symptoms

When we navigate to Manager Self-Service> Time Management> Report Time>Timesheet we get to the Timesheet search page. We have enabled Time Reporter Group, Employee ID, Employee Record, Last Name, First Name, Job Description, Location Code, Company, Workgroup, Position Number.

If we use the Time Reporter Group lookup it only returns the groups that the user has access to based on T and L Security. However, when we use Employee ID lookup we get all employees in the system. This seems to be a bug. We looked at the view TL_EMPL_NAME_VW and it is setup as a SQL View. However, when we looked at the syntax it uses the following:

SELECT DISTINCT A.EMPLID, B.NAME_DISPLAY
FROM PS_TL_ADM_SRCH_VW A
, PS_PERSON_NAME B
WHERE A.EMPLID = B.EMPLID
 AND A.OPRID = %OperatorID

From our understanding the %OperatorID syntax is only compatible with Dynamic Views and not SQL Views. Is this a true statement? When we change the Record Type from SQL View to Dynamic View, the Prompt lookup button on Employee ID is now limited to only employees available to this user based on Row Level Security. Should this be a SQL View with Key field OPRID added? This is another way to limit results or append the Operator ID to the SQL Text. Or should this be in fact a Dynamic View?

As indicated, the SQL View TL_EMPL_NAME_VW is delivered with SQL text which includes %OperatorID. To my knowledge this only works with Dynamic Views, but this is delivered as a SQL View. So this is a bug.

I understand the user would not get results returned if they do not in fact have access to the employees. That is working as designed, but I was identifying the SQL Text as a problem. It either should be a Dynamic View, or the SQL Text needs to be redesigned.

If we use the Get Employee button without entering search criteria, we do get the only the users employees based on TL dynamic groups.

REPLICATION STEPS
=================
1.  Navigate to Manager Self Service>Time Management>Report Time>TimeSheet
2.  click on lookup for EMPLID field
3.  all employees are returned rather than only the employee's that the manager has access to.


Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms