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 18.104.22.168 and later
Information in this document applies to any platform.
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?
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