APEX

I am working on scripts to create/delete/change ApEx users (actually developers) and need some guidance.

I can use the create_fnd_user to create developers, however, I am having trouble removing them. The remove procedure says it worked (procedure successfully completed) but a query of the wwv_flow_developers shows the user. Trying to log on as the user fails. How can I completely remove the developer/user?

To see what is in the flow files I have tried to use both the wwv_flow_fnd_user_api.fetch_fnd_user and also the htmldb_util.fetch_user. Both sort of work. Using the names from the select list of wwv_flow_developers, some bring back information and some only bring back the workspace. (It seems that by using wwv_flow_api.set_security_group_id(p_security_group_id=> to set the security group id, it has more success but still has misses - also I found if I make up a name it only brings back the workspace - so it seems the procedures are not finding some names that show up in the developers table.)

Another interesting thing. I query the wwv_flow_fnd_user table and only see a partial list of users - changing the security group id doesn't make a difference. Using this list for the fetches, most bring back information but some don't.

Any guidance?

Thanks,
Steve