- Login to the INTERNAL workspace as the ADMIN user, or another existing admin user. - Click the "Create User" link on the right-hand menu. - For a new admin user enter mandatory items and the following. Workspace : INTERNAL Default Schema : APEX_180200 {or whatever the highest version is} User is an administrator: Yes Account Availability : Unlocked Password and Confirmation Password. Require Change of Password on First Use : Yes - Workspace : INTERNAL - Default Schema : APEX_180200 {or whatever the highest version is} - User is an administrator: Yes - Account Availability : Unlocked - Password and Confirmation Password. - Require Change of Password on First Use : Yes - Click the "Create User" button.

You can create a new user from the INTERNAL workspace, or from a specific workspace. The user creation is similar, but the entry into it is a little different. - INTERNAL : Click the "Create User" link on the right-hand menu. - WORKSPACE : Admin Icon (top toolbar) > Manage Users and Groups > Create User - Workspace : {enter workspace if available} - Default Schema : {select schema} - User is an administrator: {depending on WS admin or not} - User is an developer: Yes - Account Availability : Unlocked - Password and Confirmation Password. - Require Change of Password on First Use : Yes - Login to the INTERNAL workspace as the ADMIN user, or another existing admin user. - Click the "Create Workspace" link on the right-hand menu. You can also get this from the "Manage Workspace" section. - Enter a workspace names and click the "Next" button. This is the workspace name a developer will login with. - If you have already created a schema, do the following. Re-use existing schema? : Yes Schema Name : {select the schema} Click the "Next" button. - Re-use existing schema? : Yes - Schema Name : {select the schema} - Click the "Next" button. - If you need to create a new schema, do the following. Re-use existing schema? : No Schema Name : {entered new schema name} Schema Password : {entered pass} Space Quota (MB) : {select required quota} Click the "Next" button. - Re-use existing schema? : No - Schema Name : {entered new schema name} - Schema Password : {entered pass} - Space Quota (MB) : {select required quota} - Click the "Next" button. - Enter the admin user details, you can add more later, and click the "Next" button. - Click the "Create Workspace" button. - Click the "Done" button. - Create additional admin and developer users for the workspace. - Login to the INTERNAL workspace. - Click on the "Manage Workspaces" link. - Click on the "Manage Workspace to Schema Assignments" link. - Click the "Add Schema" button. - Accept the "Existing" option by clicking the "Next" button. - Select the workspace you wish to assign a schema to, and click the "Next" button. - Select the schema you want to assign to the workspace, and click the "Next" button. - Click the "Add Schema" button. - Login to the INTERNAL workspace as the ADMIN user, or another existing admin user. - Manage Workspaces > Export Workspace - Select the workspace and click the "Export Workspace" application. - Select the options you want and click the "Save File" button, then pick a location and save the file. - Click the "Cancel" button on the "Export Workspace" dialog. - Login to the INTERNAL workspace as the ADMIN user, or another existing admin user. - Manage Workspaces > Import Workspace - Click the "Choose file" button and select the file holding the workspace you want to import, then click the "Next" button. - Enter the password for the workspace schema and click the "Next" button. - Check the confirmation checkbox and click the "Next" button. - Click the "Install Workspace" button. - You are presented with the "Imported Workspace Export Files" screen. The operation is complete. - Go into the application builder and click on the application of interest. - Click the "Export/Import" link. - Click the "Export" link. - Select the export options, the defaults are usually fine, and click the "Export" button. - Save the file in the normal way. If you are transferring a new version of an application to an environment, you will need to delete the old version of the application first. - Go into the application builder and click on the application of interest. - Click the "Delete this Application" link on the right-hand menu. - Click the "Permanently Delete Now" button. You can now continue with the import. - Go into the application builder and click "import" button. - Click the "Choose file" button and select the file holding the application you want to import, then click the "Next" button. There several options you can pick from, but the default "Database Application, Page or Component Export" is the one you want. - Click the "Next" button. - Select the "Reuse Application ID ??? From Export File" option and click the "Install Application" button. - The application is now imported. - Go into the application builder and click on the application of interest. - Utilities > Upgrade Application - If any of the components in the application need to be upgraded, they will be listed. - Click on each link in turn (the number on the right-side) and perform the upgrade. - The upgrade is complete once the last group of components is upgrade and the list is empty. Compatibility Mode: - Application > Shared Components > Application Definition Attributes - Select the "Compatibility Mode" required. Typically the latest. - Click the "Apply Changes" button. Javascript: - Application > Shared Components > User Interface Attributes - Click the "Pen" icon next to the "Desktop" row. - In the JavaScript section decide what Javascript support you wuld like. To use the latest, uncheck the checkboxes and select "No" for the "Include jQuery Migrate" option. - Click the "Apply Changes" button. Components: - Application > Shared Components > Component Settings - Check the components listed have the desired settings. Typically "Switch" will need editing. Enter values for "Yes" and "No", and select "Switch" for the "Display Style". - Click the "Apply Changes" button. Theme: - Application > Shared Components > Themes Drill into theme. Click the "Refresh Theme" button. Click the "Icons" tab and check the "Library" is set to "Font APEX". Click the "Styles" tab and select the style of interest. Make sure it is marked as "Is Current". If you made any changes, click the "Apply Changes" button. - Drill into theme. - Click the "Refresh Theme" button. - Click the "Icons" tab and check the "Library" is set to "Font APEX". - Click the "Styles" tab and select the style of interest. - Make sure it is marked as "Is Current". - If you made any changes, click the "Apply Changes" button. - Go into the application builder and click on the application of interest. - Shared Components > Themes > Universal Theme - 42 - Click on the "Refresh Theme" button. - Click on the "Apply Changes" button. - Refresh theme, as described above. - Remember to re-select your Template Style if you are not using the default. - Go to "Shared Components > User Interface Attributes". - Click on the "Pen" icon next to the "Desktop" item. - Under "Navigation Menu" section select the following: Template Options: Use Template Defaults Style: Style A - Template Options: Use Template Defaults - Style: Style A - Click "Apply Changes", and "Apply Changes" again. - If you have any problems, it's worth switching between theme styles in the Theme Roller. Some database operations, such as database upgrades, can leave APEX in an invalid state. Running the following command will validate the APEX installation and redo any missing grants. If you've installed APEX in a PDB, remember to switch to the relevant PDB before running the command. Check out the note here . For more information see: - APEX Articles - Workspace and Application Administration - Managing Users in a Workspace Hope this helps. Regards Tim...

1
2
3
4
5

CONN / AS SYSDBA
--ALTER SESSION SET CONTAINER=pdb1;

SET SERVEROUTPUT ON
EXEC SYS.validate_apex;

- Login to the INTERNAL workspace as the ADMIN user, or another existing admin user. - Click the "Create Workspace" link on the right-hand menu. You can also get this from the "Manage Workspace" section. - Enter a workspace names and click the "Next" button. This is the workspace name a developer will login with. - If you have already created a schema, do the following. Re-use existing schema? : Yes Schema Name : {select the schema} Click the "Next" button. - Re-use existing schema? : Yes - Schema Name : {select the schema} - Click the "Next" button. - If you need to create a new schema, do the following. Re-use existing schema? : No Schema Name : {entered new schema name} Schema Password : {entered pass} Space Quota (MB) : {select required quota} Click the "Next" button. - Re-use existing schema? : No - Schema Name : {entered new schema name} - Schema Password : {entered pass} - Space Quota (MB) : {select required quota} - Click the "Next" button. - Enter the admin user details, you can add more later, and click the "Next" button. - Click the "Create Workspace" button. - Click the "Done" button. - Create additional admin and developer users for the workspace.

- Login to the INTERNAL workspace. - Click on the "Manage Workspaces" link. - Click on the "Manage Workspace to Schema Assignments" link. - Click the "Add Schema" button. - Accept the "Existing" option by clicking the "Next" button. - Select the workspace you wish to assign a schema to, and click the "Next" button. - Select the schema you want to assign to the workspace, and click the "Next" button. - Click the "Add Schema" button.

- Login to the INTERNAL workspace as the ADMIN user, or another existing admin user. - Manage Workspaces > Export Workspace - Select the workspace and click the "Export Workspace" application. - Select the options you want and click the "Save File" button, then pick a location and save the file. - Click the "Cancel" button on the "Export Workspace" dialog.

- Login to the INTERNAL workspace as the ADMIN user, or another existing admin user. - Manage Workspaces > Import Workspace - Click the "Choose file" button and select the file holding the workspace you want to import, then click the "Next" button. - Enter the password for the workspace schema and click the "Next" button. - Check the confirmation checkbox and click the "Next" button. - Click the "Install Workspace" button. - You are presented with the "Imported Workspace Export Files" screen. The operation is complete.

- Go into the application builder and click on the application of interest. - Click the "Export/Import" link. - Click the "Export" link. - Select the export options, the defaults are usually fine, and click the "Export" button. - Save the file in the normal way.

If you are transferring a new version of an application to an environment, you will need to delete the old version of the application first. - Go into the application builder and click on the application of interest. - Click the "Delete this Application" link on the right-hand menu. - Click the "Permanently Delete Now" button. You can now continue with the import. - Go into the application builder and click "import" button. - Click the "Choose file" button and select the file holding the application you want to import, then click the "Next" button. There several options you can pick from, but the default "Database Application, Page or Component Export" is the one you want. - Click the "Next" button. - Select the "Reuse Application ID ??? From Export File" option and click the "Install Application" button. - The application is now imported.

- Go into the application builder and click on the application of interest. - Utilities > Upgrade Application - If any of the components in the application need to be upgraded, they will be listed. - Click on each link in turn (the number on the right-side) and perform the upgrade. - The upgrade is complete once the last group of components is upgrade and the list is empty.

Compatibility Mode: - Application > Shared Components > Application Definition Attributes - Select the "Compatibility Mode" required. Typically the latest. - Click the "Apply Changes" button. Javascript: - Application > Shared Components > User Interface Attributes - Click the "Pen" icon next to the "Desktop" row. - In the JavaScript section decide what Javascript support you wuld like. To use the latest, uncheck the checkboxes and select "No" for the "Include jQuery Migrate" option. - Click the "Apply Changes" button. Components: - Application > Shared Components > Component Settings - Check the components listed have the desired settings. Typically "Switch" will need editing. Enter values for "Yes" and "No", and select "Switch" for the "Display Style". - Click the "Apply Changes" button. Theme: - Application > Shared Components > Themes Drill into theme. Click the "Refresh Theme" button. Click the "Icons" tab and check the "Library" is set to "Font APEX". Click the "Styles" tab and select the style of interest. Make sure it is marked as "Is Current". If you made any changes, click the "Apply Changes" button. - Drill into theme. - Click the "Refresh Theme" button. - Click the "Icons" tab and check the "Library" is set to "Font APEX". - Click the "Styles" tab and select the style of interest. - Make sure it is marked as "Is Current". - If you made any changes, click the "Apply Changes" button.

- Go into the application builder and click on the application of interest. - Shared Components > Themes > Universal Theme - 42 - Click on the "Refresh Theme" button. - Click on the "Apply Changes" button.

- Refresh theme, as described above. - Remember to re-select your Template Style if you are not using the default. - Go to "Shared Components > User Interface Attributes". - Click on the "Pen" icon next to the "Desktop" item. - Under "Navigation Menu" section select the following: Template Options: Use Template Defaults Style: Style A - Template Options: Use Template Defaults - Style: Style A - Click "Apply Changes", and "Apply Changes" again. - If you have any problems, it's worth switching between theme styles in the Theme Roller.

Some database operations, such as database upgrades, can leave APEX in an invalid state. Running the following command will validate the APEX installation and redo any missing grants. If you've installed APEX in a PDB, remember to switch to the relevant PDB before running the command.

1
2
3
4
5

CONN / AS SYSDBA
--ALTER SESSION SET CONTAINER=pdb1;

SET SERVEROUTPUT ON
EXEC SYS.validate_apex;

Check out the note here . For more information see: - APEX Articles - Workspace and Application Administration - Managing Users in a Workspace Hope this helps. Regards Tim...