3.2 Accessing Interactive Reports

An interactive report is contained in a page within a database application. To access an interactive report you must go to the database application URL, log in using your account credentials (that is, your username and password), and then navigate to the report page.

3.2.1 About Interactive Report URLs

You can access interactive reports directly with their URL. Interactive report URLs contain an application ID and a page ID. When you access an application page, the session ID also generates in the address bar.

Parts of an Interactive Report URL

The following is an example of an Interactive Report URL:
Indicates that you are accessing an Oracle Application Express application.
The application ID. The application ID specifies which application to access.
The page ID. The page ID specifies which page to access within the application. Depending on how the developer configured the page, the page ID may be a word, such as home.

The session ID. The Application Express engine uses the session ID to fetch session state from the database. Oracle Application Express assigns new session IDs during authentication processing, records the authenticated user's identity with the session ID, and continually checks the session ID in each page request's URL or POST data with the session cookie and the session record in the database.


Do not enter the session ID when you access an interactive report URL. Entering information beyond the page ID displays an error.

3.2.2 Accessing an Interactive Report

Access an interactive grid by navigating to the URL provided by your application developer. Ensure the URL includes the application ID and page ID, but not the session state ID.

If you do not have a URL or the URL does not work, contact the developer.

To access an interactive report:

  1. Click the supplied URL, or enter it in your browser's Address field.
    A Login page appears.
  2. On the Login page:
    1. Username - Enter your username.
    2. Password - Enter your password.
    3. Click Log In.


    The language that displays differs depending upon who creates the application. For Oracle-supplied applications, including packaged applications and the Oracle Application Express development environment, Sign In or Sign out displays. For applications you or your developers create, Log In or Log out displays.

    The interactive report appears.

See Also:

"Understanding Session State Management" in Oracle Application Express App Builder User’s Guide