HCM: From Profile Views Search Page, if Enter a Specific EMPLID and Search, No Results Returned
(Doc ID 2935127.1)
Last updated on JANUARY 26, 2024
Applies to:
PeopleSoft Enterprise HCM Human Resources - Version 9.2 to 9.2 [Release 9]Information in this document applies to any platform.
Symptoms
From Profile Views, if enter a specific EMPLID and search, notice no results returned. It was determined that a row does not exist for EMPLID in the table PS_JPM_PROFILE.
The issue can be reproduced at will with the following steps:
1. Log in as an Administrator
2. Setup HCM > Product Related > Profile Management > Profile Types
Profile Type - PERSON, Person Profile configuration to require an approval
for Degrees and License.
3. For an active employee, ensure has a User Profile associated to EMPLID.
4. Add Onboarding template instance for the Employee
Navigation: Set Up HCM > Common Definitions > OnBoarding > Manage OnBoarding
Event > Manage OnBoarding Event
5. Log in as the Employee
6. Access Onboarding Tile, access Talent Profile, and add a License.
7. Log in as Administrator and From Approve tile, approve the Talent Profile for License and notice that new JPM_PROFILE has been added for the Employee.
8. Log in as an Administrator with access to another Employee
9. Navigate to Workforce Administrator Dashboard > Profile Administration > View Profiles
10.{enter} specific EMPLID and notice receive message, "No matching values found"
Troubleshooting Steps:
Use the SQL below to identify the number of Profiles impacted from Issue:
select distinct JPM_PROFILE_ID FROM PS_JPM_JP_CAT_TYPE A WHERE
A.JPM_PROFILE_ID NOT IN (select b.JPM_PROFILE_ID FROM PS_JPM_PROFILE B)
Changes
Cause
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
| Symptoms |
| Changes |
| Cause |
| Solution |
| References |