Cdr_pub_security_pkg.removegrproles API Always Returns 'S'
Last updated on MARCH 02, 2015
Applies to:Oracle Life Sciences Data Hub - Version 2.3 and later
Information in this document applies to any platform.
On Oracle Life Sciences Data Hub (LSH) 2.3.0:
The cdr_pub_security_pkg.removegrproles API never fails and it always returns 'S' as return status.
Expected output: This output parameter returns the end status of the API: (S) Success, (E) Error or (U) Unexpected Error.
This API is used to remove a single Role from a User Group.
Steps to be executed in order to reproduce the issue:
1 . Make sure that role_id = 2222 is not associated with user_group_id=2101 by executing the following query:
Expected results :
"E" error code should be returned as the role_id = 2222 is not associated to user_goup_id=2101 ( as verified in Preconditions section).
Running the code the following result is obtained:
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