8i | 9i | 10g | 11g | 12c | 13c | 18c | 19c | 21c | 23c | Misc | PL/SQL | SQL | RAC | WebLogic | Linux

APEX Tips : Basic APEX Management

Some quick tips about basic APEX management.

Create a New Instance Administrator
Create a New User
Create a New Workspace
Manage Schema Assignments
Export a Workspace
Import a Workspace
Export an Application
Import an Application
Upgrade an Application
Post Upgrade Checks
Refresh Application Theme
Amend Navigation Menu Template Options
Validate APEX Installation
Validate ORDS Installation

Create a New Instance Administrator

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
Click the "Create User" button.

Create a New User

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

For a new workspace administrator or developer user enter mandatory items and the following, then click the "Create User" button.

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

Create a New Workspace

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.
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.
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.

Manage Schema Assignments

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.

Export a Workspace

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.

Import a Workspace

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.

Export an Application

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.

Import an Application

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.

Upgrade an Application

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.

Post Upgrade Checks

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.

Refresh Application Theme

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.

Amend Navigation Menu Template Options

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
Click "Apply Changes", and "Apply Changes" again.
If you have any problems, it's worth switching between theme styles in the Theme Roller.

Validate APEX Installation

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.

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

SET SERVEROUTPUT ON
EXEC SYS.validate_apex;

Validate ORDS Installation

Check out the note here.

For more information see:

Hope this helps. Regards Tim...

Back to the Top.