1. Using Oracle Database Exadata Express Cloud Service
  2. Rapidly Developing Web Applications using Application Express
  3. Manage Oracle Application Express Packaged Apps and Sample Code

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

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

Follow these steps to install a Packaged App or sample code:

  1. Access Productivity Apps from the Exadata Express console. See Access Oracle Application Express.
  2. Locate and click the Packaged App or sample code you want to install.

    The application information page displays.

  3. Click Install Application.

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

  5. On the confirmation page, click Install Application.

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

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

  8. Click Run Application icon Run 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 Oracle Application Express Application Builder from theOracle Database Exadata Express Cloud Service console. See Access Oracle Application Express.

    The Application Builder home page displays.

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

    The application information page displays.

  3. Click Manage.

    The Manager page displays.

  4. 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 Exadata Express Cloud Service using Oracle Application Express.

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

  1. Access Oracle Application Express Application Builder from the Exadata Express console. See Access Oracle Application Express.

    The Application Builder home page displays.

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

    The application information page displays.

  3. Click Manage.

    The Manager page displays.

  4. Click Remove.

  5. To confirm, click Remove Application.