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: : 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