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

• 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.

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