SAP Knowledge Base Article - Public

3287800 - 900-001-6 Error when accessing Executive Review


900-001-6 Error when trying to sort data in EXR compensation and variable pay template. 

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


SAP SucessFactors Compensation

SAP SucessFactors Variable Pay

Reproducing the Issue

Navigate to EXR > click on the template > Sort based on one of the columns ((totalRaise, mgrFirstName, mgrLastName, totalIncrease, totalComp) > the following error is received. 

Support can check in splunk with <Company ID> AND AcmeServlet , the logs should like below
SQLException SAP DBTech JDBC: [260]: invalid column name: not included in SELECT DISTINCT column list: 


Engineering team is aware of this issue and are working on the fix. 


Workaround : To create custom column OR not use the fields(totalRaise, mgrFirstName, mgrLastName, totalIncrease, totalComp) for sorting. For mgrFirstName, mgrLastName fields a custom reportable field mapped to Employee Profile > Manager field can be used to sort.

This issue has been resolved as part of patch23 released on Jan 23rd (prev) and Jan 25th(prod).


sorting in EXR, error in EXR, KI2211 , CMP-30038 , KBA , LOD-SF-CMP-EXR , Executive Review , Problem


SAP SuccessFactors HXM Core 2211