SAP Knowledge Base Article - Public

2960781 - "Null Value" in Offer Letter Status (Adhoc Report) - Recruiting Management

Symptom

When filtering by the Offer Letter Status, a "(Null Value)" is displayed.

"Image/data in this KBA is from SAP internal systems, sample data, or demo systems. Any resemblance to real data is purely coincidental."

Environment

SAP SuccessFactors Recruiting Management

Reproducing the Issue

  1. Go to Reporting.
  2. Select Recruiting V2.
  3. Select "Offer Letter".
  4. Select the field "Offer Status". - This label can change based on the customer's configuration.
  5. Filter by it and notice the "(Null Value)".

Cause

The Offer Status field in the Offer Letter entity is only updated when the "Online Offer" mode is used. For other mode like "Verbal", "Print" and "Text", the Offer Status does not have any value, therefore it will bring a "Null Value".

Resolution

When creating a report, you must use the "Send Mode" field to know how the Offer was created and whenever the "Verbal", "Print" and "Text" modes are selected, it's expected to have a "Null Value" if you are using the Offer Status field.

Keywords

Offer, Null, Value, Status, Letter, Mode, Online, Filter , 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