SAP Knowledge Base Article - Public

3614986 - Criteria for records to be created in the PA_LEARNING_PLAN_REQ table

Symptom

What data is stored on the Database table PA_LEARNING_PLAN_REQ?

Environment

SAP SuccessFactors Learning

Reproducing the Issue

  1. Verify tables PA_STUD_QUAL_REQ and PH_STUD_QUAL_REQ >
  2. There are curricula requirements associated to users >
  3. Verify data available on the PA_LEARNING_PLAN_REQ >
  4. 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

Product

SAP SuccessFactors Learning all versions