SAP Knowledge Base Article - Public

2216839 - Parent key not found error when running Deny Expired Approval Processes APM


When running Deny Expired Approval Processes APM the following error is generated:

com.plateausystems.elms.util.helper.ElmsUncheckedException: Error occurred in Deny Expired Business Process APM Job
Caused by: com.plateausystems.elms.util.process.ElmsProcessException: com.plateausystems.elms.util.helper.ElmsCreateException: SQLException - Could not create record!
Caused by: java.sql.SQLIntegrityConstraintViolationException: ORA-02291: integrity constraint (BCBSNC_STAGE_TMS.FK_TAP_ACTION__TAP_ACTION_STAT) violated - parent key not found


SAP SuccessFactors Learning


The error is generated as there is an issue in the database.


Please create a new case with the SAP Support team ("LOD-SF-LMS-APM" component), so the Operations can make a correction that will allow this APM to function normally.


Learning, Deny Expired Business Process APM Job, ElmsCreateException, ORA-02291, integrity constraint, BCBSNC_STAGE_TMS.FK_TAP_ACTION__TAP_ACTION_STAT , KBA , LOD-SF-LMS , Learning Management System , LOD-SF-LMS-ADM , System Admin, Global Variables, References , LOD-SF-LMS-APM , Automatic Processes , Problem


SAP SuccessFactors Learning all versions