SQL & PL/SQL

Hello Friends,

I would like to get your help on how to end date (from the back end database) a Group member roles for a CRM resource ( in JTF Application )

I have tried to use jtf_rs_grp_membership_pub.update_group_membership and JTF_RS_ROLE_RELATE_PUB.update_resource_role_relate APIs.

Both of them give me this error:

" The resource role start/end date falls out of the date range, for one or more of its group/team member roles"

SELECT role_id,

     role\_relate\_id,

     start\_date\_active,

     end\_date\_active,

     object\_version\_number

FROM jtf\_rs\_role\_relations

WHERE role_resource_id = l_resource_id

     AND role\_resource\_type = 'RS\_INDIVIDUAL'

     AND NVL (delete\_flag, 'N') \<> 'Y'

ORDER BY start_date_active DESC;

Thank you