Accessing Interactive Reports

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, sign in using your account credentials (that is, your username and password), and then navigate to the report page.

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.
Accessing an Interactive Report
Access an interactive report 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.

Parent topic: Using Interactive Reports

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:

http://apex.somewhere.com/pls/apex/f?p=4350:1:220883407765693447

f?p=: Indicates that you are accessing an Oracle Application Express application.
4350: The application ID. The application ID specifies which application to access.
1: 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.
220883407765693447: 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.

WARNING:

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 report 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:

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