Symptom
- An Ad Hoc report has been built for one of the following domains and a scheduled job has been setup in provisioning for the same:
Job Information (Date Range)
Person and Employment Info (as of Date)
Recurring Compensation Information (Date Range)
Non-Recurring Compensation (Date Range) - The scheduled run's output does not match with the output fetched from the instance by running it manually.
Image/data in this KBA is from SAP internal systems, sample data, or demo systems. Any resemblance to real data is purely coincidental.
Environment
SuccessFactors HCM core
Ad Hoc reporting
Reproducing the Issue
- Obtain the scheduled run's output.
- Login to the instance and run the same report manually.
- The results do not match.
Cause
- The output of date effected reports (as of date / date range) depends on the effective date we select while running the report.
- When a job is scheduled for such reports, we (SuccessFactors support) get to choose between static dates and dynamic values.
- If the filter date has been set as a static one, irrespective of when / how many times the job runs , the output will always be with effect of the same date, yielding the same output.
Resolution
- The effective date has to be a dynamic one / variable and It can be one among the following:
endOfCurrentMonth
endOfCurrentQuarter
endOfCurrentYear
endOfNextMonth
endOfNextQuarter
endOfNextYear
endOfPreviousMonth
endOfPreviousQuarter
endOfPreviousYear
lastSuccessfulRun
startOfCurrentFortnight
startOfCurrentFortnight
startOfCurrentMonth
startOfCurrentQuarter
startOfCurrentYear
startOfNextFortnight
startOfNextMonth
startOfNextQuarter
startOfNextYear
startOfPreviousFortnight
startOfPreviousMonth
startOfPreviousQuarter
startOfPreviousQuarter
startOfPreviousYear
today
tomorrow
yesterday - Additionally we can also include a (+) or (-) operator for Day(s), Month(s) or Year(s)
- Example 1: 'Person and Employment Info (as of Date)' report's schedule:
The effective date for the scheduled job has been set as '${today} - 365 days'
The report will always choose the date 365 days in the past, from the date the report is being run.
If the report is being run on the 19th of June 2016, the 19th of June 2015 will be considered as the effective date. - Example 2: 'Job Information (Date Range)' report's schedule
The start date has been set to '${startOfCurrentMonth} - 1 Month(s)' and the End date has been set to '{endOfCurrentMonth}' + 1 Month(s)'
The report will always include date for a span of 3 months - The Last month, Current month and the following month'
If the report is being run on the 19th of June 2016, the actual start date will be the 1st of May 2016 and the End date will be the 31st of july 2016. - Please review the options carefully and provide the same to us while creating a support case either for the initial schedule or for modifications of existing scheduled Ad Hoc report exports.
Keywords
Ad Hoc report export
Scheduled Report
As Of date
Date Range
effective dated report , KBA , LOD-SF-ANA-ADH , Adhoc Reports & Report Builder , LOD-SF-EC , Employee Central , Problem
Product
SAP SuccessFactors HCM Core 1605