APEX

Hello everybody,

First of all: i'm very new to apex development and i don't have much experience ;)

I am using APEX 3.0 and have three different stages: development, integration and production. These 3 stages are all on different databases. At this point I am finished with the development of the application and want to 'deploy' my stuff to the integration environment. The special case is, that I don't want to 'deploy' my stuff with the APEX-GUIs. I want to generate scripts, who have the following purpose:

- creating an apex-workspace (with admin user)
- creating additional development users for this workspace
- installing my exported application from the development stage

It has to be possible, that these Scripts can be run as a database-user directly on the database. Nice to have would be, that the user doesn't have to be 'sys'.

At the moment I don't know which package-procedure I have to run, is it one of the following?
- wwv_flow_fnd_user_api.create_company
- wwv_flow_provisioning.auto_provision_company

This is my actual script which I want to run to create a workspace with an admin user:

alter session set current_schema=FLOWS_030000;

BEGIN
wwv_flow_security.g_security_group_id := 10;
wwv_flow_provisioning.auto_provision_company(
p_company_name => 'DEMO',
p_schema_name => 'DBUSER',
p_schema_password => 'pw',
p_admin_password => 'pw',
p_database_size => '5',
--
p_admin_userid => '1',
p_admin_first_name => 'demo',
p_admin_last_name => 'demo',
p_admin_title => null,
p_admin_email => 'demo@demo.net',
--
p_project_description => 'demo_description',
p_security_group_id => null);
END;

The schema_name is equal to the oracle-database-user.
In my opinion, this script should generate an apex-workspace, but the following error message occures:

ERROR at line 1:
ORA-20001: Request 3806118621995074 could not be processed. -20001 ORA-20001:
Unable to create user. ORA-01920: user name 'DBUSER' conflicts with another
user or role name
ORA-06512: at "FLOWS_030000.WWV_FLOW_PROVISIONING", line 433
ORA-06512: at line 3

I have no plan, why this error message occures, because there is no other workspace beside the internal-workspace. Of course the Oracle-Database-User "DBUSER" exists.

Can anyone help me to solve this problem?

Greetings, Mirco