Creating User With WWV_FLOW_FND_USER_API in Apex 4.1.0 Fails With ORA-20987
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.
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:
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
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