Duplicate rows returned on running a query on future dated jobs using EMPLMT_SRCH_GBL View
(Doc ID 1570206.1)
Last updated on DECEMBER 16, 2020
Applies to:PeopleSoft Enterprise HCM Human Resources - Version 9.1 to 9.2 [Release 9]
Information in this document applies to any platform.
Issue : When attempting to query future dated jobs using EMPLMT_SRCH_GBL View, duplicate rows are returned.
The issue can be reproduced at will with the following steps:
1. Select an emplid KEG010 who has future dated rows in system
2. Change query security record to EMPLMT_SRCH_GBL in PS_JOB in application designer.
3. Query future dated rows as well as current rows.
4. See duplicate rows in query.
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!
In this Document