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
- Duplicate the report
- Go to the edit page
- Go to the validation page
- Select the report and go to the option validate on the right side.
- 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