How to Query on Future Dated Job Rows?
Last updated on MAY 08, 2018
Applies to:PeopleSoft Enterprise HRMS Human Resources - Version 9 to 9.1 [Release 9]
Information in this document applies to any platform.
***Checked for relevance on 29-July-2013***
Does the PS_EMPLMT_SRCH_QRY limit the return of future-dated JOB rows?
Will the change of the Security Records of Job and Personal component from PS_EMPLMT_SRCH_QRY to PS_PERS_SRCH_GBL affect Payroll or other area of HR in any way?
Are there other options for the user to return future dated rows using Query?
PS query doesn’t show the future dated rows of NAMES record due to Query Security record PS_PERALL_SEC_QRY. Suggest an alternative.
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