SAP Knowledge Base Article - Public

3594464 - Story Report is throwing an error when using Recruiting Date fields in Calculated Columns - Recruiting Management

Symptom

When using Recruiting Date fields such as Candidate Created Date or Application Created Date in Calculated Columns the following error appears:
"We found an issue while processing the request. For assistance, please contact the administrator of the SAP Product Support team, if needed.
Correlation ID:"

"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. Create a Story Report using Recruiting Date fields for example:
    - From Candidate table select Created Date or Created Date (Timestamp)
    - From Application table select Created Date or Created Date (Timestamp)
  3. Go to Calculate Data
  4. Select the Formula button (Fx+) and Calculated Columns
  5. Create a formula
  6. Validate formula by clicking on "Format"
  7. Click on "Preview Query"
  8. The error below appears:

Resolution

Engineering confirmed that this error is considered expected behaviour due to a product limitation and they are working to enhance this feature.
Currently the enhancement is not in the route map.

To follow this enhancement please contact your account manager and give them this internal ticket number RCM-151905.

Keywords

Story, Report, Reporting, Correlation, Error, Created, Date, Application, Candidate, Issue, Processing, Request, Preview, Query. , KBA , LOD-SF-RCM-REP , Reporting & Analytics, Data Imports & Exports , LOD-SF-ANA-SAC , Stories in People Analytics , Problem

Product

SAP SuccessFactors HCM Core all versions

Attachments

Pasted image.png
Pasted image.png
Pasted image.png
Pasted image.png