Working With Packaged and Sample Applications in Oracle Application Express 5.0

Purpose

In this tutorial, you learn how to perform the following tasks in Oracle Application Express 5.0:

• Install and Run a Productivity application from the Packaged Apps gallery.
• Unlock the Productivity application for editing.
• Install and Run a Sample Application from the Packaged Apps gallery.

Time to Complete

Approximately 25 minutes.

Overview

Oracle Application Express (Oracle APEX) 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 an Oracle Database Cloud Service.

Oracle Application Express includes two types of Packaged Apps:

• Sample applications
• Productivity applications

Both the Sample and Productivity applications are fully functional applications that have been designed to address a specific business need. The main difference between a Sample and Productivity application is the level of support. By default, Sample applications are fully editable. In contrast, you must unlock a Productivity application before you can edit it. Unlocking a Productivity application makes it ineligible for future upgrades or support by Oracle Support.

For more information on Packaged and Sample applications, please refer to Managing Oracle Application Express Packaged Apps and Sample Code on Oracle Help Center.

Please keep in mind the following while running this tutorial:

• Logging into your Oracle Application Express workspace: Your Oracle Application Express workspace may reside in an on-premises Oracle Database or in Oracle Database Cloud Services. The login credentials differ depending on where your workspace is located:
  • Logging into Oracle Application Express in a Oracle Database Cloud Service:  Reference the Oracle Help Center for your Oracle Database Cloud Service. To do this, go to the Oracle Help Center for Cloud, and select Platform and Infrastructure. From here, select your Database Cloud Service and the Get Started page will appear.
  • Logging in to Oracle Application Express on-premises: From your browser, go to the location of your on-premises installation of your Oracle Application Express workspace provided by your Workspace Administrator.
• Application ID: Screenshots in this tutorial show a blurred Application ID. Your Application ID can be any value assigned automatically while creating the application.
• Schema: If you are accessing an Oracle Application Express workspace in Database Schema Service,  you have one schema assigned to you with a schema name that you cannot change. If you are accessing the workspace in an on-premises Oracle database, you may have more than one schema assigned to your workspace by the Oracle Application Express Instance Administrator.

What Do You Need?

Before starting this tutorial, you should:

• Have access to an Oracle Database 11g or later release, either on-premises or in a Database Cloud Service.
• Install Oracle Application Express Release 5.0 into your Oracle Database (for on-premises only).
• Provision at least one Oracle Application Express user. See Creating New User Accounts in Oracle Application Express Administration Guide.

In this topic, you install a Productivity application from Packaged Apps provided by Oracle Application Express. Log in to your Oracle Application Express workspace, either on-premises or in Oracle Database Cloud Service, and perform the following steps:

1. From the Oracle Application Express home page,  click the down arrow next to the Packaged Apps tab and select Apps Gallery.
   

   

2. Locate and click the Checklist Manager application icon.

   

3. The Checklist Manager productivity application details are displayed. Click Install Application.

   

4. Select Application Express Accounts for Authentication, and click Next >.
   

   

5. Click Install Application.

   

6. Since you selected Application Express Accounts for Authentication, the wizard prompts to create an Oracle Application Express user. In this case, since we already have an Oracle Application Express user provisioned, deselect the Create Application Express User checkbox, and click Create User.
   
   Note: Even though, you click the 'Create User' button, the user creation is skipped because of deselecting the 'Create Application Express User' checkbox.

   

7. The Checklist Manager application is installed. Click the Run icon.

   

8. Enter your Oracle Application Express credentials, and click Sign In.

   

9. The Checklist Manager application's home page is displayed. Click the IT Projects 39% checklist.

   

10. This checklist represents IT projects. Each row represents a project and each column represents a task for that project. To change the Percent Completed of a task, click the respective circle.

    

11. The Change Percent dialog opens. Select a different percent value, and click Apply.

    

After a productivity application is installed, you can run the application directly. But, you must unlock it before you can edit it. To unlock an installed Productivity application, perform the following steps:

1. Go back to the Oracle Application Express window where the Package Appliction details page is currently open with the details of Checklist Manager. Click Manage.

   

2. Click Unlock.

   

3. Click Unlock Application.

   

4. The application shows as Installed (Unlocked) in the Packaged Application Details page.

   

By default, Sample Applications are fully editable. You do not need to explicitly unlock them. Perform the following steps to install and run a Sample Application:

1. Click the Packaged Apps Gallery breadcrumb.

   

2. Enter Sample in the search bar, press the Enter key. Locate, and click Sample Calendar.

   

3. The Sample Calendar sample application details are displayed. Click Install Application.

   

4. Click Next >.

   

5. Click Install Application.

   

6. Deselect Create Application Express User checkbox, and click Create User.

   

7. The application shows as Installed (Unlocked) in the Packaged Application Details page. Notice that this application is unlocked by default. Click the Run icon.

   

8. The Sample Calendar application's home page is displayed. Notice the developer toolbar below the home page. This shows that the application is already unlocked.

   

In this tutorial, you have learned how to:

• Install and Run a Productivity application from the Packaged Apps gallery.
• Unlock the Productivity application for editing.
• Install and Run a Sample Application from the Packaged Apps gallery.

• Oracle Cloud Home Page

• Other tutorials on Oracle Database Cloud Service - Database Schema Service

• Curriculum Developer: Anjani Pothula

• Other Contributors:Drue Swadener