Symptom
In the 'Employees Associated with Invalid HR Data' Page, you will see the Foundation Object listed twice and if you click on any of these, an Application Error occurs. It is observed to occur on Legacy Foundation Objects.
Environment
- SAP SuccessFactors Employee Central - Foundation Objects
Reproducing the Issue
1. Go to Admin Center > Employees Associated With Invalid HR Data.
2. In the 'Employees Associated With Invalid HR Data' Page, click on the problem Foundation Object which you'll notice is appearing twice.
3. An Application Error appears.
Note: You may see the Application Error upon page load if no other FO or GO have issues except the FO that is being referenced twice. For example, in the above screenshot, if Legal Entity, Cost Center, Department, and Job Classification have no issues or aren't there and only Location has invalid data, the system will immediately show you the Application Error upon page load.
For Product Support, please see Internal Memo.
Cause
The same Foundation Object is being referenced by two fields. For example, in addition to the pre-delivered Location field that references the Location FO by system design, there is another custom field that also references the same Location FO in the Data Model/Business Configuration.
Resolution
Currently, this kind of configuration is breaking the 'Employees Associated with Invalid HR Data' Page. It is not handled by the queries that are executed to get the invalid HR Data associations.
As a workaround, remove the custom field that is referencing the same Foundation Object.
A new Admin Alerts Framework is currently being redesigned to handle such issues. Please monitor this KBA for future updates.
Keywords
application error, invalid hr data, Employees Associated with Invalid HR Data, column ambiguously defined, ECT-110726, STE-10625 , KBA , LOD-SF-EC-ADM , Admin Tools (EC Core only) , Problem