jtf_rs_resource_pub.update_resource to update source name and receiving error. This record has been
RDBMS : 12.1.0.2.0
Oracle Applications : 12.2.5
I am looking to update the source name of one resource. I am using the API jtf_rs_resource_pub.update_resource.
the below code produces the following error. Error updating resource: E This record has been updated by another user. Please requery and try again. Is there something I am missing? I have already updated the name in the FND_USERS table.
DECLARE
l_resource_id jtf_rs_resource_extns.resource_id%type := 100003061; -- Replace with the actual resource ID
l_new_source_name VARCHAR2(100) := 'Banks-Test, Test Test'; -- Replace with the desired source name
l_object_version_number JTF_RS_RESOURCE_EXTNS.OBJECT_VERSION_NUMBER%TYPE;