Oracle by Example brandingOracle Application Express 18: Utilizing Packaged Apps

section 0Before You Begin

This 10-minute tutorial demonstrates you how to access, install, and unlock a productivity application and also demonstrates how to install, run sample packaged application, and removing a packaged application.

Background

In this tutorial you install two types of packaged applications from the Packaged Apps gallery: a productivity application and a sample application. Productivity applications are fully functional applications that have been designed to address a specific business need. A productivity application is not editable by default. To edit a productivity application, you must first unlock it. A sample application is not a complete application but instead contains code snippets or sample code. Sample applications are editable by default.

In this tutorial, you install and unlock the productivity application, Checklist Manager. Then, you install and run the sample application, Sample Calendar.

Oracle Application Express is a rapid web application development tool for the Oracle Database. Using only a web browser and limited programming experience, you can develop and deploy professional applications that are both fast and secure. Oracle Application Express is available with the Oracle Database, whether it's on-premises or in the Oracle Cloud.

What Do You Need?

  • Access to Oracle Application Express 18.1 or later.

Accessing Your Development Environment

How you sign in and access Oracle Application Express release 18.1 depends upon where Oracle Application Express resides. Oracle Application Express may reside in a local on-premises Oracle Database or in a hosted environment, such as the Oracle Cloud. The sign in credentials you use to sign in differ depending upon the installation type.

  • Free Workspace: Give Oracle Application Express a test run by signing up for a free workspace. To request an evaluation workspace, go to apex.oracle.com, and click Get Started for Free.
  • Oracle Cloud: Develop and deploy applications without worrying about infrastructure, repair, and downtime. Oracle Application Express is available in Exadata Express Cloud Service and Database Cloud Service. However, you need to manually customize your databases to install and enable Oracle Application Express. To learn more, see Oracle Database Cloud Service.
  • Oracle Application Express On-premises: Install Oracle Application Express directly within any Oracle Database and then sign in to your workspace using your sign in credentials. For details on your sign in credentials, contact your administrator or see Oracle Application Express Installation Guide.
  • Oracle Application Express Pre-Built VM: Install a Pre-Built Virtual Machine (VM) which includes an Oracle Database and Oracle Application Express 18.1. To learn more, see Hands-On Labs.
    Once the VM is installed, start the VM:
    • Click the big red circle labeled Start.
    • Click the APEX shortcut, or enter the following URL: http://localhost:8080/ords/f?p=4550:1
    • When prompted to sign in, enter the sign in credentials (unless given other credentials to use):
      • Workspace : obe
      • Username : obe
      • Password : oracle

Note your Application ID may be different when compared to the screenshots in this tutorial. Your Application ID is assigned automatically when you create the application.

section 1Access the Packaged Apps Page

You install packaged applications by signing in to your workspace and accessing the Packaged Apps gallery.

To access the Packaged Apps gallery:

  1. Sign in to your development environment.
  2. On the Workspace home page, click the Packaged Apps icon.

    The Packaged Apps gallery appears.

    3. Workspace home page
    Description of the illustration packaged_app_home. png
  3. Review the available applications.
    • Click the Search field at the top of the page and enter keywords to narrow the display.
    • Click the buttons to the right of Search field to narrow the display:
      • All. Click All to view all packaged apps.
      • Productivity. View only productivity applications. Productivity applications are fully functional applications that have been designed to address a specific business need. Once a productivity application is installed, you must unlock it before you can edit it.
      • Sample. View only sample applications. Sample applications are not a complete application but instead contain code snippets or sample code. By default, sample applications are fully editable.
      • Installed. View previously installed packaged applications.
  4. Locate the Checklist Manager application icon.
    5. Checklist Manager application icon
    Description of the illustration checklist_manager_app.png

section 2Install and run a Productivity Application

  1. Click the Checklist Manager application icon.

    2. The App Details page appears.

  2. Click Install Packaged App.
    3. Cheklist manager Install package window
    Description of the illustration checklist_install_packaged_app.png
  3. Select an Authentication scheme and click Next.
    4. Install Packaged App page
    Description of the illustration application_modal_window.png
  4. Click Install Packaged App again.

    5. The App Details page appears. The success message, Application installed, displays at the top of the page.

    Application Installed confirmation window
    Description of the illustration installed_application.png
  5. To run the application, click the Run icon.
    6. Checklist Manager Run window
    Description of the illustration run_packaged_application.png

    The Checklist Manager Sign In page appears.

    checklist-manager-login
    Description of the illustration checklist_manager_login.png
  6. Enter your workspace username and password and click Sign In.

    7. The Welcome to Checklist Manager page appears.

    checklist-manager-app-welcomepage
    Description of the illustration checklist_manager_app_welcomepage.png
  7. Select the appropriate options and click Complete Set Up.

    8. The Checklist Manager application appears.

    checklist-manager-app-landingpage
    Description of the illustration checklist_manager_app_landingpage.png

    Note: The Application is locked and you cannot edit the application.

  8. Return to Packaged App Details page.

section 3Unlock and Run and Productivity Application

Productivity application are not editable by default. In order to edit a productivity application, you must unlock it.

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

To unlock Checklist Manager:

  1. On the App Details page, click Manage.
    2. Checklist Manager Manage Window
    Description of the illustration checklist_manager_manage.png

    The Manage dialog displays three options:

    • Change Authentication
    • Unlock
    • Remove
  2. Click Unlock.
    3. Checklist Manager Unlock window
    Description of the illustration checklist_manager_manage_page.png

    The Unlock Packaged Application dialog appears.

  3. Click Unlock Application.
    4. Unlock application window
    Description of the illustration unlocking_checklist_manager_app.png
  4. The application shows as Installed (Unlocked) on the Packaged Application Details page.
    5. Checklist manager unlock sucess message window
    Description of the illustration successfully_unlocked.png
  5. To run the application, click the Run icon.

    6. The Unlocked Packaged Application appears.

    checklist-manager-unlocked
    Description of the illustration checklist_manager_unlocked.png

    Notice that the Runtime Development Toolbar now displays at the bottom of the page. You can use this toolbar to quickly edit the current application or currently running page, or view session state.

  6. Click Home on the development toolbar to return to Workspace home page.

section 1Install and Run a Sample Application

Perform the following steps to install and run the sample application, Sample Calendar:

  1. On the Workspace home page, click the Packaged Apps icon.

    2. The Packaged Apps gallery appears.

    Packaged Apps landing page
    Description of the illustration packaged_apps_home.png
  2. Enter Sample Calendar in the search bar and press the Enter key.
  3. Click Sample Calendar.
    4. Sample Calendar app page
    Description of the illustration packaged_gallery_search.png

    The App Details page displays.

  4. Click Install Packaged App.
    5. Sample Calendar install packaged app window
    Description of the illustration install_sample_calendar.png
  5. Click Next.
    6. Install Packaged App window
    Description of the illustration install_packaged_app_step1.png
  6. Click Install Packaged App.
    7. Install Packaged App window2
    Description of the illustration install_packaged_app_step2.png

    The App Details page appears. The success message, Application installed, displays at the top of the page.

    The application shows as Installed (Unlocked) in the Packaged App Details page. Notice that this application is unlocked by default.

  7. Click the Run icon.
    Sample Calendar run window
    Description of the illustration sample_calendar_installed_unlocked.png

    The Sample Calendar Sign In page appears.

    Sample Calendar sign in window
    Description of the illustration sample_calendar_sign_in_page.png
  8. Enter the your workspace username and password and click Sign In.

    9. The Sample Calendar application's home page displays. Notice that the Runtime Development Toolbar displays at the bottom of the page indicating the application is editable.

    Sample Calendar Landing page
    Description of the illustration sample_calendar_home_page.png
  9. Return to Packaged Apps gallery page.

section 2Remove a Packaged Application

To remove a packaged application:

  1. One the Packaged Apps gallery page, clear the  Search field and press Enter.
  2. Click the Installed tab and select the application to be removed.
    3. Installed App page
    Description of the illustration installed_apps.png
  3. Click Manage.

    4. The Manage dialog displays two optionss:

    • Change Authentication
    • Remove
  4. Click Remove.
    5. Sample Calendar remove window
    Description of the illustration remove.png
  5. When prompted, click Remove Application.
    Remove Packaged Application window
    Description of the illustration remove_packaged_app.png

    The message Application removed appears on the App Details page.

more informationWant to Learn More?