SAP Knowledge Base Article - Public

2076690 - Admin 101 - Top 10 Reasons Worksheets Wont Create - Variable Pay


  • Common reasons that variable pay forms do not create as expected.


  • Variable Pay


  • Various Causes. These are ordered in most common.


  1. Forms wont create for anyone.
    1. First check that all data files have been correctly imported to the program. One way to check this is by going to admin tools > configure varpay program> 
      1. This is where you import all your data files. You should see that records now exist for: Business goals, Employee History, Eligibility Rules and finally Business goal Weights. If any of these do not show correct records then reimport all your files in the correct order and recalculate the plan.
      2. Make sure all Variable Pay data files are imported. Weight and Mapping always needs to be imported after importing the Business Goal File.
      3. Make sure you have calculated the forms.  (15. Calculate Bonus Payout).
    2. If you are using SECOND_MANAGER then head of hierarchy needs to be blank in your data file and NOT contain the text NO_MANAGER.
    3. Verify you have correctly connected all related files: Check the names in your program details with those shown in xml.
      1. Pay Matrix: Verify- xml template matches Admin tools:Pay Matrix <comp-pay-matrix><comp-pay-matrix-name>comp_payguide
      2. Currency Conversion Table: <comp-currency-conv-table><comp-currency-conv-table-name>COMP_CURRENCY_CONVERSION
      3. Stock tables: <comp-stock-value-table><comp-stock-value-table-name>STOCK_VALUES
      4. PM Form Template ID(s) PM Form Section in Variable Pay
        <comp-rating-source useFor="all" form-id="5" is-default="true" completed-only="false" use-calculated-rating="true">
        PM Form Section ID for Variable Pay (Section ID may have changed unintentionally if PM form config still being modified).
  2. Forms wont create for some
    1. Verify that Hierarchy loaded in data file matches xml
      1. <comp-manager-hierarchy type=“2"/> = SECOND_MANAGER column should be populated in your import file
        <comp-plan-creation rollup-users="1"/> = COMPENSATION_PLANNER should be populated in your import file
      2. If you are not using correct data field then likely forms are not creating for anyone. If though you just have incorrect data in the right column then forms may not crate correctly for random people.
  3. Verify Route Map - Ensure that role in first step exists in system. Try changing route map to simple E step to rule out Route Map issues. If this is not correct if could equally cause all to fail or just some to fail depending on the role relationships.
    1. e.g. If EX is first step in Route Map, and there are no Matrix Managers loaded, forms will not create.

    2. U step is not supported in Variable Pay route maps

    3. Tip: Try changing route map to simple E step to rule out Route Map issues.

  4. Make sure Employee History dates are in range of program dates.
  5. Make sure the Compensation Eligible column is true or blank in the Employee Data File.
  6. If using <include-eligible-users-only><![CDATA[true]]></include-eligible-users-only>, make sure the Compensation Eligible column is blank.

  7. If using Assignment Based Rating functionality make sure it is set up correctly.
  8. All pay range foundation objects must be complete.  If a currency code is missing from one pay range record, worksheets containing pay guide fields will not launch from the template.


KBA , sf varpay cycle preperation , LOD-SF-CMP-VAR , Compensation Integration Issues with Variable Pay , Problem


SAP SuccessFactors HCM Core all versions