SAP Knowledge Base Article - Public

2300090 - Program title and program description not recorded in PA_Program Table after b1602 release

Symptom

Since the release of b1602 (Q1 2016 release), the Program title and description details are no longer available in the PA_PROGRAM table

Environment

SuccessFactors Learning Management System (LMS) - All Supported Versions since b1602

Cause

The release included a change to the PA_PROGRAM table which resulted in the title and description data for any Program has been moved to the PA_CPNT table.

Resolution

Please update your custom reports to use the below query to fetch the program title and program description values.

Example:

SELECT
cpnt.CPNT_TITLE, cpnt.CPNT_DESC
FROM PA_PROGRAM p, PA_CPNT cpnt
WHERE cpnt.CPNT_TYP_ID = p.CPNT_TYP_ID
AND cpnt.CPNT_ID = p.CPNT_ID
AND cpnt.REV_DTE = p.REV_DTE;

Keywords

PA_PROGRAM; PA_CPNT; Reports; Custom Reports; Program Title; Program Description; Programs; , KBA , LOD-SF-LMS-REP , Reporting Data , LOD-SF-LMS-PRD , VJDBC Setup or Connection Issues , Problem

Product

SAP SuccessFactors Learning all versions