5.9.1 Editing the Application Definition

Use the application Definition page to change general application attributes such as the application name, version number, and control various properties and behaviors (such as logging, debugging, feedback, compatibility mode, application availability, error handling, and substitution strings). Accessing the Definition Page

To access the Definition page:

  1. On the Workspace home page, click the App Builder icon.
  2. Select an application.
    The Application home page appears.
  3. From Application home page, you can access the Definition page in two ways:
    • Click the Edit Application Properties button.
    • From Shared Components:
      • Click Shared Components.

      • Under Application Logic, click Application Definition Attributes.

    The Edit Application Definition page appears.

  4. Edit the appropriate attributes.
  5. Click Apply Changes to save your changes. Application Definition Page

The Edit Application Definition page is divided into the following regions: Name, Properties, Application Icon, Availability, Error Handling, Gloal Notification, Substitutions, and Build Options.


Required values are marked with a red asterisk (*). Name

Use Name attributes to define basic characteristics of your application, including the application name, an optional alphanumeric alias, and a version number.

Table 5-4 Application Definition, Name

Attribute Description To Learn More


A short descriptive name for the application to distinguish it from other applications in your development environment.


Application Alias

Assigns an alternate alphanumeric application identifier. You can use this identifier for the application ID.

When the Friendly URLs attribute is enabled, the Application Alias specified here displays in the URL when running the application. Applications created using Oracle Application Express 20.1 or later default the Application Alias to the application Name.



Enter the application's version number. The value enter displays on the page. You can also automatically tie the version to the date of last modification using the following format masks:




If your application version uses YYYY.MM.DD, then App Builder replaces this format mask with the date of last modification of any application attribute.


Application Group

Displays the application group currently associated with this application. To select another application group, make a selection from the list. To remove an application from an existing group, select Unassigned.

See Managing Application Groups Properties

Use Properties attributes to configure logging, debug behavior, feedback, compatibility, email from address, and the application proxy server.

Table 5-5 Application Definition, Properties

Attribute Description To Learn More


Determines whether user activity is recorded in the Oracle Application Express activity log. Select Yes to log every page view and enable an administrator to monitor user activity for each application.

Disabling logging may be advisable for high volume applications.

This attribute can only be modified if the Application Activity Logging attribute in Oracle Application Express Administration Services is set to Use Application Setting.

See Enabling Application Activity Logging in Oracle Application Express Administration Guide


Controls debug mode for the current application. Available options include:

  • Yes - Enables the application to run in a debug mode from a browser at runtime.

  • No - Disables the application from enabling in debug from a browser.

Running an application in debug mode is useful when an application is under development. For production applications, Oracle recommends disabling debugging and thus preventing users from viewing application logic.

Debug can be enabled programmatically regardless of this debug setting. If the application is run from the Application Express development environment, debugging can always be enabled.


Allow Feedback

Enables support for end user feedback for this application. Select Yes or No.

If you select Yes and enable this option, you must create a feedback page and navigation bar icon to call that page. If you later disable feedback, the navigation bar icon is hidden. This enables you to turn on feedback for testing and turn it off for production.

See Managing Feedback

Compatibility Mode

Controls the compatibility mode of the Application Express runtime engine. Certain runtime behaviors change from release to release. To not break or change the behavior of existing applications, this attribute is automatically set during upgrade if necessary.

Use this attribute to obtain specific application behavior. Compatibility Mode options include Pre 4.1, 4.1, 4.2, 5.0, 5.1/18.1/18.2, 19.1, and 19.2/20.1, 20.2, 21.1. To keep applications maintainable, set Compatibility Mode to the latest release after reviewing the changed behavior in the Release Notes and making the necessary changes.


Application Email from Address

Determines the email address to use as the from address in the application.

Enter a valid email address to use as the from address when sending email from an email download or subscription. The value can be a literal string containing a valid email or a static substitution reference defined in the application using substitution syntax APP_EMAIL. Examples:


Oracle does not recommend using an item substitution at the application or page-level since it only works in email download, but not for subscriptions.

Tip: You can also specify the Email from Address by editing interactive report attributes. See "About Emailing from an Interactive Report."


Proxy Server

Specify a proxy server.

For example, App Builder may require a proxy server when using a region source type of URL. The URL region source embeds the results of the URL (that is, the page returned by navigating to the URL) as the region source. If you use a firewall and the target of a URL is outside the firewall relative to App Builder, you may need to specify a proxy server.

You can reference values entered into this field from PL/SQL using the PL/SQL package variable APEX_APPLICATION.G_PROXY_SERVER.

For example:


n/a Application Icon

In Icon File Name, enter the file name of an image which displays as the Application Icon in App Builder. The image should be 64 x 64 pixels, must be uploaded as Application Image within Shared Components, and must be present at the 'root' level (that is, not within a folder).

See Also: Availability

Use Availability attributes to manage your application by defining an application status and build status. For example, if you select the status Restricted Access, you can specify which users have access and can run the application.

Table 5-6 Application Definition, Availability

Attribute Description To Learn More


Specifies whether the application is available or unavailable for use. Options include:

  • Available - Application is available with no restrictions.

  • Available with Developer Toolbar - Application is available for use. For developers, the Developer Toolbar displays on each page. Requires the developer to be logged in to App Builder in the same browser session.

  • Available to Developers Only - Application is available to users having developer privileges.

  • Restricted Access - Application is available to developers named in the Restrict to comma separated user list.

  • Unavailable - Application cannot be run or edited. The message in Message for unavailable application displays when users attempt to access the application.

  • Unavailable (Status Shown with PL/SQL) - Application cannot be run or edited.

  • Unavailable (Redirect to URL) - Application cannot be run. The user is linked to the URL entered in Message for unavailable application.

Build Status

Identifies the build status of the current application. Options include:

  • Run and Build Application - Developers and users can both run and develop the application.

  • Run Application Only - Users can only run the application. This option is intended for applications in a production instance.

See Changing Application Build Status in Administration Services in Oracle Application Express Administration Guide

Message for unavailable application

Use this attribute with Status. If you set Status to Unavailable, Unavailable (Status Shown with PL/SQL), or Unavailable (Redirect to URL) , the text you enter in this attribute displays. If you set Status to Available, the text you enter in this attribute does not display.


Restrict to comma separated user list (status must equal Restricted Access)

Use this attribute with the Status Restricted Access. If you set Status to Restricted Access, only the users listed in this attribute can run the application.

To use this attribute:

  1. From the Status list, select a restricted status.

  2. Enter a comma-delimited list of users who can run the application in the field provided.

  3. Click Apply Changes.

n/a Error Handling

Use the Error Handling attributes described to control or modify how an application logs errors.


Error handling functions specified here are overridden by similar page-level attributes.

Table 5-7 Application Definition, Error Handling

Attribute Description To Learn More

Default Error Display Location

Identifies where the validation error messages display for basic validations performed by Application Express or by plug-ins. Validation error messages can display in a notification area (defined as part of the page template), or within the field label. Options include:

  • Inline with Field and in Notification - Error messages display in a notification area defined as part of the page template.

  • Inline with Field - Error messages display within the field label.

  • Inline in Notification - Displays in the #NOTIFICATION_MESSAGE# template substitution string when an error occurs on the page.


Error Handling Function

Enter the name of a PL/SQL error function to be called to modify the existing error message and display a more user-friendly message or log the error if one occurs. This function can reference a package function or standalone function in the database. For example:


When referencing a database PL/SQL package or standalone function, use the #OWNER# substitution string to reference the parsing schema of the current application. For example:


You must implement error handling functions using the syntax described in the apex_error package.

function <name of function> (
    p_error in apex_error.t_error )
    return apex_error.t_error_result

Note: Error handling specified at the page-level overwrites any error handling function specified here.

See APEX_ERROR in Oracle Application Express API Reference Global Notification

Use the Global Notification attribute to communicate system status to application users. If the page templates used in your application contain the #GLOBAL_NOTIFICATION# substitution string, the text entered here displays in that string's place. For example, you can use this attribute to notify users of scheduled downtime, or communicate other messages regarding application availability.

To create a global notification:

  1. Include the #GLOBAL_NOTIFICATION# substitution string in your page template.

  2. Navigate to the Edit Application Definition page and enter a message in the Global Notification attribute.

  3. Click Apply Changes. Substitutions

Use Substitutions to define static substitution strings for your application. You can use static substitution string for phrases or labels that occur in many places within an application. To create a substitution string, enter the string name in the Substitution String column and the string value in the Substitution Value column.

Defining static substitution strings centrally enables you to change text strings in multiple places in your application by making a single change to the Substitution Value defined on this page. Build Options

Build Options displays existing build options in the current application. Most applications have a build option attribute. Build Options have two possible values: INCLUDE and EXCLUDE. If you specify an attribute to be included, then the Application Express engine includes and enables it at runtime. However, if you specify an attribute to be excluded, then the Application Express engine disables it and excludes it at runtime.

Do not specify a build option unless you plan to exclude that object from specific installations. Report Printing

Report Printing controls the print server of the application. These settings override the settings from Instance Administration. Available options include:
  • Native Printing - Use native printing. No external print server required.

  • Remote Print Server - Choose a remote server of the type Print Server that is configured in the Workspace Utilities.

  • Use Instance Settings - Use the Report Printing settings defined in Instance Administration.

Click the Add Remove Print Server button to open a wizard to create a Remote Print Server, including the credentials. To create a Remote Server, choose the Print Server Type, specify an Endpoint URL and click Next. If Authentication is required, specify the credentials. Click Apply Changes to add the Remote Print Server and Credentials to your workspace, and update the Report Printing attributes for the application. For detailed steps, see Configuring Report Printing at the Application-Level.

See Also: