SAP Knowledge Base Article - Public

3164338 - Unable to search user in proxy now, org chart or employee files

Symptom

  • Admin user with "proxy management" permission and target population ALL employee can not search some users in Proxy Now
  • Using proxy now you are unable to search users, users are also not searchable in employee files or org chart search.
  • Unable to search users on Proxy Now, Org Chart and Employee Profile.

 "Image/data in this KBA is from SAP internal systems, sample data, or demo systems. Any resemblance to real data is purely coincidental."

Environment

SAP SuccessFactors HXM Suite

Reproducing the Issue

  1. Select Proxy Now
  2. Enter Target User
    User is not found

OR

  1. Try to search target user in Employee Profile and Org Chart
    User is not found

Cause

Cause 1:

The scope of proxy, Org chart and My Employee Files search is Employment scope. When the status of the user employment is in the past the user will not be searchable.

Cause 2:

The employee-status picklist is wrong. The correctly configured picklist values have been set to status "inactive" and new picklist values with wrong non-unique external codes have been created instead. This leads to unexpected system behavior and should not be done.

Cause 3:

The employee-status picklist has data inconsistency related to the duplication of Non-unique External codes in its definition.

Resolution

Whether required employee status values are defined can be checked with the Check Tool check "Required employee status are defined".

Whether or not employee status values are used in job info records can be checked in the Data Inspector.

Example:

Entity = Table_EMP_EMP_JOB_INFO_T
Filter Criteria = Employment status

Solution #1:

Validate employment scope as below:

  1. Employment Details on My Employee Profile Page.
  2. Data Inspector Tool under the Table_EMP_EMPLOYMENT_INFO table > validate End date is not in the past ( see screenshot below )

Solution #2:

To correct picklist status, please review KBA 2853514 - Inactivating a MDF Picklist - SAP ONE Support Launchpad

Solution #3:

  • In order to fix this code duplication, just edit the duplicated “Non-unique External codes” and change their values 
  • For example like in the screenshot above the "Non-Unique External Code" A to be renamed A1, and repeat for the other duplicated "Non-Unique External Code"
  • After the correction is done follow the below steps:
    • check if the option Ids of the changed entries are in use:

      To do this, you need to go to Data Inspector --> select Table_EMP_EMPLOYMENT_INFO and search for Employment Status. In case some of those option Ids are used, we need to create a DB script to change the option Ids (eg. From 1674 to 1811 if we take the example from the screenshot) --> Customers Approval is needed

    • You will also need to check Employment Status for your Event Reasons:

      To find out where you use the changed event reasons please go to Data Inspector --> Entity Table_FO_EVENT_REASON_T and search for the corresponding option Ids for Employment Status. If some of those option Ids are used, you can change it yourself via UI by editing the event reason (See KBA 2274816 - How to Create An Event Reason for reference)

See Also

Keywords

data inspector, Table_EMP_EMPLOYMENT_INFO, Table_FO_EVENT_REASON_T , proxy now, employee-status, picklist, non-unique external code, event reason , KBA , LOD-SF-PLT-PRX , Proxy , LOD-SF-EC-JOB , Job Information , Problem

Product

SAP SuccessFactors HXM Suite all versions

Attachments

duplicated non-unique external code.png
Pasted image.png