2219862 - Customized report is failing due to PRD data type parameter

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

When running a customized version of the Class Roster report, the system returns a 'Failed' error for all users attempting to run the report.

SAP SuccessFactors Learning (LMS)

1. Go to LMS Admin > Reports
2. Locate the customized report
3. Run this report within certain parameters
4. The report will return a failed status

This report has been modified/customized on your side.  This is outside of SAP Support scope (see KBA 2379690); however the following was shared in cusotmer community post no longer available:

ScheduleSearch is not a Plateau Selector, so that type has to be correctly match the DB data which is of Integer type

This is outside of SAP Support scope (see KBA 2379690), please revert to use the standard class roster report; however the following was shared in cusotmer community post no longer available:

Apply the resolution via Plateau Report Designer (PRD) - In the reports there is a 'String' as data type, which needs ot be changed to 'Integer' for ScheduleSearch, see below screenshot.
Note: In earlier BIRT code data type may not be that specific but still need to provide correct data type for newer Databases.

sap, sf, successfactors, success, factors, learning, lms, SignInSheet, SO, Scheduled Offering, class, Roster, PRD, custom, report , KBA , LOD-SF-LMS-PRD , VJDBC Setup or Connection Issues , LOD-SF-LMS-REP , Reporting Data , Problem