SAP Knowledge Base Article - Public

2271099 - Error returned when adding user via webservice api


  • The following error is returned when adding a new user via the webservice
  • com.plateausystems.elms.util.helper.ElmsCreateException: com.plateausystems.elms.util.helper.ElmsCreateException: java.sql.SQLException: ORA-20001: PT_BIU_STUD_USER: invalid USER_ID - parent key not found (PA_USRRF_STUD)
    ORA-06512: at "{schemaName}.PT_BIU_STUD_USER", line 17
    ORA-04088: error during execution of trigger '{schemaName}.PT_BIU_STUD_USER'


  • SuccessFactors Learning Management System

Reproducing the Issue

  • Add a user to the LMS via the webservice api with similar properties as the below user.
    • {


  • When you add the user it will execute a 'trigger' in the DB to make sure the data for the user gets added to various tables in order for it to remain consistent. The trigger here is the PT_BIU_STUD_USER and it is responsible for checking the custom columns to determine if they are referenced values or not. The trigger queries the PA_USRCL_STUD table to find out if the user has any custom columns that contain reference values. It will then in turn query the PA_USRRF_STUD to find out if it contains those entries for that user. In this case it does not and that is why the error is returned.


  • Prior to adding the user to the LMS ensure that all custom columns being used for the user are part of the user record.


KBA , LOD-SF-LMS , Learning Management System , Problem


SAP SuccessFactors Learning 1511