United StatesChange Country, Oracle Worldwide Web Sites Communities I am a... I want to...
Skip Headers
Oracle® Application Express Patch Set Notes
Release 4.0.2.00.07
 
 
 

Oracle® Application Express

Patch Set Notes

Release 4.0.2.00.07

December 2010

 

These patch set notes accompany the Oracle Application Express 4.0.2.00.07 patch set. The Oracle Application Express 4.0.2.00.07 patch set is a cumulative patch. This patch set includes release 4.0.1.00.03 and additional product fixes.

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.2.00.07 patch set can be applied to Oracle Application Express release 4.0.0.00.46, 4.0.1.00.03 and 4.0.2.00.06. 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.2 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.2 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.

Topics:

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 p10173973_11202_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 p10173973_11202_GENERIC.zip file

    • UNIX or Linux - Enter the following command:

      $ unzip p10173973_11202_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 p10173973_11202_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.

Topics:

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 p10173973_11202_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 p10173973_11202_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 Using 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.2.00.07 patch set repeatedly to an Application Express 4.0.2 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 Oracle Application Express 4.0.2.00.07 patch set is a cumulative patch. This patch set includes release 4.0.1.00.03 and additional product fixes. The following sections list bugs fixed in both the Oracle Application Express 4.0.1.00.03 and 4.0.2.00.07 patch sets.

Topics:

5.1 Bugs Fixed in the 4.0.1.00.03 Patch Set

The following table lists bugs fixed in the Oracle Application Express 4.0.1.00.03 patch set.

Table 1 Bugs Fixed in the Oracle Application Express 4.0.1.00.03 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 positioned 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-06592 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 Defaults

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 drop down 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

Refresh 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

 

5.2 Bugs Fixed in the 4.0.2.00.07 Patch Set

The following table lists bugs fixed in the Oracle Application Express 4.0.2.00.07 patch set.

Table 2 Bugs Fixed in the Oracle Application Express 4.0.2.00.07 Patch Set

Bug Number Description

6360643

Missing RESTRICT_TO_USER_LIST in application export

9752881

Read only quick picks on 4000:4311 and 4000:371 should show "Always"

9855165

Incorrect results when viewing session state from Developer toolbar

10024385

Ignore case and blanks in attributes which are referencing page items

10024437

Flash 5 dial chart incorrect value displayed when value should be zero

10024919

Map attribute labels does not control visibility of labels on map

10030517

Popup LOV uses HTML Form Element attributes for anchor link

10030798

Interactive report CSV download includes extra pair of DIV tags

10037373

Unable to create forms conversion project using Internet Explorer 7 and Application Express Listener

10041505

Popup LOV search should use LIKE operator

10041816

Multi Row Delete process fails in some cases when display sequence was altered

10049423

Named report template page not displayed when called from Page Edit tree

10050404

String from other pages included in XLIFF page export

10051384

Flash 5 Gantt chart does not support 'DS' application date format

10055032

Children do not show up or are wrong in Query Builder

10055407

Theme 1 - Hide/Show region template missing float left

10057703

Cannot make 'Simple Checkbox' columns conditional

10058590

APEX_DEBUG_MESSAGE.LOG_LONG_MESSAGE incorrectly splits the message

10058669

ORA-01785 raised in sort-enabled classic reports when columns change

10062523

APEX_DEBUG_MESSAGE.REMOVE_DEBUG_BY_AGE API parameter typo

10066270

Session State Protection report shows wrong value for Item Session State Protection

10066324

Multiple tree regions on same page may result in incorrect tree data

10069374

Pressing ESCAPE key sets value to jQuery based datepicker with time

10070849

Interactive report filter with next day gives ORA-00936: Missing expression

10079075

Incorrect item layout on Create Calendar Region attributes page 4000:2006

10090373

APEX_DEBUG_MESSAGE.REMOVE_DEBUG_BY_AGE API parameters should not have NULL defaults

10090518

APEX_DEBUG_MESSAGE.REMOVE_DEBUG_BY_AGE API removes incorrect messages

10090652

APEX_DEBUG_MESSAGE.REMOVE_DEBUG_BY_APP API parameters should not have NULL default

10090699

APEX_DEBUG_MESSAGE.REMOVE_DEBUG_BY_VIEW API parameters should not have NULL defaults

10091086

Flash 5 chart multiple Y axes only applied to first series of chart

10092894

View APEX_DEBUG_MESSAGES sometimes returns incorrect EXECUTION_TIME

10092991

Debugging flag shows and saves wrong value in Edit Application Properties

10093329

APEX_DEBUG_MESSAGE.LOG_PAGE_SESSION_STATE API does not show item values

10093980

Navigation bar logout entry created with condition type CURRENT_LOOK_IS_1

10095760

ORA-20001: Error In MRU in LOV in migrated tabular, form empty

10100985

Enabling debug using ENABLE_DEBUG_MESSAGES API results in missing debug information

10103359

Interactive report hangs search string exceeds allowed character limit

10104409

Runtime installation becomes invalid when using APXDEVRM.SQL

10104883

ORA-29279 SMTP permanent error when using reporting period

10107478

Region Display Selector attribute is ignored on import for certain region types

10107616

Syntax error in SQL report results in HTTP 404

10107767

Condition type "NONE" for validation might raise error

10108363

Flash 5 Map Animation option missing from Map Attributes page

10108919

Flash 5 charts checksum only applied to Action link for last record of series

10118507

Recently created dates can show in the future when using SINCE format mask

10119451

Application export with authentication scheme using 'NOT', 'NOT' is lost on import

10121357

Interactive report: when SELECT updated, existing columns of type timestamp are refreshed

10124254

Create Application on Spreadsheet Wizard: Theme selector region too narrow

10124263

Create Application on Spreadsheet Wizard: Final page icons not properly displayed

10124268

Install application final page 'Update App' icon not proper

10126550

Region display point preview popup does not work in German

10149191

Dynamic actions: should show 'never' in Page Definition component view

10149623

Page items of type select list, check box, and radio group should allow refresh

10149957

Update text field item to number field item

10150718

APEX_INSTANCE_ADMIN.REMOVE_SAVED_REPORTS should not remove primary default report

10150816

Error on application search

10154666

Interactive report chart displays incorrect decimal separator in non-english application

10158459

Application Express Autocomplete is replacing ampersand with '&'

10158747

Unexpected behavior with interactive report filtering with multi column LOV

10162569

Search on 4000:1 includes SESSION_ID when it should not

10162590

Search on 4000:1500 includes SESSION_ID when it should not

10165864

Reader access not granted to user that logs in when running a PUBLIC Websheet

10169594

Error message does not show up when editing process and shortcuts are used

10174506

Bad region template selected on page 4000:48, ugly button wrapping issue

10177937

Interactive report row text contains filter includes filter disabled column. To learn more, see "Row Searches on Interactive Reports No Longer Search for Filter Disabled Columns"

10185693

Interactive report row filter type displays filter disabled column

10185939

Add an API in APEX_UTIL to delete interactive report subscription

10185978

Flash 5 scatter chart displaying incorrect marker in legend

10188925

Import of application with access control supporting objects throws error

10189958

Interactive report after refresh event sometimes causes processing GIF to not be hidden

10190015

NV function raises ORA-01722 if value contains group separator

10195512

User granted create any table does not show up in spreadsheet data load

10198879

Allow more than one email address in interactive report subscription

10198889

Interactive report: subscription, format masks using substitutions are not supported

10201943

Editing of page item fails if too many plug-ins are installed

10202158

Page fails to load when many dynamic actions are defined on a page

10202608

Team Development feedback, 4800:8000 does not search feedback column

10202722

Editing Master Detail page in Create Application Wizard throws ORA-20001: NO DATA FOUND

10203473

In a Oracle Database upgrade release 11.2.0.2, APXDBMIG.SQL may show errors

10203596

Change Theme Number - Wizard templates too narrow for buttons

10205497

Flash 5 line chart 'Series type' defaults to bar instead of line

10206259

Flash 5 Map Wizard displays incorrect images for North America and South America, Asia, and Oceania

10206411

Flash 5 combined chart not displaying label and tooltip information for all chart series

10206510

Classic report row highlighting function not working for all themes

10207277

List of values report, 4000:421, does not search Query column

10210711

Add new placeholder #INTERNAL_MESSAGE# to error page template

10210802

DHTML list (IMAGE) with sublist does not work

10215164

Restful Web service support does not escape values when posting

10215440

Interactive report displays LOV in filter and highlight when it is disabled

10218361

Editing filter on pseudo column in Websheet data grid displays 2 operator lists

10219253

List of values report,4000:4110, does not search Query column

10221310

Data Grid validation dialog has misleading title

10222168

Websheet data grid filtering on Tag column has inconsistencies

10223154

Data Grid Pseudo column filter and highlight information display in red when it should not

10226951

ORA-04030 encountered when displaying Flash chart in Oracle Database 11.2.0.2

10228576

Interactive report email download and subscription send attachment in database character set

10231413

APEX_ITEM.SELECT_LIST_* APIs behave incorrectly if P_SHOW_NULL = YES

10232386

Multi-series chart does not display first chart

10238450

Interactive report filter dialog raises a 404 "NO DATA FOUND" error if page is submitted

10240360

Flash 3 charts throw ORA-01403 error if color schemes looks 6 or 7 used

10244462

Confirmation page of Create Form on Web Service has buttons out of place

10247924

Dynamic action When conditions does not work with shuttle, check boxes, or select list (with enabled Multi Select)

10248011

Theme toolbar stretches after upgrading to Oracle Application Express 4.0.1 in Internet Explorer

10252335

ORA-20001: GET_BLOCK when importing page which uses a not public user authentication scheme

10254296

Access Migrations navigation region missing icons in generated applications

10254433

Default theme should be set to theme 21 in Create Application Wizard

10254660

Automatic Time Zone application with time zone at 0:00 loops forever

10262671

Flash 5 chart series type item not displayed when page loaded using tree view

10264946

ORA-44003 occurs when Set Autocommit off in SQL Commands page

10270216

ERROR ERR-1016 / ITEM_PREFERENCE (Use item containing preference)

10078661

Advisor fails with ORA-20999 Unknown Type if process type plug-in is used

10347091

Page sentry function of custom auth scheme does not work in 4.0.2.00.06

10406645

Expired Application Express password cannot be changed

 

6 Changed Behavior

This section describes changed behavior in the Oracle Application Express 4.0.2.00.07 patch set.


Tip:

This section is current as of the writing of this document. To view the most current listing of changed behavior, go to the Known Issues page available off the Downloads page. See: http://www.oracle.com/technetwork/developer-tools/apex/downloads/index.html

 

6.1 Row Searches on Interactive Reports No Longer Search for Filter Disabled Columns

Prior to the Oracle Application Express 4.0.2.00.07 patch set, row searches on interactive reports included filter disabled columns. This issue was tracked with bug 10185678 and has been fixed in this patch set. Developers can disable a column filter by deselecting the Filter check box under Allows Users To on the Column Definition as shown in the following illustration.

Description of col_def.gif follows
Description of the illustration col_def.gif

Because of this fix, users may notice different behavior when searching rows on interactive reports. To include a filter disabled column in a row search, but not display distinct values when users clicks the column heading, set the Column Filter Type to None in the List of Values region on the Report Attributes page.

Description of col_filter_type.gif follows
Description of the illustration col_filter_type.gif

To identify reports in your application that may be impacted by this bug fix, run the following query:

   SELECT c.workspace
   , c.application_id
   , c.application_name
   , r.page_id
   , r.region_name
   , c.column_alias
   , c.report_label
   FROM apex_application_page_ir_col c
   , apex_application_page_regions r
   WHERE c.allow_filtering = 'No'
   AND r.region_id = c.region_id
   ORDER BY c.workspace
   , c.application_id
   , r.page_id
   , r.region_name
   , c.column_alias;

If you want an application to have the same row search functionality as in release 4.0.1:

  1. Edit each column identified by the report above and select the Filter column attribute.

  2. Set the Column Filter Type attribute in the List of Values region to None.

7 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.2.00.07

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.

Oracle Logo
Copyright © 2010, Oracle. All rights reserved.