When you sign in to Oracle Application Express development environment, the Workspace home page appears. A workspace is a virtual private database which enables multiple users to work within the same Oracle Application Express installation while keeping their objects, data and applications private. This section describes the Workspace home page.
The following large icons display in the center of the page:
Application Builder. Use Application Builder to create an application, composed of a set of HTML pages, based on database objects. See "Application Builder Concepts" and "Understanding Application Builder."
SQL Workshop. Use the SQL Workshop to access tools for viewing and managing database objects. See Oracle Application Express SQL Workshop Guide.
Team Development. Use Team Development to track new features, non-feature related tasks (or To Do tasks), bugs, and milestones. Users can also provide real-time feedback which then can be categorized into features, general tasks, or bugs. See "Managing the Application Life Cycle with Team Development."
Packaged Apps. Links to the Packaged Apps page. See "Utilizing Packaged Applications."
An menu bar also displays at the top of the page. Click a menu to access an alternate navigation path to different components within Application Builder, SQL Workshop, Team Development, and Packaged Apps.
The Top Applications and Top Users regions display at the bottom of the page. These regions offer real time information about development activities in the current workspace.
The News and Messages region can display three types of messages:
News entries
System messages
Workspace Announcements
News entries include a date to the left of the message text. Developers can create news entries to communicate with other workspace users. To add a news entry, click the Create News Entry icon which resembles a plus sign (+). To edit existing news entries, click Edit News Entry which resembles a greater than sign (>).
Both workspace announcements and system messages include a gold icon to the left of message text. A textual identifier, either System Message
or Workspace Announcement
, also displays beneath the message text.
See Also:
"Managing News Entries" and "Defining a System Message" and "Defining a Workspace Announcement" in Oracle Application Express Administration GuideThis section describes Developer Navigation tools available in the header region on many Oracle Application Express pages, including the Workspace home page, Application Builder home page, the Application home page, Page Designer, Component View, and Shared Components.
The Search field displays in the header region in upper right corner of most Application Builder pages. How the search field works depends upon the page you are on. Consider the following examples:
Workspace home page - Search for application names.
Application Builder home page - Search for application metadata across all applications.
Application home page - Search for application metadata across the current application.
Team Development home page - Search the Team Development home page and other pages within Team Development.
Workspace Administration home page - Search for users.
Within Application Builder and on the Application home page, use the following special syntax to navigate to a specific page or search for a regular expression:
page application_ID:page application_ID-page regexp:expression
Where:
application_ID
is the numeric identification number (or ID) that identifies an application.
page
is the numeric identification number that identifies a specific page.
regexp:
is literal text.
expression
is a regular expression to search for.
The following example navigates you to page 10 of application 570:
10 570-10 570:10
You can also use this syntax to navigate to the Shared Components page of a given application:
application_ID:s application_ID-s
Where:
application_ID
is the numeric identification number (or ID) that identifies an application.
The following example demonstrates how to navigate to the Shared Components page of application 570:
570:s 570-s
The Administration menu displays to the right of the Global Search field and features an outline person with a wrench. Clicking this menu displays the following options:
Administration links to the Workspace Administration page. See "Workspace and Application Administration" in Oracle Application Express Administration Guide.
Manage Service displays a submenu of options on the Manage Service page. See "Manage Service Page" in Oracle Application Express Administration Guide.
Manage Users and Groups link to Manage Users and Groups page. See "Managing Users in a Workspace" in Oracle Application Express Administration Guide
Monitory Activity. links to the Monitor Activity page. Use this page to monitor changes to page views, developer activity, page view analysis, and active sessions. It also shows reports on such information as login attempts and external click counts. See "Monitoring Activity Within a Workspace" in Oracle Application Express Administration Guide.
Dashboards links to the Dashboard page. Use this page to view details about the current workspace and monitor users, activity, developer activity, performance, Websheet application development, application development, and view database details. See "Viewing Workspace Dashboards" in Oracle Application Express Administration Guide.
Change My Password - Links to the Change Password section of the Edit Profile dialog box. See "Changing Your Password."
The Help menu resembles a question mark. Clicking Help displays the following menu items:
Documentation. Links to Oracle Application Express, Release 5.0 Oracle Help Center. See "Using Oracle Application Express Documentation."
Discussion Forum. Link to Application Express Discussion Forum:
https://community.oracle.com/community/database/developer-tools/application_express
Oracle Technology Network. Link to Oracle Application Express page on Oracle Technology Network:
http://www.oracle.com/technetwork/developer-tools/apex/overview/index.html
About. Links links to the About Application Express dialog. This dialog includes information about the Oracle Application Express instance and the database version.
The Account menu displays in the upper right corner of the page and features an outline of a person. The Account menu displays your username, current workspace, and user role. If Single Sign On (SSO) is enabled, the link Change Workspace also appears. Key controls on this menu include:
Edit Profile. Click Edit Profile to edit your first and last name, upload or choose a photo image, alter your email address (if SSO is not enabled), and reset your password. See "Editing Your Account Profile and Preferences."
Tip:
If you are using Single Sign-on authentication, Change Workspace also displays. Click Change Workspace to view a list of workspaces you have access to.Preferences. Click Preferences to change your default schema, default date format, and control how Application Builder runs applications. See "Editing User Preferences."
Sign Out - Click Sign Out to log out the current workspace. See "Signing Out of a Workspace."
See Also:
"Editing Your Account Profile"The Available Updates region indicates if updates are available for Oracle Application Express and the Oracle REST Data Services. If your installation is current the following message displays:
System is up-to-date
To configure updates, click Set Preferences for Available Updates. You can enable or disable updates by selecting Yes or No from Check for Available Updates.
Tip:
To perform this check Application Express transmits the version number of Oracle Application Express and other system components to Oracle Corporation. In order to continuously improve our products, Oracle is interested in learning about product usage. To that end, statistics can occasionally be sent to Oracle describing the product features in use. No personally identifiable information is sent. To review Oracle's privacy policy see: