Symptom
Existing adhoc report generating error that is pointing to the location field. See error message below:
"Logical column is invalid for logical column id : recruitingV2#RCM_JOB_REQ#LOCATION_OBJ Logical Column Key :
{ name: recruitingV2#RCM_JOB_REQ#LOCATION_OBJ, messageKey: null}"
Environment
- SAP SuccessFactors HCM Suite Recruiting
- SAP SuccessFactors Workforce Analytics
Reproducing the Issue
Execute an existing report with the location configuried and report breaks.
Cause
In b1805 the location field is a now supported as a multivalued field with this change it is causing existing reports with the location field configured to fail.
Resolution
If a Job Requisition has more than one Location value, the Job Requisition will be displayed in Ad Hoc Reports as multiple lines, with one line per Location. There is a new column called Primary Location, which indicates which among the various Location values is the Primary one.
If you have an existing Ad Hoc Report with the Location field configured, the report should be reconfigured with the Location field again. If this is not done, the existing reports will break.
To resolve this error, you will need to remove the field location column from the report and it add location back this will resolve the issue.
See Also
2652937 - Multi-location Job Posting Feature - Recruiting Management
2677334 - Option for Multi-Select in Manage Templates
Keywords
Location field Adhoc report breaking Multi Location , KBA , LOD-SF-RCM-REP , Reporting & Analytics, Data Imports & Exports , Problem