Interactive Reporting Regions enable end users to customize reports. Users can alter the layout of report data by displaying the columns they are interested in, applying filters, highlighting, and sorting. They can also define breaks, aggregations, include a chart, and their own computations. Users can create multiple variations of the report and save each as a named report. There are also multiple download formats available, including comma-delimited file (CSV) format, Microsoft Excel (XLS) format, Adobe Portable Document Format (PDF), and Microsoft Word Rich Text Format (RTF).

Declarative BLOB support enable files to be declaratively uploaded in forms, and downloaded or displayed using reports. BLOB display and download can also be authored procedurally using PL/SQL.

Report Queries now support multiple SQL statements, which allows for including multiple reports in a single document or combining reports and charts based on different result sets. The output format of a print document can now be set at runtime using a page or application item. In addition to PDF, Word, Excel and HTML, documents can now also be downloaded in XML format. Both report queries and report regions now allow specifying the method of how the print document is downloaded to the client, either as an attachment, displaying a file download / save dialog or showing the document inline within the browser window. The column sizing for print documents based on report regions has also been improved, now supporting sizing based on points in additional to percentage.

In addition to the default themes provided with Oracle Application Express, you can create your own customized themes. This enables you to design a very specific look and feel to meet your corporate requirements and then publish this as a theme for all other applications to use. This can be done at the workspace level (Workspace Themes) or at the instance level (Public Themes). Two new standard themes have also been added.

For testing and production instances, release 3.1 supports the ability to install just a runtime version of Oracle Application Express. This minimizes the installed footprint and privileges. Scripts are also provided to remove or add the developer interface from an existing instance. This new feature improves application security because in a runtime instance developers cannot inadvertently update a production application.

There is a new 'Hidden and Protected' item type. Items of this type cannot be set via the url, only via processes within the application and greatly simplifies the developer's task of protecting item session state. This, together with other minor improvements, makes the default security functionality more robust within Oracle Application Express.

You now have the ability to suppress standard JavaScript and CSS files. All included JavaScript files have been compressed to improve page load time. The framework has also been improved to allow advanced Oracle Application Express developers to build and leverage custom Web 2.0 capabilities. This increases performance and enables developers to create more dynamic application widgets.

You can define a date format that will be used throughout your application. This date format will be used to alter the NLS_DATE_FORMAT database session setting prior to showing or submitting any page within the application. This format is used by all reports showing dates and is also picked up by form items of type "Date Picker (use Application Date Format)". This can be set using:

1. Application Builder > Application Builder Defaults (under Tasks): These are specific to a Workspace, not a developer, and will be used as the default when using the create application wizard.
2. Application Builder > Create Application Wizard > Attributes page
3. Application Builder > Your Application > Shared Components > Edit Globalization Attributes

• The ability to add a search region when creating a report
• Report Partial Page Refresh (PPR) is now an option, rather than a special template
• You can now include attachments with emails sent using the Application Express mail APIs
• The previous 32K limit on data when creating an application on a spreadsheet has been removed
• You can now create master detail reports in the create application wizard
• Master detail report implementation has been improved and refined
• CSS and Javascript can now be suppressed for a Page definition - especially useful for mobile applications
• Support for declarative Media Type enables generation of pages of type other than 'text/html'