SAP Knowledge Base Article - Public

2846210 - Time Account Detail showing validation error for effective start date - Advanced reporting

Symptom

When running existing standard report Time Account Detail an error is received. The validation error message that is received is the following:

"Column MEMB_EFFECTIVE_START_DATE is not found in the Table 'TimeAccountDetail"

2019-10-04_15-03-47.jpg

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 HCM Suite
  • Report Canvas - Advanced reporting query

Resolution

  1. Duplicate the report
  2. Go to the edit page
  3. Go to the validation page
  4. Select the report and go to the option validate on the right side.
  5. Select the option delete the column and this will correct the behavior

Keywords

Validation error - MDF Effective Start date - TimeAccount detail , KBA , LOD-SF-ANA-ADV , Advanced Reporting (ODS) , Problem

Product

SAP SuccessFactors HCM Suite all versions