SAP Knowledge Base Article - Public

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


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"


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


  • SAP SuccessFactors HCM Suite
  • Report Canvas - Advanced reporting query


  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


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


SAP SuccessFactors HCM suite all versions