SAP Knowledge Base Article - Public

2678132 - AdHoc report in Recruiting Domain generating error when using location

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

https://help.sap.com/viewer/11d9a34143aa428283389b3981bfbed9/1805/en-US/383e32e84a07491eb36a9ca1361330ae.html

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

Product

SAP SuccessFactors Recruiting all versions ; SAP SuccessFactors Workforce Analytics all versions