Fnd_user_resp_groups_api.Insert_assignment Always Returns Error

(Doc ID 835178.1)

Last updated on JUNE 21, 2018

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***


-- 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

-- 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:


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