Fnd_user_resp_groups_api.Insert_assignment Always Returns Error (Doc ID 835178.1)

Last updated on OCTOBER 05, 2016

Applies to:

Oracle Application Object Library - Version 12.0 to 12.2 [Release 12 to 12.2]
Information in this document applies to any platform.
***Checked for relevance on 03-May-2013***

Symptoms

-- Problem Statement:
Using the API to create an user responsibilities: fnd_user_resp_groups_api.insert_assignment returns the following error:

"ORA-20001: Oracle error 100: ORA-01403: no data found has been detected in
FND_USER_RESP_GROUPS_API.INSERT_ASSIGNMENT."

-- Steps To Reproduce:
Where user_id is from fnd_user table, and responsibility_id and application_id are from the fnd_responsibility_tl table. Run the following script:

Cause

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