2440014 - E-signature error "ORA-02291: integrity constraint (XXX_PROD_TMS.FK_CPNT_CD__EVTHST_STUD) violated - parent key not found"

SAP Knowledge Base Articles - public

2440014 - E-signature error "ORA-02291: integrity constraint (XXX_PROD_TMS.FK_CPNT_CD__EVTHST_STUD) violated - parent key not found"


  • when tries to complete the E-signature, the following error encountered:
    Please report the following error to your system administrator:<Ticket number>"

  • The following error can be seen in Splunk:
    "Caused by: java.sql.SQLIntegrityConstraintViolationException: ORA-02291: integrity constraint (PMI_PROD_TMS.FK_CPNT_CD__EVTHST_STUD) violated - parent key not found
    ORA-06512: at "PMI_PROD_TMS.PKG_LEARNINGHST", line 6640
    ORA-06512: at "PMI_PROD_TMS.PKG_LEARNINGHST", line 5659
    ORA-06512: at "PMI_PROD_TMS.PKG_LEARNINGHST", line 2732
    ORA-06512: at "PMI_PROD_TMS.PKG_LEARNINGHST", line 251
    ORA-06512: at line 1"


Learning Management System (LMS)

Reproducing the Issue

  1. Start the Course from User Learning plan.
  2. After the course is completed, you wlill be requested to verify the course with E-Signature PIN.
  3. The error can be seen here.


One of the major reason when this issue occurs is when you have multiple versions of the same item and both are in the Learning plan of the user.


Take a look at those users to check if user have multiple version of items (active and inactive) and if both are in the user's Learning Plan or not. Users wouldn't be able to see the inactive item but an "admin" can look into their Assigned item, and will see both versions. Remove the inactive version from the User's Learning plan, using the following steps:

  1. Go to Users --> Tools --> User Needs Mgmt.
  2. Select Remove Items and click Next.
    2440014 _1.jpg
  3. To identify the users having multiple Items assigned, we going to search with Inactive Item as Active users already getting the error. In this way, we will know the affected users getting the error. 
         a. Click on "add one or more from list".
            b. Search with ID by clicking on Funnel button as shown below:

              c. Enter Item ID and select Item Status as Not Active. Click search, select the ITEM ID, click Add to Filter and submit filter.

  4. Now, select the affected users and Click Add button.
  5. Click Next button now.
  6. Here, either you can Run Job Now or select Schedule Job option as per your requirement:

See Also

2386966 - Setup electronic signature within LMS


Learning Management System, user needs management, remove items , KBA , LOD-SF-LMS-INT , LMS Integrations , LOD-SF-LMS , SuccessFactors Learning , LOD-SF-LMS-DB , DB Data & Services , Problem


SAP SuccessFactors HCM Core 1611 ; SAP SuccessFactors Learning all versions