SAP Knowledge Base Article - Public

2283714 - Standard Fields from Offer Detail Template in Adhoc Reports - Recruiting Management

Symptom

  • When creating an ad-hoc report for a specific Offer Detail Template the system shows columns for a field that is not even defined in the template itself. In addition, when running the report that column shows up data and those values seem to come from a Picklist.
  • A standard field (standalone fields) from the Offer Details XML is not visible in the Adhoc Reports Offer Details table.

Environment

SAP SuccessFactors Recruiting Management

Reproducing the Issue

SCENARIO 1

  1. ]Go to Reporting and create an Ad-hoc Report
  2. Select "Recruiting V2" domain and select the columns related to the Offer details
  3. Then you can see that a field not defined in the template show up
  4. Select that field and run the report

SCENARIO 2

  1. Go to Reporting and create an Ad-hoc Report
  2. Select "Recruiting V2" domain and select the columns related to the Offer details
  3. Search for a field from the template
  4. See that the field is not there

Cause

More than one Offer Detail Template are using the same "customPicklist" field ID but with different labels.

This is a configuration issue because the fields must be configured identically in each template.

More in detail, let's consider the scenario:
OfferTemplate_A  is using Field-ID="customPicklist4" with label "Custom_label_A" linked to "Picklist_A"
OfferTemplate_B  is using Field-ID="customPicklist4" with label "Custom_label_B" linked to "Picklist_B"

When the user create a report for OfferTemplate_A the column with label "Custom_label_B" appears to be reportable.
But the data under column "Custom_label_B" are related  "Picklist_A" and not  "Picklist_B"

Basically the system is showing the "correct data" under the "wrong label".

Resolution

As the fields must be configured identically in each template, the solution will be to:

Update the Offer Details Template and make any "customPicklist" (or, could be customString, customLong or customDate) field with the same label/same Picklist in each Offer template.

NOTE: There are only 10 supported fields available: "customPicklist1" to "customPicklist10" and the configuration must be referred to an SAP Partner.

Keywords

customPicklist, picklist, label, field, missing, reports, extra. , KBA , LOD-SF-RCM-REP , Reporting & Analytics, Data Imports & Exports , LOD-SF-RCM-CAO , Candidate Offers, Offer Letters , Problem

Product

SAP SuccessFactors Recruiting all versions