Oracle® Application Express Patch Set Notes
Release 4.0.1.00.03
 

 

Oracle® Application Express

Patch Set Notes

Release 4.0.1.00.03

 

August 2010

These patch set notes accompany the Oracle Application Express 4.0.1.00.03 patch set.

This document contains these topics:

1 Patch Set Overview

Patch sets are a mechanism for delivering fully tested and integrated product fixes. Patch sets provide bug fixes only; they do not include new functionality and they do not require certification on the target system.

Patch sets include all of the libraries that have been rebuilt to implement the bug fixes in the set. All of the fixes in the patch set have been tested and are certified to work with each other.

Patch sets contain the same set of generic fixes across all platforms. Patch sets may also include additional patches specific to the platform on which they are released.

The Oracle Application Express 4.0.1.00.03 patch set can be applied to Oracle Application Express release 4.0.0.00.46. Apply the patch to the Oracle database where the Oracle Application Express schemas are installed. This patch will determine if additional languages are installed, and will apply the patch for those languages as well. Oracle Application Express release 4.0.1 is supported on Oracle Database 10gR2 (10.2.0.3) and higher.

When determining whether or not to install this patch set, consider the following rules:

  1. If you have Oracle Application Express release 4.0 installed, download the Oracle Application Express 4.0.1 patch set and apply it.

  2. If you have Oracle Application Express release 3.2.1 or earlier installed (including Oracle HTML DB release 1.5), download and install the entire Oracle Application Express 4.0 release from the Oracle Technology Network (OTN).

  3. If you do not have Oracle Application Express installed, download and install the entire Oracle Application Express 4.0 release from the Oracle Technology Network (OTN).

2 Pre-Installation Tasks

Complete the following pre-installation tasks before installing the patch set:

2.1 Identify the Oracle Application Express Installation

This is not a complete software distribution. You must connect to an existing Oracle Database where the Oracle Application Express schemas are installed and run the apxpatch.sql installation script.

2.2 Download and Extract the Installation Software

Download the patch set to a computer with access to the Oracle Database. You will also need access to the Oracle home.

To download and extract the patch set installation software:

  1. Download the p9976149_11201_GENERIC.zip patch set installation archive to a directory that is not the Oracle home directory or under the Oracle home directory.

  2. Unzip and extract the installation files as follows:

    • Microsoft Windows - Double-click the p9976149_11201_GENERIC.zip file

    • UNIX or Linux - Enter the following command:

      $ unzip p9976149_11201_GENERIC.zip
      

2.3 Optionally Backup the Oracle Database

The Application Express engine is a collection of tables and packages that reside wholly within the Oracle Database user accounts APEX_040000 and FLOWS_FILES. This patch set updates the underlying tables and packages within the APEX_040000 account. If your installation fails, you will not be able to rollback the patch set installation process. Therefore, Oracle recommends that you perform a complete backup of your Oracle instance before you install the patch set. Note that after the patch set is installed there is no way to remove it.

If you choose to perform a backup, restart the Oracle Database in restricted session mode to prevent any user access (that is, developer and end-user) while applying the patch set.

2.4 Prevent Access to Oracle Application Express

It is important that no developers or end users access Oracle Application Express while you are applying the patch set.

If your configuration includes Oracle HTTP Server and mod_plsql, you need to stop Oracle HTTP Server. See "Stop Oracle HTTP Server".

Alternatively, if your configuration includes the embedded PL/SQL gateway, you need to disable the Oracle XML DB HTTP Server. See "Disable Oracle XML DB HTTP Server".

2.4.1 Stop Oracle HTTP Server

To stop Oracle HTTP Server shipped with Oracle Database 10g release 1 (10.1) or later, enter commands using the following syntax, where ORACLE_BASE is the path to the Oracle base directory:

ORACLE_BASE\ORACLE_HTTPSERVER_HOME\opmn\bin\opmnctl stopproc ias-component=HTTP_Server

Note that if the Oracle HTTP Server is listening on a port less than 1024, then these commands must be executed as a privileged user (such as root).

2.4.2 Disable Oracle XML DB HTTP Server

The embedded PL/SQL gateway runs in the Oracle XML DB HTTP server in the Oracle database. To disable it, you change the port number to 0. Before doing so, verify the port number. See "Verifying the Oracle XML DB HTTP Server Port".

To disable Oracle XML DB HTTP server:

  1. Start SQL*Plus and connect to the database where Oracle Application Express is installed as SYS. For example:

    • Windows:

      DRIVE_LETTER:\> sqlplus /nolog
      SQL> SQL> CONNECT SYS as SYSDBA
      Enter password: SYS_password 
      
    • UNIX and Linux:

      $ sqlplus /nolog
      SQL> SQL> CONNECT SYS as SYSDBA
      Enter password: SYS_password 
      
  2. Run the following statements:

    EXEC DBMS_XDB.SETHTTPPORT(0);
    COMMIT;
    
2.4.2.1 Verifying the Oracle XML DB HTTP Server Port

To verify the port number where the Oracle XML DB HTTP Server is running:

  1. Start SQL*Plus and connect to the database where Oracle Application Express is installed as SYS specifying the SYSDBA role:

    • On Windows:

      SYSTEM_DRIVE:\ sqlplus /nolog
      SQL> CONNECT SYS as SYSDBA
      Enter password: SYS_password
      
    • On UNIX and Linux:

      $ sqlplus /nolog
      SQL> CONNECT SYS as SYSDBA
      Enter password: SYS_password
      
  2. Enter the following statement to verify the port number:

    SELECT DBMS_XDB.GETHTTPPORT FROM DUAL;
    

    If the port number returns 0, the Oracle XML DB HTTP Server is disabled.

3 Installation Tasks

Complete the following tasks to install the patch set:

  1. Set your current directory to the top-level "patch" directory where you unzipped the p9976149_11201_GENERIC.zip file.

  2. Start SQL*Plus and connect to the database where Oracle Application Express is installed as SYS specifying the SYSDBA role. For example:

    • On Windows:

      SYSTEM_DRIVE:\ sqlplus /nolog
      SQL> CONNECT SYS as SYSDBA
      Enter password: SYS_password
      
    • On UNIX and Linux:

      $ sqlplus /nolog
      SQL> CONNECT SYS as SYSDBA
      Enter password: SYS_password
      
  3. Run apxpatch.sql. For example:

    @apxpatch.sql
    
  4. Review the log file apxpatch.log for any errors.

4 Post-Installation Tasks

Complete the following post-installation tasks before using the upgraded software:

4.1 Update the Images Directory

During an upgrade, you must incorporate the new images directory. Copy the patch/images directory into the images directory used for Application Express.

4.1.1 Updating the Images Directory When Running Oracle HTTP Server

To locate the images directory on the file system, review the following files for the text alias /i/:

  • Oracle HTTP Server distributed Oracle9i Release 2—see the httpd.conf file.

  • Oracle Application Server 10g—see the marvel.conf or dads.conf files.

  • Oracle HTTP Server distributed with Oracle Database 11g—see the marvel.conf or dads.conf files.

When you locate the images directory path, copy it to the existing ORACLE_HTTPSERVER_HOME home.

On a Windows system, run a command from a command prompt similar to the following example:

xcopy /E /I patch\images ORACLE_HTTPSERVER_HOME\Apache\Apache\images

On UNIX or Linux based systems, run a command similar to the following example:

cp -rf patch/images ORACLE_HTTPSERVER_HOME/Apache/Apache

In the preceding syntax examples, ORACLE_HTTPSERVER_HOME is the existing Oracle Application Server or Oracle HTTP Server Oracle home. The location of the Oracle Application Express images directory may be different in your configuration.

4.1.2 Updating the Images Directory When Running the Embedded PL/SQL Gateway

The images in an Oracle XML DB HTTP Server with the embedded PL/SQL gateway installation are in the XML DB repository. Updating the images is accomplished by running the SQL Script apxldimg.sql located in the top level directory where the patch was unzipped.

To update the images directory:

  1. Set your current directory to the top-level "patch" directory where you unzipped the p9976149_11201_GENERIC.zip file.

  2. Start SQL*Plus and connect to the database where Oracle Application Express is installed as SYS specifying the SYSDBA role. For example:

    • On Windows:

      SYSTEM_DRIVE:\ sqlplus /nolog
      SQL> CONNECT SYS as SYSDBA
      Enter password: SYS_password
      
    • On UNIX and Linux:

      $ sqlplus /nolog
      SQL> CONNECT SYS as SYSDBA
      Enter password: SYS_password
      
  3. Run apxldimg.sql passing the file system path to the "patch" directory where the p9976149_11201_GENERIC.zip file was unzipped as shown in the following example:

    • On Windows:

      @apxldimg.sql SYSTEM_DRIVE:\TEMP\patch
      
    • On UNIX and Linux:

      @apxldimg.sql /tmp/patch
      

4.1.3 Updating the Images Directory When APEX Listener

If you are using the APEX Listener, you need to recursively copy the patch/images directory to the Oracle Application Express images directory setup for the APEX Listener. For some configurations, you will need to create a new i.war file from the patch/images directory and deploy it. For more information, see Oracle APEX Listener Installation Guide.

4.2 Start Oracle Application Express

If your configuration includes Oracle HTTP Server and mod_plsql, you need to start Oracle HTTP Server. See "Start Oracle HTTP Server".

Alternatively, if your configuration includes the embedded PL/SQL gateway, you need to enable the Oracle XML DB HTTP Server. See "Enable Oracle XML DB HTTP Server".

4.2.1 Start Oracle HTTP Server

To start Oracle HTTP Server shipped with Oracle Database 10g release 1 (10.1) or later, enter commands using the following syntax, where ORACLE_BASE is the path to the Oracle base directory:

ORACLE_BASE\ORACLE_HTTPSERVER_HOME\opmn\bin\opmnctl startproc ias-component=HTTP_Server

Note that if the Oracle HTTP Server is listening on a port less than 1024, then these commands must be executed as a privileged user (such as root).

4.2.2 Enable Oracle XML DB HTTP Server

Once disabled, you enable embedded PL/SQL gateway by assigning a port number.

To enable Oracle XML DB HTTP server:

  1. Start SQL*Plus and connect to the database where Oracle Application Express is installed as SYS. For example:

    • Windows:

      DRIVE_LETTER:\> sqlplus /nolog
      SQL> SQL> CONNECT SYS as SYSDBA
      Enter password: SYS_password 
      
    • UNIX and Linux:

      $ sqlplus /nolog
      SQL> SQL> CONNECT SYS as SYSDBA
      Enter password: SYS_password 
      
  2. Run the following statements:

    EXEC DBMS_XDB.SETHTTPPORT(port);
    COMMIT;
    

    For example:

    EXEC DBMS_XDB.SETHTTPPORT(8080);
    COMMIT;
    

Note:

Port numbers less than 1024 are reserved for use by privileged processes on many operating systems. To enable the XML DB HTTP listener on a port less than 1024, such as 80, review the following documentation:
  • "Using Protocols to Access the Repository" and "Using HTTP(S) on Nonstandard Ports" in Oracle XML DB Developer's Guide.

  • "Protocol Address Configuration" and "Port Number Limitations" in Oracle Database Net Services Reference.

4.3 About Patching Oracle Application Express After Translating Languages

It is safe to apply the Oracle Application Express 4.0.1.00.03 patch set repeatedly to an Application Express 4.0.1 instance. If you load additional translated versions of Oracle Application Express after applying this patch, you should apply the entire patch set again.

5 Fixed Bugs

The following table is a list of the bugs fixed with in this patch set.

Table 1 Bugs Fixed in the Oracle Application Express Patch Set

Bug Number Description

9707701

Icon view and report view of interactive reports not saved across logins

9710000

Application Builder has display issues when using Internet Explorer in Asian languages

9740087

Plug-in SQL statements do not accept alias names with spaces

9798786

Display only items have no values when validation error occurs

9813824

Schema password is enabled when importing a workspace if Re-use Existing Schema is set to Yes.

9818237

ORA-01403 error occurs in View Table Defaults page (4000:391)

9827853

In a Forms migration, buttons on database block cannot be excluded from conversion

9829237

Shared Components, Report Layout cannot download RTF files

9831178

If Provisioning Status is manual, a request for workspace results in ORA-06502 error

9836178

Certain list templates are not displaying properly in all themes

9836577

ORA-20001 error displays in Chart wizard after using color picker

9838291

List with Wizard Progress template not working in some themes

9840005

Item-level Help for plug-in attributes handled inconsistently compared to other Help text

9840114

Blank page on Forms region. SQL query is cancelled on 4000:4700

9840354

Data Table 1194.22(H) - Websheet page section with reports have incorrect cells

9840617

Data Table 1194.22(A) - Websheet data page section has missing table summary

9840657

Forms 1194.22(N) - Websheet data page section search field missing label and title

9845818

ORA-01722 error in Workspace Administration page when running in German

9846125

Timeout and slow performance when displaying Workspace Administration home page

9848562

Updating Web Service process type results in ORA-12899 error

9849348

Flash chart grid spacing major and minor interval settings not working

9855142

Error when creating workspace with database user with no privileges

9855165

Incorrect results when viewing session state from Developer toolbar

9861439

Gantt chart Date Format popup not working on Chart Attributes page

9864659

Map data not positoned correctly when NLS_NUMERIC_CHARACTERS separated with a period (.)

9865653

Range chart decimal place attribute not reflected in generated chart

9868860

Flash chart 5 Asynchronous update not working

9870754

Disabled text item acting as enabled in Internet Explorer 7

9874217

When viewing results, Edit Script not working

9878329

LOV with leading return raises the error PLS-00428: an INTO clause is expected in this SELECT statement

9878336

Page item of type Display Only is not editable if width is set to 0

9879001

jQuery based datepicker does not accept time 00:00 to 00:59 AM

9879160

Report not updated when using the pagination row range LOV in Oracle Application Express release 4.0

9879227

After upgrading to Oracle Application Express release 4.0, the following error displays: ORA-01403: No data found

9880291

Reports using built-in report templates show column headings off by one

9880880

Chart type not set correctly when adding new chart series to a Flash 5 chart

9881466

Item settings do not display when running in French or Italian

9884767

ORA-20091: Invalid application ID error when copying application to ID 10201

9884858

Installation should exit when database version is earlier than Oracle Database 10gR2 (10.2.0.3) and not Oracle Database Express Edition (XE)

9885538

Simple page reload on a tabular form page shifts values up

9886194

ORA-06502 error in top applications region after switching Application Builder language

9889383

Interactive Report - When the maximum number of records is set to less than 10,000, need to show correct maximum in message to user

9890691

Computations with invalid conditions of type PL/SQL expression causes 404 errors

9892637

Enable_sso.sql script references wrong Oracle Application Express schema

9892710

Interactive Report - Maximum rows per page not being respected

9893260

APP_IMAGES and WORKSPACE_IMAGES used in tree region must be preceded by host URL

9893300

ORA-20505 error displays when changing Feedback Synchronization Source Identifier

9893380

Tabular form add row functionality does not work with old report templates

9893459

After upgrade, columns posted to the G_FXXX ARRAYS are in a different order

9893492

When using old themes with interactive reports, column search drop down does not display correctly in Internet Explorer

9893564

Tabular forms no longer show a "Data Not Found" message

9893744

Interactive reports and Websheet Data Grids inconsistently display loading GIF

9898213

Tree view of APEX Views on page 4000:905 not displaying full tree

9898269

Invalid File Browse page item created when creating form with UI Dfaults

9898931

Flash Chart 5 region source overwritten on each chart run

9902316

Map using custom XML and Series type map missing defined_map_region tags

9902700

Advisor always reports an error for LDAP Username Edit Function

9905239

Buttons not displayed in region when creating RESTful Web service

9906571

Data Table 1194.22(A) - Websheet SQL Tag report has missing table summary

9907473

Cascading LOV does not refresh if parent is defaulted to first entry

9909860

Links for the top applications in dashboard regions are the same one

9910062

The file name of export feedback corrupted when contains Chinese characters

9911430

Flash 5 charts action link not working for some multi-series charts

9920762

Decimal value will not work in number field item type when using Safari

9925124

ORA-01821 error displays when querying a table across a database link

9927128

Format mask popup for interactive report columns raises ORA-01830 error

9927342

Quick pick value is not substituted

9931875

% is not escaped by WWV_FLOW_JAVASCRIPT.ESCAPE

9932179

Select list in classic report pagination using full page refresh does not work

9936596

Clicking on a calendar day in monthly view throws JavaScript error

9937468

Theme 15 contains label template with missing label tag

9941099

Administration dropdown menu in Application Builder links to invalid page for dashboards

9941116

The Copy Interactive Report region page does not substitute "page items to submit" page IDs

9941406

Rerfesh will not work if dynamic action contains more than one refresh action

9945462

Flash 5 chart series returning NULL data displays as zero

9946654

When user's database runs in character semantics, validate Validate Websheet Database Objects displays all columns as invalid

9946779

Tree region with depth greater than 9 levels not displayed

9947356

Check for update shows a warning if HTTPS and Internet Explorer are used

9947403

In Application Builder, the selection of application loses context of report view and detail view

9947941

When editing list of values, Help regions at bottom of page should be removed

9950138

Dynamic action does not work with jQuery date picker

9950531

Map data points not displayed correctly for world without greenland map

9950809

PPR of a classic report causes loss of template row highlighting

9953698

ORA-6502 error displays if Text Field with Autocomplete has too many values

9954983

Copy Page wizard does not expand right when large branches hiding buttons

9955012

Theme 2 for missing references for Previous and Next

9958420

When using Safari And Chrome Web browsers, Query Builder is missing scroll bars for tables with many columns

9958916

Internet Explorer does not display semi-transparent images properly

9959887

Create new text section branch does not clear cache

9962329

Tabular form hidden columns not included when placed in conditional columns

9964868

Create Application Wizard regions not wide enough on page 4000:3001

9967910

Flash 5 chart top margin setting has no effect on bar and column charts

9968494

Annotations are garbled after enabling public access in Websheet

9968821

Editing a template definition is slow in Shared Components

9971444

Refreshing a Text Field with Autocomplete does not work

10009125

Unable to view columns from Application Express views in Data Dictionary reports

10009447

Tabular form validation raises ORA-1403 error if Checked Column is not enterable

10009470

Tabular Form Wizard should create validations for non-updateable columns

10025450

APEX_UTIL.FIND_SECURITY_GROUP_ID returns 0 in most cases

6 Documentation Accessibility

Our goal is to make Oracle products, services, and supporting documentation accessible to all users, including users that are disabled. To that end, our documentation includes features that make information available to users of assistive technology. This documentation is available in HTML format, and contains markup to facilitate access by the disabled community. Accessibility standards will continue to evolve over time, and Oracle is actively engaged with other market-leading technology vendors to address technical obstacles so that our documentation can be accessible to all of our customers. For more information, visit the Oracle Accessibility Program Web site at http://www.oracle.com/accessibility/.

Accessibility of Code Examples in Documentation

Screen readers may not always correctly read the code examples in this document. The conventions for writing code require that closing braces should appear on an otherwise empty line; however, some screen readers may not always read a line of text that consists solely of a bracket or brace.

Accessibility of Links to External Web Sites in Documentation

This documentation may contain links to Web sites of other companies or organizations that Oracle does not own or control. Oracle neither evaluates nor makes any representations regarding the accessibility of these Web sites.

Access to Oracle Support

Oracle customers have access to electronic support through My Oracle Support. For information, visit http://www.oracle.com/support/contact.html or visit http://www.oracle.com/accessibility/support.html if you are hearing impaired.


Oracle Application Express Patch Set Notes, Release 4.0.1.00.03

Copyright © 2010, Oracle and/or its affiliates. All rights reserved.

This software and related documentation are provided under a license agreement containing restrictions on use and disclosure and are protected by intellectual property laws. Except as expressly permitted in your license agreement or allowed by law, you may not use, copy, reproduce, translate, broadcast, modify, license, transmit, distribute, exhibit, perform, publish, or display any part, in any form, or by any means. Reverse engineering, disassembly, or decompilation of this software, unless required by law for interoperability, is prohibited.

The information contained herein is subject to change without notice and is not warranted to be error-free. If you find any errors, please report them to us in writing.

If this software or related documentation is delivered to the U.S. Government or anyone licensing it on behalf of the U.S. Government, the following notice is applicable:

U.S. GOVERNMENT RIGHTS Programs, software, databases, and related documentation and technical data delivered to U.S. Government customers are "commercial computer software" or "commercial technical data" pursuant to the applicable Federal Acquisition Regulation and agency-specific supplemental regulations. As such, the use, duplication, disclosure, modification, and adaptation shall be subject to the restrictions and license terms set forth in the applicable Government contract, and, to the extent applicable by the terms of the Government contract, the additional rights set forth in FAR 52.227-19, Commercial Computer Software License (December 2007). Oracle USA, Inc., 500 Oracle Parkway, Redwood City, CA 94065.

This software is developed for general use in a variety of information management applications. It is not developed or intended for use in any inherently dangerous applications, including applications which may create a risk of personal injury. If you use this software in dangerous applications, then you shall be responsible to take all appropriate fail-safe, backup, redundancy, and other measures to ensure the safe use of this software. Oracle Corporation and its affiliates disclaim any liability for any damages caused by use of this software in dangerous applications.

Oracle is a registered trademark of Oracle Corporation and/or its affiliates. Other names may be trademarks of their respective owners.

This software and documentation may provide access to or information on content, products, and services from third parties. Oracle Corporation and its affiliates are not responsible for and expressly disclaim all warranties of any kind with respect to third-party content, products, and services. Oracle Corporation and its affiliates will not be responsible for any loss, costs, or damages incurred due to your access to or use of third-party content, products, or services.

false ,,,,,,,,,,,,,,,,