Oracle Application Express (MOSC)

MOSC Banner

wwv_flow_fnd_user_api.edit_fnd_user requires ADMIN privilege to perform this operation

edited May 4, 2016 2:33PM in Oracle Application Express (MOSC) 2 commentsAnswered

We have a button on a page available to workspace administrators.  There is a page process linked to the button.  The page process deletes records  from some custom tables related to the user to be "deleted".  The following API is used to edit the user's account, but after clicking the button as a workspace administrator we get an error indicating that the user requires ADMIN privilege to perform this operation.

wwv_flow_fnd_user_api.edit_fnd_user(p_user_id =>:P48_USER_ID,
                                    p_user_name => v_user_name,
     p_end_date                     =>SYSDATE,
     p_description                  =>v_description,
     p_account_locked               =>'Y');

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