SAP Knowledge Base Article - Public

2372741 - Item data not correctly populating in PA_AP_Attr_Val table

Symptom

The data value for Assignment profile attribute "Item/SubstituteCompletion" seems to be showing incorrectly.

For example : When one is creating an Assignment Profile and select an attribute as "Item/Substitute Completion" does not match "<ITEM ID>"

In the database its storing the Attribute value correctly in the table "PA_AP_Assoc_Attr"

However the 'value' column is showing incorrect (as a number) instead of the Item ID in the table PA_AP_Attr_Val.

Environment

SuccessFactors Learning Management System (LMS) - All Supported Versions

Reproducing the Issue

1. Create an Assignment profile

2. Go to Manage Rules and select Add rule

3. Select the attribute Item/Substitute Completion 'does not equal'

4. Select 1 or 2 Item ID's

5. Check at Database at table PA_AP_Attr_Val the data stored is some numeric value rather than the CPNT_ID

Cause

This is expected system behaviour.

Resolution

The number you see in the Value column of PA_AP_Attr_Val is actually the CPNT_KEY.

The CPNT_KEY is linked to every item and often referenced in the database instead of CPNT_ID. You can find it referenced in the table PA_CPNT.

Keywords

Assignment; Profile; PA_AP_Attr_Val; PA_CPNT; Rule; Completion; Item; CPNT_ID; , KBA , LOD-SF-LMS , SuccessFactors Learning , Problem

Product

SAP SuccessFactors Learning 1608