Terminate Participant Using WebService participantServiceV2.terminateParticipant Error JBO-27024: Failed to validate a row with key oracle.jbo.Key (Doc ID 2219665.1)

Last updated on APRIL 18, 2023

Applies to:

Symptoms

User wants to end-date the participant using a webservice and encounter validate errors with the assignment dates.

Steps to reproduce:
1) Sample participant "xxxxxxxx"
    Active Start Date = 2014-01-01
    Active End Date = null
    Attribute Start Date = 2014-01-01
    Attribute End Date = null
    Assigned to two compensation plans :
          COMP_PLAN_ID      START_DATE              END_DATE
          300000002656452 2014-01-01 00:00:00 2014-12-31 00:00:00
          300000059040036 2014-01-01 00:00:00 2014-12-31 00:00:00
2) Payload using SoapUI:

3) Payload response with error :
<faultstring><![CDATA[JBO-27023: Failed to validate all rows in a transaction.JBO-27024: Failed to validate a row with key oracle.jbo.Key[11001] in ParticipantHdrUpdEOJBO-CN:::CN_SRPCP_ASSIGN_START_UPDT_E:<MESSAGE><NUMBER>CN-1575414</NUMBER><TEXT>You cannot save your changes because the participant has a plan assignment JN plan 1 that exists outside of the proposed participant start and end date range.</TEXT><CAUSE></CAUSE><ACTION></ACTION><DETAILS>Adjust the plan assignment date range to fall within the participant's start and end dates, or update the participant dates.</DETAILS><INCIDENT></INCIDENT></MESSAGE>JBO-CN:::CN_SRPST_PART_DETAIL_DT_E: <MESSAGE><NUMBER>CN-1575259</NUMBER><TEXT>The participant detail start and end dates must fall within the participant's active start date and active end date or compensation end date range.</TEXT><CAUSE></CAUSE><ACTION></ACTION><DETAILS>If the participant's end date is open, the attribute detail end date can be open.</DETAILS><INCIDENT></INCIDENT></MESSAGE>]]></faultstring>

Changes

Cause

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.