Managing Custom Applications, Packaged Applications, and Public Themes

Manage custom applications uploaded to the Packaged Applications repository, monitor packaged application installations, and manage public themes.

  • Managing Custom Applications
    Instance administrators manage custom applications uploaded to the Packaged Applications repository.
  • Managing Public Themes
    Public themes are available to developers when they create an application or create a theme for an existing application.

See Also:

"About Specifying How Workspaces Are Created"

Parent topic: Oracle Application Express Administration Services

Managing Custom Applications

Instance administrators manage custom applications uploaded to the Packaged Applications repository.

By adding a custom application to the Packaged Applications repository, developers can view, install, run, upgrade and deinstall it in the Apps Gallery in App Builder.

Parent topic: Managing Custom Applications, Packaged Applications, and Public Themes

About Making Custom Applications Available to Users

Once a custom application has been added to the Packaged Applications repository, developers can view, install, run, upgrade and deinstall it in Apps Gallery.

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.

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 App Builder User’s Guide

Parent topic: Managing Custom Applications

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

Parent topic: Managing Custom Applications

Uploading a Custom Application to the Packaged Applications Repository

Upload custom applications to the Packaged Application repository.

To upload a custom application:

  1. Sign in to 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.

Parent topic: Managing Custom Applications

Editing Custom Application Details

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 upload, edit, and delete custom applications.

To edit the application details:

  1. Sign in to 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. 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.

Parent topic: Managing Custom Applications

Deleting a Custom Application

Delete custom applications from the Packaged Application repository.

To delete a custom application:

  1. Sign in to 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.

Parent topic: Managing Custom Applications

Managing Public Themes

Public themes are available to developers when they create an application or create a theme for an existing application.

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.

See Also:

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

Parent topic: Managing Custom Applications, Packaged Applications, and Public Themes

Adding a Public Theme to the Theme Repository

To create a public theme, an instance administrator adds it to the Public Themes repository.

To add a theme to the Theme repository:

  1. Sign in to 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:
    • Theme Number - Enter a number that uniquely identifies a theme within a workspace.
    • Theme Name - Enter a name for the workspace theme.
    • Description - Enter a description.
    • Click Next.
  9. Click Create Public Theme.

Parent topic: Managing Public Themes

Deleting a Public Theme

Only an Instance administrators can delete a theme from the Public Themes repository.

To delete a public theme:

  1. Sign in to 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.

Parent topic: Managing Public Themes

Modifying a Public Theme

Instance administrators 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 App Builder User’s Guide.

  2. Modify the theme. See "Editing a Theme" in Oracle Application Express App 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."

Parent topic: Managing Public Themes

About Exporting a Public Theme

Exporting a theme is similar to exporting any related application files.

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 App Builder User’s Guide.

  2. Export the application. See "Exporting an Application" in Oracle Application Express App 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 App Builder User’s Guide.

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

Parent topic: Managing Public Themes