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
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