Manage Oracle Application Express Packaged Apps and Sample Code

You can install Oracle Application Express Packaged Apps and sample code.

• Packaged Apps. These are applications that can be installed, run, locked, unlocked and removed. They are fully supported by Oracle. You can add users, manage user access, and make changes that meet your needs.

• Sample Code. These are samples that illustrate a concept or demonstrate a technique. They can be installed, run, removed, viewed and modified.

Topics:

• Install Packaged Apps and Sample Code

• Lock and Unlock Packaged Apps

• Modify Packaged Apps and Sample Code

• Remove Packaged Apps and Sample Code

Install Packaged Apps and Sample Code

The Oracle Application Express Application Builder, which is available with Oracle Database Cloud Schema Service, allows you to quickly install and run a variety of built-in business process applications called Packaged Apps.

Tutorial – Installing and Running a Packaged Application in Oracle Application Express

Follow these steps to install Packaged Apps or sample code:

1. Access the Service Console for your Schema Service. See Access the Service Console.
   The Service Console appears.
2. If the Service Console includes the Develop icon, click Develop. Otherwise skip this step.

   Note:

   If you purchased the service prior to August 2017, the Service Console is the Oracle Application Express home page and will not include the Develop icon.
3. Click Packaged Apps.

   The Packaged Apps home page appears.

   
   Description of the illustration packaged_apps_gallery.jpg
4. Locate and click the Packaged App or sample code you want to install.

   The application information page displays.

5. Click Install Application.
6. For Authentication, select one of the following and click Next:

   • Oracle Cloud Identity Management (default) - Users of this packaged application are managed through the Identity Console. See Adding Users and Assigning Roles in Getting Started with Oracle Cloud.

   • Application Express Accounts - Users of this packaged application are managed from the Application Express Administration. See Managing Users in a Workspace in Oracle Application Express Administration Guide.

7. On the confirmation page, click Install Application.
8. If you selected Application Express authentication, you need to add users from Oracle Application Express Administration before running the application. See Managing Users in a Workspace in Oracle Application Express Administration Guide.
9. If you selected Oracle Cloud Identity Management, the users currently authorized with access to your service have access to this application. Use the Oracle Cloud portal to add users. See Adding Users and Assigning Roles in Getting Started with Oracle Cloud.
10. Click Run Application icon .

Lock and Unlock Packaged Apps

Packaged Apps can be locked and unlocked. When locked, Packaged Apps cannot be modified.

To lock or unlock a Packaged App:

1. Access the Service Console for your Schema Service. See Access the Service Console.
   The Service Console appears.
2. If the Service Console includes the Develop icon, click Develop.

   Note:

   If you purchased the service prior to August 2017, the Service Console is the Oracle Application Express home page and will not include the Develop icon.
3. Click Packaged Apps.

   The Packaged Apps home page appears.

4. Locate and click the Packaged App you want to unlock or lock.

   The application information page displays.

5. Click Manage.
   The Manager page displays.
6. Click Unlock to allow modifications, or Lock to not allow modifications.

Modify Packaged Apps and Sample Code

You can modify sample code and unlocked Packaged Apps just like any other Database or Websheet application you have created or imported. Packaged Apps must be unlocked before they can be modified.

See Modify a Database Application and Modify a Websheet Application.

Note:

Installed sample code can be modified. Installed packaged applications cannot be modified.

Remove Packaged Apps and Sample Code

Packaged Apps and sample code can be removed from your Oracle Database Cloud Schema Service using Oracle Application Express.

Follow these steps to remove a Packaged Apps and sample code:

1. Access the Service Console for your Schema Service. See Access the Service Console.
   The Service Console appears.
2. If the Service Console includes the Develop icon, click Develop.

   Note:

   If you purchased the service prior to August 2017, the Service Console is the Oracle Application Express home page and will not include the Develop icon.
3. Click App Builder.

   The Oracle Application Express Application Builder home page displays.

4. Locate and click the Packaged App or sample code you want to remove.

   The application information page displays.

5. Click Manage.
   The Manager page displays.
6. Click Remove.
7. To confirm, click Remove Application.