2297822 - Item title not showing in custom report

Item title does not show in custom report.

SAP SuccessFactors Learning

When querying the "PA_CPNT" table, the "CPNT_TITLE" column doesn't return the item title itself, but a label ID.

Additionally, 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. 

From the 1511 version release, a new table was introduced 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.

Please adjust your custom report code to include and get the item title from the "PV_I18N_ACTIVE_LOCALE_LABEL" table.

Note: as documented in the KBA 2379690 - Custom Report Development and Support, custom reports troubleshooting and support are beyond Product Support scope. Alternatively, please proceed with the following steps:

• Use the standards reports from SF Learning system to retrieve the required reporting information;
• Contact the report developer who built these reports for you or a consultant currently working with you on custom reports;
• Engage SAP Professional Services via your CSP (see article for more details in the KBA 2149831).

• 2379690 - Custom Report Development and Support - SAP SuccessFactors Learning
• 2149831 - SAP Professional Services / SAP Certified Partner / SAP Account Management Team [SuccessFactors Cloud]
• Data Dictionary and Database Changes

lms, learning, sf, successfactors, custom, report, item, title, not, show, display, showing, report, pa_cpnt, cpnt_title, label, id , KBA , LOD-SF-LMS-CRI , Custom Report Issues , LOD-SF-LMS , Learning Management System , Problem