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'

SAP SuccessFactors Learning

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

• • {
    "studentID":"123456",
    "jobPositionID":"1111111",
    "employeeStatusID":"ACTIVE",
    "firstName":"John",
    "lastName":"Smith",
    "jobTitle":"Manager",
    "organizationID":"13456789",
    "employeeTypeID":"MGR01",
    "timeZone":"America/NewYork",
    "locale":"English",
    "currencyID":"USD",
    "domainID":"PUBLIC",
    "roleID":"LEARNING_USER",
    "notActive":"N",
    "customColumn":[{
      "value":"132456789",
      "id":"11223344",
      "columnNumber":520
      },{
      "value":"987654321",
      "id":"12346579",
      "columnNumber":530
      },{
      "value":"1008",
      "id":"BR2542547",
      "columnNumber":160
      }]
    }

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.

adding a new user via the webservice, API, Webservice, ORA-20001: PT_BIU_STUD_USER: invalid USER_ID - parent key not found , KBA , LOD-SF-LMS-ODA , Web Services OData , Problem