Unable To Set End_date_active On Resource Using Jtf_rs_role_relate_pub.Update_resource_role_relate

(Doc ID 1092775.1)

Last updated on OCTOBER 06, 2017

Applies to:

Oracle Common Applications - Version 11.5.10.0 and later
Information in this document applies to any platform.
***Checked for relevance on 17-Sept-2016***

Goal

When trying to set the end_date_active on a role for a resource in the jtf_rs_role_relations-table using the JTF_RS_ROLE_RELATE_PUB-api, it doesn't work.


The problem is in the JTF_RS_ROLE_RELATE_PVT.validate_indv_role_date on row 113 (eBS 11.5.10).  If no end_date_active is set (NULL) there is no way that this can be between new_start_date_active and new_end_date_active.  Due to this, the code erros with an exception and the API-fails.

Is this a bug or is the API being used in the wrong way?


Solution

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms