Creating User With WWV_FLOW_FND_USER_API in Apex 4.1.0 Fails With ORA-20987 (Doc ID 1493437.1)

Last updated on NOVEMBER 14, 2016

Applies to:

Oracle Application Express (formerly HTML DB) - Version 4.1.00.28 and later
Information in this document applies to any platform.

Symptoms

On : 4.1.00.28 version, Administration

Apex is upgraded to APEX 4.1. Procedure to create new users using "WWV_FLOW_FND_USER_API"  package worked in Apex 3.1, failed with the following error in Apex 4.1.0.

All necessary privs are given to the user.
The user has APEX_ADMINISTRATOR_ROLE execute on HTMLDB_UTIL,WWV_FLOW_ADMIN_API,WWV_FLOW_ERROR,WWV_FLOW_FND_USER_API,WWV_FLOW_SECURITY select, update,delete, insert on table WWV_FLOW_FND_USER.
Running a procedure to add user to the workspace fails with the error:

ERROR
-----------------------

ORA-20987: APEX - User requires ADMIN privilege to perform this operation. - Contact your application administrator.
ORA-06512: at "APEX_040100.WWV_FLOW_ERROR", line 704
ORA-06512: at "APEX_040100.WWV_FLOW_ERROR", line 1008
ORA-06512: at "APEX_040100.WWV_FLOW_FND_USER_API", line 76
ORA-06512: at "APEX_040100.WWV_FLOW_FND_USER_API", line 1198
ORA-06512: at "APEX_040100.HTMLDB_UTIL", line 1454
ORA-06512: at "DW_DATA.APEX_ADD_USERS", line 20
ORA-06512: at line 2

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