Symptom
Item title not showing on custom report.
Environment
SAP SuccessFactors Learning
Reproducing the Issue
- When querying the "PA_CPNT" table, the "CPNT_TITLE" column doesn't return the item title itself, but a label ID >
- When running a custom report, the item title based upon the "CPNT_TITLE" column of the "PA_CPNT" table brings a label ID instead of the title itself.
Cause
From the 1511 version release, we introduced a new table in the database that would store all custom labels.
All newly created item titles and their labels will be stored in the table "PV_I18N_ACTIVE_LOCALE_LABEL" table and not in the "PA_I18N_ACTIVE_LOCALE_LABEL" one.
Resolution
Please, adjust your custom report code to include and get the item title from the "PV_I18N_ACTIVE_LOCALE_LABEL" table.
See Also
Keywords
custom, report, item, title, not, show, display, showing, report, pa_cpnt, cpnt_title, label, id , KBA , LOD-SF-LMS , Learning Management System , LOD-SF-LMS-REP , Reporting Data , LOD-SF-LMS-CRI , Custom Report Issues , Problem