SAP Knowledge Base Article - Public

2534529 - Reference Custom Columns in the LMS error when attempting to remove the value and save


  • When an Admin attempts to remove the value of a Custom Column that is set as a reference and drop down pick lists are disabled, an error is thrown when the record is saved:
Failure: [FaultEvent fault=[RPC Fault faultString="com.plateausystems.elms.framework.snapshot.api.SnapshotException : com.plateausystems.elms.util.helper.ElmsCreateException: java.sql.SQLException: ORA-20001: PKG_TRIGGER.PT_BIU_CPNT_USER: invalid USER_ID - parent key not found (PA_USRRF_CPNT)
ORA-06512: at line 1
  • The error only occurs if dropDownEnabled is set to false under System Admin > Configuration > Search Selectors


  • SAP SuccessFactors Learning Management System (LMS)
  • Release b1708

Reproducing the Issue

  1. Logon to LMS Admin
  2. Navigate to a Record that has a reference field that is a custom column setup for it
  3. Ex: Learning > Item > Item_1234
  4. Click "View All" to expand the Extended Summary of the record
  5. Scroll down to the referenced custom column and clear the value
  6. Click Save
  7. Note the error pop-up:


This has been identified as a defect under LRN-23476


This issue has been corrected in release 1711


  1. Logon to LMS Admin
  2. Navigate to System Admin > Configuration > Search Selectors
  3. Find "Custom Column Component Reference" and click the Edit icon
    • Note: "Component" is specifc to Item Records, if the reference field you are having an issue with is on another record type, edit that search selector
  4. Find the "dropDownEnabled" entry
  5. Set this from false to true
  6. Save changes

See Also

User Assistance Guide for Search Selectors


SF SuccessFactors Learning LMS custom column reference delete del remove clear take out value error failure exception unable cannot save picker pick list select box , KBA , LOD-SF-LMS-ITE , LMS Items , LOD-SF-LMS , SuccessFactors Learning , LOD-SF-LMS-COR , LMS Core - Items, Catalog, Curricula , Bug Filed


SAP SuccessFactors Learning 1708