2303225 - Program title and description data fields are null in custom reports

This is regarding custom reports utilizing the program title and description fields. Since the 1602 Learning release, it's not possible to return data from the "PA_PROGRAM" table to populate the custom reports.

1. Customize the "Program User Status Report" using PRD >
2. Include the "Program_Title" field from the "PA_PROGRAM" table >
3. Run the custom report >
4. The program title fields return no data.

As part of the 1602 version, the program title and description data was moved from the "PA_PROGRAM" table to the "PA_I18N_LOCALIZED_LABEL" one.

This data can now be found in the "PA_I18N_LOCALIZED_LABEL" table.

In PRD, you will need to query both "PA_CPNT" from the label ID of the program and also the "PA_I18N_LOCALIZED_LABEL".

Example:

SELECT b.label_value, b.label_value_full

FROM pa_cpnt a, PA_i18n_localized_label b

WHERE a.cpnt_title = b.label_id AND a.cpnt_id = '*** Your Program ID ***';

2379690 - Custom Report Development and Support - SAP SuccessFactors Learning - SAP for Me

lms, custom, report, program, title, description, column, field, status, report, null, blank, prd, PA_I18N_LOCALIZED_LABEL, pa_cpnt, PA_PROGRAM , KBA , LOD-SF-LMS-PRO , Programs , LOD-SF-LMS-CRI , Custom Report Issues , LOD-SF-LMS , Learning Management System , LOD-SF-LMS-REP , Reporting Data , Problem