My Oracle Support Banner

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 DECEMBER 19, 2022

Applies to:

Oracle Common Applications - Version 11.5.10.0 and later
Information in this document applies to any platform.

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 errors with an exception and the API-fails.

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


Solution

To view full details, sign in with your My Oracle Support account.

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


In this Document
Goal
Solution
References


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