CRM On Demand - Administration (MOSC)

MOSC Banner

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;

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

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

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center