My Oracle Support Banner

Fnd_user_resp_groups_api.Insert_assignment Always Returns Error (Doc ID 835178.1)

Last updated on JANUARY 30, 2022

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.


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


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

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.