2.6 Managing Shared Components

Note:

Functionality in the Administration Services application is not available in Oracle Database Cloud Service (Database Schema).

This section describes how Instance administrators manage custom applications uploaded to the Packaged Applications repository, monitor packaged application installations, and manage public themes.

See Also:

"About Specifying How Workspaces Are Created"

2.6.1 Managing Custom Applications

This section describes how Instance administrators upload, edit, and delete custom applications.

2.6.1.1 About Making Custom Applications Available to Users

Developers can develop their own custom packaged applications. Like Oracle-supplied packaged applications, custom applications typically include both application pages and the supporting database objects. To create a custom applications, you first export it. Then, an instance administrator adds the application export to Packaged Applications repository. Once a custom application has been added to the Packaged Applications repository, developers can view, install, run, upgrade and deinstall it in Apps Gallery.

Tip:

Although the Packaged Application repository displays all applications installed in the current workspace, instance administrators can only edit custom applications.

See Also:

"Utilizing Packaged Applications" and "Exporting an Application" in Oracle Application Express Application Builder User's Guide

2.6.1.2 Accessing the Packaged Applications Repository

The Packaged Application repository displays all applications installed in the current workspace. However, instance administrators can only upload, edit, and delete custom applications.

To view the Packaged Application repository:

  1. Sign in to Oracle Application Express Administration Services. See "Accessing Oracle Application Express Administration Services."

  2. Click Manage Instance.

  3. Under Manage Shared Components, click Packaged Applications.

    The Packaged Database Applications page displays as an interactive report. You can customize the appearance of the page using the Search bar at the top of the page.

Tip:

Although the Packaged Application repository displays all applications installed in the current workspace, instance administrators can only edit custom applications.

2.6.1.3 Uploading a Custom Application to the Packaged Applications Repository

To upload a custom application:

  1. Sign in to Oracle Application Express Administration Services. See "Accessing Oracle Application Express Administration Services."

  2. Click Manage Instance.

  3. Under Manage Shared Components, click Packaged Applications.

  4. Click Create.

  5. For Specify File:

    1. Import file - Navigate to the file.

    2. File Type - Select the type of export file to be imported.

    3. File Character Set - Verify that File Character Set is correct.

    4. Click Next.

  6. For Application Details:

    1. Application ID - Specify a unique integer value that identifies the packaged application. The default is the value of Export File Application. Application IDs in the range of 3000 to 9000 are reserved for internal use by Oracle Application Express.

    2. Category - Select the primary category to associate with the application.

      To learn more about this attribute, see field-level Help.

    3. Description - Enter a brief description of the application.

    4. Click Next.

  7. Click Create.

    To learn more about an attribute, see field-level Help.

2.6.1.4 Editing Custom Application Details

Instance administrators can track a variety of information about a custom application including the application description, status, associated categories, application statistics, and version.

Tip:

Although the Packaged Application repository displays all applications installed in the current workspace, instance administrators can only edit and delete custom applications.

To edit the application details:

  1. Sign in to Oracle Application Express Administration Services. See "Accessing Oracle Application Express Administration Services."

  2. Click Manage Instance.

  3. Under Manage Shared Components, click Packaged Applications.

  4. To edit application details, click the Edit icon adjacent to the application name.

    The Application Detail page appears.

  5. Edit the appropriate attributes.

    Tip:

    Use the Status attribute to control if an application displays on the Packaged Application page. To learn more, see field-level Help.

2.6.1.5 Deleting a Custom Application

To delete a custom application:

  1. Sign in to Oracle Application Express Administration Services. See "Accessing Oracle Application Express Administration Services."

  2. Click Manage Instance.

  3. Under Manage Shared Components, click Packaged Applications.

  4. Locate the application and click the Edit icon adjacent to the application name.

    The Application Detail page appears.

  5. Click Delete and follow the on-screen instructions.

2.6.2 Monitoring the Progress Packaged Application Installations

Instance administrators have the ability to view the progress of a packaged application installation.

To monitor packaged application installation progress:

  1. Sign in to Oracle Application Express Administration Services. See "Accessing Oracle Application Express Administration Services."

  2. Click Manage Instance.

  3. Under Manage Shared Components, click Monitor Packaged Application Installations.

    The Packaged Applications Installations page appears. You can customize the page using the Search bar at the top of the page.

    The report displays total elapsed time to install each packaged application. Click the number in the Events column to view the log in detail.

    Note:

    The Packaged Application log is kept for up to 60 days. Any log older than 60 days is deleted.

2.6.3 Managing Public Themes

Instance administrators manage the theme repository for an entire Oracle Application Express instance. Only an Instance administrators can add or delete a theme from the repository.

2.6.3.1 What Is a Public Theme?

When you create a public theme, you add it to the theme repository. Public themes are available when you create an application or when you create a theme for an existing application.

See Also:

"Managing Workspace Themes" in Oracle Application Express Application Builder User's Guide

2.6.3.2 Adding a Public Theme to the Theme Repository

To add a theme to the Theme repository:

  1. Sign in to Oracle Application Express Administration Services. See "Accessing Oracle Application Express Administration Services."

  2. Click Manage Instance.

  3. Under Manage Shared Components, click Public Themes.

    The Public Themes page appears.

  4. Select Create Public Theme.

  5. For Workspace, select a workspace and click Next.

  6. For Application, select an application and click Next.

  7. For Theme, select a theme and click Next.

  8. For Name, specify the following:

    1. Theme Number - Enter a number that uniquely identifies a theme within a workspace.

    2. Theme Name - Enter a name for the workspace theme.

    3. Description - Enter a description.

    4. Click Next.

  9. Click Create Public Theme.

2.6.3.3 Deleting a Public Theme

To delete a public theme:

  1. Sign in to Oracle Application Express Administration Services. See "Accessing Oracle Application Express Administration Services."

  2. Click Manage Instance.

  3. Under Manage Shared Components, click Public Themes.

    The Public Themes page appears.

  4. Select the theme to be deleted.

  5. Click Delete.

  6. Click OK to confirm your selection.

2.6.3.4 Modifying a Public Theme

You cannot edit a public theme directly. To modify a public theme, you must create a new application using the theme, modify it, and then manually add it to the theme repository.

To modify a public theme:

  1. Create an application using the theme you want to modify. See "Creating a Database Application" in Oracle Application Express Application Builder User's Guide.

  2. Modify the theme. See "Editing a Theme" in Oracle Application Express Application Builder User's Guide.

  3. Delete the existing public theme.

  4. Add the modified theme to the theme repository. See "Adding a Public Theme to the Theme Repository."

2.6.3.5 About Exporting a Public Theme

You export a theme in the same way you export any related application files. Exporting a public theme involves the following steps:

  1. Create an application using the theme you want to modify. See "Creating a Database Application" in Oracle Application Express Application Builder User's Guide.

  2. Export the application. See "Exporting an Application" in Oracle Application Express Application Builder User's Guide.

  3. Import the exported file into the target Oracle Application Express instance. See "Importing an Application, Page or Component Export" in Oracle Application Express Application Builder User's Guide.

  4. Install the exported file from the Export Repository. See "Installing Export Files" in Oracle Application Express Application Builder User's Guide.