Symptom
Values are not fetched from job relationship to custom field "Second Manager" in compensation worksheet.
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 Compensation
- SAP SuccessFactors Variable Pay
Reproducing the Issue
In the Design Worksheet, you have made a custom field named as Second Manager, for it to be fetched from job relationship. But when you launch worksheets the data is blank even though you have mapped everything correctly.
Kindly check the following things before you move on:
- The option id of second manager is same as the one which is mapped to job relationship of employee, if you have same label for multiple picklists, Kindly change the picklist label such that each Second Manager is distinguishable without knowing its option id.
Job relationship in Employee profile: - The user have second manager mapped correctly. (this should be checked only if the user worksheet is not launched with second manager hierarchy, since there would be no worksheet for that user if it wasn't mapped correctly)
- The mappings in design worksheets are :
To fetch user id:
Column Type: String
EC category: Job Relationships
EC component name: Compensation Manager(Option ID) (this is from the picklist jobRelType)
EC field : Name
To fetch Name of the Second Manager:
Column Type: Username
EC category: Job Relationships
EC component name: Compensation Manager(Option ID) (this is from the picklist jobRelType)
EC field : Name
Cause
The Second Manager Field appears Blank due to the jobRelType picklist.
Please note, if you have multiple picklist with same name ( most likely to associate with different parent picklist) like below:
You might also have same Non-unique external code in all of them.
When this happens, the data is not being fetched.
Resolution
Kindly check if all the second managers maintained in this picklist have same Non-Unique external code, if yes change it slightly( add number/symbol in them to make unique)
Once you do the changes, delete the worksheet and do the mappings again in design worksheet( as the previous mapping were just edited now), then launch the worksheet again.
Once you do the data starts appearing:
See Also
Keywords
Second Manager, Job Relationship, custom field, blank, empty, picklist, showing, value, custom, relationship type, job, relationship, jobRelType, Compensation, cmp, Variable pay, vrp, mapping, compensation manager, Non unique, external code, comp manager, worksheet, executive review, unique, same, not visible, invisible, not fetching, second, manager, eligible, employee profile, data, portlet, ECT-187144 , KBA , LOD-SF-CMP-EC , EC data, EC mappings, configuration & settings , LOD-SF-VRP , Variable Pay Programs , LOD-SF-CMP , Compensation Management , Known Error