3.2 Managing Packaged Applications

This section describes how to view, install, run, and remove packaged applications.

Topics:

3.2.1 Accessing the Packaged Applications Page

To access the Packaged Applications page:

  1. Log in to Oracle Application Express.

    The Workspace home page appears.

  2. Click the Application Builder icon.

    The Application Builder home page appears.

  3. Select the Packaged Applications tab.

    Description of packapp_tab.gif follows
    Description of the illustration packapp_tab.gif

    The Packaged Applications page appears.

    Description of packapp_pg.gif follows
    Description of the illustration packapp_pg.gif

    Note that the application category (for example, Software Development or Sample Websheet) displays beneath the application title. You can identify installed applications by the green Installed tag that displays beneath the product category.

    Description of packapp_installed.gif follows
    Description of the illustration packapp_installed.gif

  4. Use the following lists at the top of the page to filter the display:

    • Category - Sort by application category. Options include: Community, IT Management, Knowledge Management, Marketing, Project Management, Sample, Software Development, Team Productivity, Tracking, and so on.

    • Type - Sort by application type. Options include: All Applications, Only Installed, Not Installed, Database Applications, or Websheets

  5. To view information about a packaged application, or install or remove a previously installed packaged application, click the application image.

3.2.2 Installing a Packaged Application

To install a packaged application:

  1. Go to the Packaged Applications page. See "Accessing the Packaged Applications Page".

    The Packaged Applications page appears.

  2. Locate the application to be installed.

    Tip:

    Use the Category and Type lists to filter the display.
  3. Click the application image.

    A summary page appears.

  4. Click Install Application.

  5. Select an Authentication scheme and click Next.

  6. Click Install Application again.

    A success message appears.

  7. To run the application, click the Run Application icon.

  8. Enter the appropriate login credentials:

    1. Username - Enter your workspace username.

    2. Password - Enter your workspace password.

    3. Click Login.

3.2.3 Running an Installed Packaged Application

To run an installed packaged application:

  1. Go to the Packaged Applications page. See "Accessing the Packaged Applications Page".

    The Packaged Applications page appears.

  2. Locate the application.

    Tip:

    Use the Category and Type lists to filter the display.
  3. Click the application image.

  4. Click Run.

  5. Enter the appropriate login credentials:

    1. Username - Enter your workspace username.

    2. Password - Enter your workspace password.

    3. Click Login.

3.2.4 Removing an Installed Packaged Application

To run an installed packaged application:

  1. Go to the Packaged Applications page. See "Accessing the Packaged Applications Page".

    The Packaged Applications page appears.

  2. Locate the application to be removed.

    Tip:

    Use the Category and Type lists to filter the display.
  3. Click the application image.

  4. Click Remove.

  5. When prompted, click Remove Application.

3.2.5 Unlocking an Installed Productivity Application

The main difference between a sample and productivity packaged application is the level of support. Once a productivity application is installed you must unlock it before you can edit it. By default, sample applications are fully editable.

Note:

Unlocking a productivity application makes it ineligible for future upgrades or support by Oracle Support.

To unlock an installed productivity packaged application:

  1. Go to the Packaged Applications page. See "Accessing the Packaged Applications Page".

    The Packaged Applications page appears.

  2. Locate the application to be unlocked.

    Tip:

    Use the Category and Type lists to filter the display.
  3. Click the application image.

  4. Click Manage.

  5. Click Unlock Application and click Next.

  6. When prompted, click Unlock Application.

3.2.6 Exporting an Installed Packaged Application

If you wish to export a locked productivity application into a different instance then you need to generate scripts from the Packaged Applications tab. For example, in a runtime-only environment you would need to create scripts to install the productivity application.

To export an installed packaged application:

  1. Go to the Packaged Applications page. See "Accessing the Packaged Applications Page".

    The Packaged Applications page appears.

  2. Locate and select the application to be exported.

    Tip:

    Use the Category and Type lists to filter the display.
  3. Click Manage.

  4. Select Export Application and click Next.

  5. On the Export Packaged Application page, click the download links:

    • Export Application Download

    • Export Supporting Objects Download

    Each link downloads a SQL script.

  6. Run the downloaded scripts to import the application and supporting objects in a new workspace.

    Tip:

    You can run the downloaded scripts from SQL*Plus, SQL Developer, or using Oracle Application Express SQL Scripts. To learn more, see "Using SQL Scripts" in Oracle Application Express SQL Workshop Guide.

3.2.7 Changing Authentication for an Installed Packaged Application

To change the authentication for an installed packaged application:

  1. Go to the Packaged Applications page. See "Accessing the Packaged Applications Page".

    The Packaged Applications page appears.

  2. Locate and select the installed application.

  3. Click Manage.

  4. Select Change Authentication and click Next.

    The Authentication Scheme page appears.

  5. Under Name:

    1. Name - Enter the name used to reference the authentication scheme by other application developers.

    2. Scheme Type - Select a new authentication scheme.

  6. Fill in the appropriate fields.

  7. To learn more about a specific field, see item Help.

    When help is available, the cursor changes to a question mark. See "About Field-Level Help".

3.2.8 Updating a Packaged Application

You can update a packaged application if it has the message Update Available message adjacent to its name.

To update a packaged application:

  1. Go to the Packaged Applications page. See "Accessing the Packaged Applications Page".

    The Packaged Applications page appears.

  2. Locate and click the application to be updated.

  3. Click Update.

    The Update Application Wizard appears.

  4. Click Update Application.

    Once updated, the Packaged Application Updated page appears.