SAP Knowledge Base Article - Public

2297822 - Item title not showing on custom report

Symptom

Item title not showing on custom report.

Environment

SAP SuccessFactors Learning

Reproducing the Issue

  1. When querying the "PA_CPNT" table, the "CPNT_TITLE" column doesn't return the item title itself, but a label ID >
  2. 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

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

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

Product

SAP SuccessFactors Learning all versions