SAP Knowledge Base Article - Public

2528224 - Blank Report for "Assignment Profile Related Data Audit Report (CSV)"

Symptom

We are not getting any data if we downalod “"Assignment Profile Related Data Audit Report (CSV)"” report from the system.

Environment

SuccessFactors Learning Management System (LMS) - All Supported Versions

Reproducing the Issue

1. Logon to LMS Leanring Administraiton and navigate to Reports> search for Assignment Profile Related Data Audit Report.

2. Run the Assignment Profile Related Data Audit Report by populating the Assignment profile ID

No data.JPG

Cause

The "Assignment Profile Related Data Audit Report (CSV)" Report is designed only to provide the AP History logs if we have an ITEM associated with it. Else the report would fetch blank data. Its a legacy report and we did confirm this by reviewing the query in the report which is as below.

select 'ITEM' as TYPE,

a.CPNT_ID || ':' || a.CPNT_TYP_ID || ':' || to_char(a.REV_DTE, 'mm/dd/yyyy') as KEY,
a.AP_ID,
a.STATUS,
a.CREATE_TSTMP,
a.LST_UPD_USR,
a.LST_UPD_TSTMP,
DECODE(a.ACTION,'I','label.Insert', 'M','label.Modify', 'D', 'label.Delete', 'U', 'label.Update') as ACTION

Resolution

Its system expected behavior that until we have an ITEM associated with an Assignment profile we will not be able to view the history logs on the DB Table PH_CPNT_AP.

Keywords

PH_CPNT_AP, No Data on report, Assignment Profile Related Data Audit Report (CSV) , KBA , LOD-SF-LMS-REP , Reporting Data , LOD-SF-LMS-ASP , Assignment Profile , Problem

Product

SAP SuccessFactors Learning all versions