Symptom
What data is stored on the Database table PA_LEARNING_PLAN_REQ?
Environment
SAP SuccessFactors Learning
Reproducing the Issue
- Verify tables PA_STUD_QUAL_REQ and PH_STUD_QUAL_REQ >
- There are curricula requirements associated to users >
- Verify data available on the PA_LEARNING_PLAN_REQ >
- There is no data associated to the user despite them having Curricula requirements assigned.
Resolution
While the PA_STUD_QUAL_REQ and PH_STUD_QUAL_REQ tables bring results related to which curricula requirements are associated to users, the PA_LEARNING_PLAN_REQ table stores the data of the User Learning Plan Notifications that are triggered to the user which contain data related to the curricula requirements assigned to them.
Therefore, the PA_LEARNING_PLAN_REQ table will be populated once the Learning Plan Email Notification is triggered to the user, and only if the notification contains details related to the curricula requirements assigned to them.
Keywords
PA_LEARNING_PLAN_REQ, PA_STUD_QUAL_REQ, PH_STUD_QUAL_REQ, curricula, requirement, database, table, empty, data, assigned, user, admin, learning, plan, item, assignment, store , KBA , LOD-SF-LMS-REP , Reporting Data , How To