Add an Oracle Application Express application

The purpose of this tutorial is to walk through the process of setting up an Oracle Application Express application through the Access Gateway Admin UI console.


Oracle Application Express Architecture

Before you begin

Ensure that:

  • Access Gateway is installed and configured for use.
    See Manage Access Gateway deployment.
  • Access Gateway has been configured to use your Okta tenant as IDP.
    See Configure your Okta tenant as an Identity Provider for more information about configuring your Okta tenant as an IDP.
  • You have administrator rights on your Okta tenant and can assign applications to users and create groups.
  • An external Oracle Application express based application that requires protection.
  • The external app version is supported. Oracle Application Express supported versions include:
    • v10g or later
  • Appropriate DNS entries exist for both the protected application and the external URL. For example:
    https://app-ex.externalexample.comExternal or customer facing application URL.

    Internal or protected application URL of Oracle Application Express.

This application is part of a class of applications which exchange user information using header variables. See Add a generic header application for more information about the Access Gateway generic header application.

Access Gateway also provides a sample header application. See Add a sample header application.

Typical workflow



Create a containing group
  • Best practice, create an optional group to be assigned to the application.
Create an application
  • Create an Oracle Application Express application.
Configure certificates
  • Assign an optional certificate to the application.
Confirm attributes
  • Confirm required attributes and add additional optional attributes
Test the application
  • Test the application using header and policy simulation.
  • When required troubleshoot the integration.