Symptom
- In curricula where multiple items are required from an item pool, the requirement completion date (PA_STUD_QUAL_REQ.COMPL_DTE / PH_STUD_QUAL_REQ.COMPL_DTE) reflects the first item completion date in the most recently completed set, rather than the date when all required items were completed.
- In curricula where only one item is required from an item pool, the requirement completion date updates to the most recent item completion date each time another item is completed.
Environment
SAP SuccessFactors Learning
Reproducing the Issue
- Identify a curriculum with a requirement that requires multiple items from an item pool >
- Complete the required items on different dates (ensure the requirement becomes satisfied) >
- Query PA_STUD_QUAL_REQ or PH_STUD_QUAL_REQ via custom report or database query >
- Observe that the requirement completion date displays an earlier item completion date rather than the date the last required item was completed.
OR
- Identify a curriculum with a requirement that requires one item from an item pool >
- Complete the a required item on different dates (ensure the requirement becomes satisfied) >
- Query PA_STUD_QUAL_REQ or PH_STUD_QUAL_REQ via custom report or database query >
- Observe that the requirement completion date is updated to the most recent item completion.
Cause
- When any course within a requirement that requires multiple items from a pool is completed, the system works backward from that most recent completion to find the most recent point where the full set of required items was satisfied.
- From that completed set, the earliest course completion date is stored as the requirement completion date (PA_STUD_QUAL_REQ.COMPL_DTE / PH_STUD_QUAL_REQ.COMPL_DTE).
- If only one item is required, each subsequent item completion re-satisfies the requirement, so the requirement completion date updates to that latest item’s completion date.
Resolution
- After extensive reviewing of the code and system behavior, our engineering and Product Management confirmed that the system is currently working as expected based on the existing code and this has been the system behavior since the very beginning of LMS.
- Currently they will opt for maintaining different system behavior for curricula requirement pools with one item required when compared with curricula requirement pools with multiple items required. Making changes on the curriculum calculation logic now may result on negative impact on historical data and audit reporting of this data.
- If a different outcome is desired (for example, storing the last item completion date for multi‑item requirements), kindly submit an enhancement request (see KBA 2090228 - How to submit enhancement ideas for SAP SuccessFactors Products).
See Also
Keywords
learning, lms, pa_stud_qual_req, ph_stud_qual_req, requirement, completion date, curricula requirement, item pool, multiple items, single item, earliest completion date, latest completion date, expected behavior, discrepancy, inconsistent , KBA , LOD-SF-LMS-CUR , Curricula , Problem
Product
SAP SuccessFactors Learning all versions
SAP Knowledge Base Article - Public