2083987 - Values in Worksheets are Not the Same as in Reports/Data in Compensation

• When looking at a compensation worksheet, you may see different values than in some reports or executive reviews
• How to make sure comp reports and worksheets have the same data

SAP SuccessFactors Compensation

Possible Explanations

• Worksheets are created, then new data is imported via compensation import file. The data is correct in employee profile information, and shows correctly when exported back out via the employee export, but has not updated in the worksheet.
• Most common cause is due to the fact the field is set as reloadable = "false". See KB article 2078001
  
  
• Editable=True: This is basically same asreloadable=False.  Editable fields are not supported in Mass Update. So if you have an editable field you are saying it must be updated by a person typing in the new value. To protect the data entered manually in any field set as editable="true" we will not apply any new values imported when the "Update Compensation Form" function is run.
• To get the value that has been imported to apply to the worksheet you would literally have to open the compensation form and click save to replicate a manual update. Again, this is expected behavior to protect values that had manually been entered by your managers from accidentally being overwritten.
  
  
• Person is looking at an enroute copy of the worksheet and not most current live version being edited. One of the most common reasons of a person not seeing the most current data is that the worksheet is not actually with them, but is in someone else's Inbox. This means that they are only seeing an Enroute Copy of the form. This is a snap shot in time and will NOT show the most current data that someone may have recently entered. See KB article 2088748
  
  
• Person was sent a "Copy" of the worksheet before all edits had been completed. It is possible to send a person a copy of a form. This will only show information at the time it was sent. if it was later updated via executive review or an import, the sent copy may now be out-of-sync. See KB article 2078001
  
  
• Template Setting "Keep Last Touched Version: When this option is enabled on a template, people early on in the route map/workflow will only ever see the data as reflected at the time they held it. They will not see any new edits made by people later in the workflow. See KB article 2077400
  
  
• An Executive made an edit to the data after forms were completed via Executive Review. Others do not see most current data while the one making the edit does. Safest way to update the incorrect version is to move the form back to in-progress > Open Form >  Click Save to see the current data. (Alternatively use Update Compensation Form)
  
  
• Executive Review Missing People: If you change managers mid-cycle remember that the executive review reports on the current regular management hierarchy. So if you change this via an import mid cycle, then people no longer reporting to the manager on record in the compensation worksheet will no longer see these people in their executive review. This is not a bug and is working as designed.
  
  
• Do not automatically retrieve compensation data: When this feature is enabled the Executive Review will not automatically show the most current data until you trigger the update
• Your daily User Imports are inadvertently including updated data when people are still working on worksheets for a "reloadable" field. Make sure that you are not doing employee imports each night that are linked to compensation fields unless you want this to update and understand the impacts.
  
  
• The order of events in your workflow: Admin or planner imported data at some point after the person seeing the wrong data got their copy of the worksheet, and data has not yet been 'pushed' to all holders of the form. Similar variations on this are explained below.
  
  
• Less common but certainly possible.. Compensation worksheet was in edit mode with the planner, and therefore locked, at the same time new data was being updated via imports. Since the worksheet is locked the data is not updated and pushed through to reporting tables.
• Safest way to update the incorrect version is to move the form back to in-progress > Open Form >  Click Save to see the current data. (Alternatively use Update Compensation Form)
  
  
• Updates to PM GM: Less common but certainly possible.. A unique series of events where individual's are updating PM forms or goal plans feeding into your compensation plan, at a point in time that did not trigger the update & push of data to the reporting tables.
• If you have updated Goal Plans or PM Forms and this data has not pushed into Worksheets or Reports, then try this first: Go to Admin Tools > and use the "Open & Save" feature to trigger the "update event".Try this first, as this will cause data from goals and forms to get to worksheet. Wait 30-60mins. Then if data in reports or Executive Review is still not in sync, then use Update Compensation Form feature.
  
  
• Reporting tables for one of the above reasons did not get current data pushed to them to be made available to all worksheets. To learn more about Reporting tables and how it is possible that they are not always in sync, please review this solution.
• First: Go to Admin Tools > and use the "Open & Save" feature to trigger the "update event". Try this first, as this will cause data from goals and forms to get to worksheet. If you have thousands of forms you may need to wait 30-60mins or longer. Then if data in reports or Executive Review is still not in sync, then use Update Compensation Form feature. 

Note: SuccessFactors does not store a comprehensive audit trail of every admin or user action to provide insights into the series of events for your scenario. Above we outline the most likely causes of why data is not in sync, and technically how that is possible. This information will help you determine, based on your knowledge of your process, what the most likely event in your case would have been. Without a specific audit trail showing exactly what happened in your instance and the order in which occurred, Product Support cannot tell you which of the above options happened in your case, and therefore will not be able to state with certainty how to prevent this in the future, other than understanding and the principles described above. 

How to Update Compensation Worksheets and Reports to Re-sync Data

• The above scenarios are the current design of the product and NOT indicative of any defect or gap in functionality
• It is expected due to the many possible timings of who and when data is updated, some of these "events" do not automatically trigger a "push" of the data to reporting tables
• This is a deliberate design to ensure worksheets are not updated when it was not desired
• For any and all examples where you identify worksheets or reports not in sync, you can use the feature Update Compensation Form

IMPORTANT: DO NOT USE THIS OPTION UNTIL FIRST UNDERSTANDING THE IMPACTS TO YOUR FORMS AND DATA

KB article 2084675 - Update Compensation Forms and Update Compensation Forms for Template

SF, Success Factors, CMP, manage data, admin , KBA , sf error messages comp-varpay , LOD-SF-CMP-FRM , Forms & Templates , How To