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.

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