Skip Headers
Oracle® Application Express Patch Set Notes
Release 5.0.4.00.12
E74949-01
 

 

Oracle® Application Express

Patch Set Notes

Release 5.0.4.00.12

E74949-01

July 2016

These patch set notes accompany the Oracle Application Express 5.0.4.00.12 patch set. The Oracle Application Express 5.0.4.00.12 patch set is a cumulative patch.

1 Patch Set Overview

Patch sets are a mechanism for delivering fully tested and integrated product fixes. Patch sets provide bug fixes only; they typically 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 5.0.4.00.12 patch set can be applied to Oracle Application Express release 5.0 or later. 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 5.0 is supported on Oracle Database 11g Release 11.1.0.7 or later, including Enterprise Edition and Express Edition (Oracle Database XE).

Consider the following rules when determining whether to install this patch set, or install the entire Oracle Application Express 5.0.4 release from Oracle Technology Network (OTN):

  1. If you have Oracle Application Express release 5.0 or later installed, download the Oracle Application Express 5.0.4 patch set and apply it.

  2. If you have Oracle Application Express release 4.2.6 or earlier installed (including Oracle HTML DB release 1.5), download and install the entire Oracle Application Express 5.0.4 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 5.0.4 release from the Oracle Technology Network (OTN).

2 Pre-Installation Tasks

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

2.1 Identifying 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 or apxpatch_con.sql (for CDBs) installation script.

2.2 Downloading and Extracting 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 p23192730_504_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 p23192730_504_Generic.zip file

    • UNIX or Linux - Enter the following command:

      $ unzip p23192730_504_Generic.zip
      

2.3 Optionally Backing Up the Oracle Database

The Application Express engine is a collection of tables and packages that reside wholly within the Oracle Database user accounts APEX_050000 and FLOWS_FILES. This patch set updates the underlying tables and packages within the APEX_050000 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 Preventing 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. This section describes how to prevent access to Oracle Application Express if your configuration includes Oracle REST Data Services (formerly Oracle Application Express Listener), embedded PL/SQL gateway, or Oracle HTTP Server and mod_plsql.

2.4.1 Stopping Oracle REST Data Services

To learn more about stopping the Oracle REST Data Services server (formerly Oracle Application Express Listener), see Oracle REST Data Services Installation and Configuration Guide.

2.4.2 About Disabling the Embedded PL/SQL Gateway

If your configuration includes the embedded PL/SQL gateway, you need to disable HTTP on the Oracle XML DB Protocol Server. The embedded PL/SQL gateway runs on the Oracle XML DB Protocol Server in the Oracle database. To disable the embedded PL/SQL gateway, first verify the port number and then change the port number to 0.

2.4.2.1 Verifying the Port Assigned to Oracle XML DB Protocol Server

To verify the port number assigned to HTTP on the Oracle XML DB Protocol Server:

  1. Start SQL*Plus and connect to the database where Oracle Application Express is installed as SYS. 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
  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 Protocol Server is disabled.

2.4.2.2 Disabling HTTP on the Oracle XML DB Protocol Server

To disable HTTP on the Oracle XML DB Protocol Server:

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

    • Windows:

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

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

    EXEC DBMS_XDB.SETHTTPPORT(0);
    COMMIT;
    

2.4.3 Stopping Oracle HTTP Server

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


Tip:

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.3.1 Stopping Oracle HTTP Server 12c

To stop Oracle HTTP Server 12c, enter commands using the following syntax, where DOMAIN_HOME is the path to the Oracle HTTP Server domain:

  • Windows:

    %DOMAIN_HOME%\bin\stopComponent.cmd componentName
    
  • Linux:

    $DOMAIN_HOME/bin/stopComponent.sh componentName
    

In a default installation, componentName is ohs1 but may have been changed when running the Oracle HTTP Server Configuration Wizard.

2.4.3.2 Stopping Oracle HTTP Server Included with Oracle Database 10g Release 1

To stop Oracle HTTP Server included with Oracle Database 10g Release 1 (10.1), enter commands using the following syntax:

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

In the previous example, ORACLE_BASE is the path to the Oracle base directory.

3 Installing the Patch Set

To install the patch set:

  1. Set your current directory to the top-level "patch" directory where you unzipped the p23192730_504_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.

  5. Follow the instructions in the next section, "Post-Installation Tasks".

4 Post-Installation Tasks

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

4.1 Updating 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 Using Oracle REST Data Services

If you are using the Oracle REST Data Services (formerly Oracle Application Express Listener), you need to create a Web Archive for Oracle Application Express images. For more information, see the Oracle WebLogic Server and Glassfish Server discussions, "Creating the Web Archive for Oracle Application Express Images" and the Apache Tomcat discussion, "Configuring Oracle Application Express Images" in Oracle REST Data Services Installation and Configuration Guide.

If you are running Oracle REST Data Services in standalone server mode, locate the path on the file system that contains the existing Oracle Application Express images and replace it with the images directory from p23192730_504_Generic.zip.

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 a SQL script 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 p23192730_504_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 p23192730_504_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 Running Oracle HTTP Server

To update the images directory:

  1. Locate the images directory on the file system by reviewing the following files for the text alias /i/:

    • Oracle HTTP Server 11g Release 1 or Oracle HTTP Server 12c - See the marvel.conf or dads.conf files.

    • Oracle Application Server 10g - See the marvel.conf or dads.conf files.

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

  3. Depending upon your environment, run the following commands:

    • Windows systems - Run a command from a command prompt similar to the following example:

      xcopy /E /I patch\images ORACLE_HTTPSERVER_HOME\Apache\Apache\images
      
    • UNIX or Linux based systems - Run a command similar to the following example:

      cp -rf patch/images ORACLE_HTTPSERVER_HOME/Apache/Apache
      

    In the previous 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.2 Starting Oracle Application Express

This section describes how to start Oracle Application Express if your configuration includes Oracle REST Data Services (formerly Oracle Application Express Listener), embedded PL/SQL gateway, or Oracle HTTP Server and mod_plsql.

4.2.1 Starting Oracle REST Data Services

To learn more about starting the Oracle REST Data Services server (formerly Oracle Application Express Listener), see Oracle REST Data Services Installation and Configuration Guide.

4.2.2 Enabling the Embedded PL/SQL Gateway

Once disabled, you enable the embedded PL/SQL gateway by assigning a port number to the Oracle XML DB Protocol Server. Oracle recommends assigning the same port number that was previously assigned to the embedded PL/SQL gateway to ensure that bookmarks created by developers and end users are still valid.

To assign a port number to Oracle XML DB Protocol Server:

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

    • Windows:

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

      $ sqlplus /nolog
      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 Oracle XML DB Protocol Server on a port less than 1024, such as 80, see "Repository Access Using Protocols" in Oracle XML DB Developer's Guide and "Protocol Address Configuration" and "Port Number Limitations" in Oracle Database Net Services Reference

4.2.3 Starting Oracle HTTP Server

This section describes how to start Oracle HTTP Server.


Tip:

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.3.1 Starting Oracle HTTP Server 12c

To start Oracle HTTP Server 12c, enter commands using the following syntax, where DOMAIN_HOME is the path to the Oracle HTTP Server domain:

  • Windows:

    %DOMAIN_HOME%\bin\startComponent.cmd componentName
    
  • Linux:

    $DOMAIN_HOME/bin/startComponent.sh componentName
    

In a default installation, componentName is ohs1 but may have been changed when running the Oracle HTTP Server Configuration Wizard.

4.2.3.2 Starting Oracle HTTP Server with Oracle Database 10g Release 1

To start Oracle HTTP Server shipped with Oracle Database 10g Release 1 (10.1), enter commands using the following syntax:

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

In the previous example, ORACLE_BASE is the path to the Oracle base directory.

4.3 Adding New Translation Languages After Patching Oracle Application Express

For multi-lingual applications, the translated versions of Oracle Application Express implemented before patching are automatically patched when the core language is patched. However, if you wish to install a new translated version after patching, Oracle recommends downloading "Oracle Application Express 5.0.4 - All languages" from Oracle Technology Network. If you use the load_lang.sql script from an Oracle Application Express software distribution prior to Oracle Application Express release 5.0.4, you will need to rerun this patch to upgrade the new language to the current version.

5 Fixed Bugs

The Oracle Application Express 5.0.4.00.12 patch set is a cumulative patch. This patch set includes release 5.0.1.00.06 and additional product fixes. The following sections list bugs fixed in the Oracle Application Express 5.0.4.00.12, 5.0.3.00.03, 5.0.2.00.07 and 5.0.1.00.06 patch sets.

5.1 Bugs Fixed in the 5.0.4.00.12 Patch Set

Table 1 lists bugs fixed in the Oracle Application Express 5.0.4.00.12 patch set.

Table 1 Bugs Fixed in the Oracle Application Express 5.0.4.00.12 Patch Set

Bug Number Description

21437474

Intermittent bug with Oracle Application Express SQL Workshop uploads - random errors

21517239

Reopen cancelled modal dialog in Internet Explorer 11 results in disabled input fields

22110421

Editing a workspace end user failed with internal error

22493656

Upgrading Oracle Application Express 4.2 to 5.0.3 throws ORA-20001: Compile Error: "Package Body"

22532860

APEX_JSON: XML to JSON conversion treats 0 as string and 0123 as number

23249353

Classic report escaping: "Display As" for substitution taken from wrong column

23261092

SSO: // in redirect path when SSO success URL registered for different host


5.2 Bugs Fixed in the 5.0.3.00.03 Patch Set

Table 2 lists bugs fixed in the Oracle Application Express 5.0.3.00.03 patch set.

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

Bug Number Description

22073489

Missing privileges after running apxdevrm.sql and then apxdvins.sql

22076932

HTTP response headers attributes not contained in export file

22084777

X-APEX-ERROR response header should be escaped

22097984

Pivot sort raises ORA-01403 if more than one row column used as sort

22105151

Runtime only installation does not have APEX_VIEWS granted to PUBLIC

22156670

ERR-7620 raised for workspaces where Status is NULL

22160678

Unique constraint WWV_FLOW_WS_PIVOT_IDX3 error

22173641

APEX_PLUGIN_UTIL.GET_DATA raises ORA-06502 for CLOB or LONG VARCHAR2

22202236

Interactive report subscription notification fails if report has authorizations

22202467

Copy Page Wizard: Rendering of Navigation Menu page (4000:305) is slow

22301102

Redirect Loop if Rejoin Sessions Enabled for All, Logged In and On Public Page


5.3 Bugs Fixed in the 5.0.2.00.07 Patch Set

Table 3 lists bugs fixed in the Oracle Application Express 5.0.2.00.07 patch set.

Table 3 Bugs Fixed in the Oracle Application Express 5.0.2.00.07 Patch Set

Bug Number Description

18593436

LAYOUT.T_ITEM_EXCEEDS_MAX ERROR on post

20220385

Unable to generate DDL in SQL Workshop

21162720

Survey Builder scheduled job EBA_SB_SURVEY_JOB not being created properly

21392729

Internal application interactive report subscription sends W/O attachment and error

21410037

HTTP_ERROR_STATUS_ON_ERROR_PAGE_ENABLED is ignored

21434612

Websheet SSO error: Error Processing Authentication

21435234

Plug-Ins: Region columns not found for translated applications

21435330

Notification message checksum content error on login when time zone detection

21441233

Database application SSO internal error if application has cleanup Pl/SQL Code

21445226

Column CSS classes not available in translated version

21463521

Images directory not up-to-date warning after applying 5.0.1 patch set

21464312

ORA-02091: transaction rolled back when importing application in SQL*Plus

21464648

Refresh theme deletes display points in page and region templates

21469957

Cannot perform a DDL Commit error due to LOV query with binds in classic report

21473086

Live Poll authenticated polls do not work

21479385

APEX_WEB_SERVICE.MAKE_REST_REQUEST results in ORA-06502 if P_BODY pass as Null

21488152

Error when creating select list with named LOV using Create Item Wizard

21494010

P-Track Timeline region on page 10 throws result of String Concatenation Too Long

21507110

Error when importing workspace export containing user profile images

21516469

Websheet tree folder icons are not visible

21531843

apxremov.sql does not remove all public synonyms

21536514

Classic report (based on function) raises error in Page Designer

21537995

Static Images broken for old workspaces when using Oracle Application Express 5.0 And Oracle REST Data Services (ORDS) 3

21538532

Core.css in Application Express UI surpasses Microsoft Internet Explorer's Selector Limit

21546558

Page Designer allows to define parent region to point to it's own sub region

21548833

Ora-01031 when importing REStful Service into Oracle Application Express runtime installation

21567249

Patch Set install should purge Page/Region Cache to avoid file caching issues

21574013

Unique constraint violation error when importing apps containing translations

21610534

Preferences in the User Name displays an empty field for default schema

21610816

Lost schema and cannot delete user after created user through Package App Entry

21611929

Install package Websheet causes identifier SYS.DBMS_SESSION must be declared

21618837

Image Prefix Specified For An Application Is Cleared If Application Is Modified

21621365

Error when trying to import workspace in Instance Administration

21628965

Using Microsoft Internet Explorer 11 Page Designer cannot use Property Editor scroll bar

21679505

Data Loading - Transformation Rules report shows 15 rows max without pagination

21763773

Workspace export code should not use SQL Collect function

21770724

Upgrading Data Reporter to newer version throws error

21789314

Remove redundant public synonyms for Anychart 3 objects

21812064

ORACLE_APEX scheduler jobs from prior version persist after upgrade

21817814

Ora-01467 (Sort Key Too Long) when using Create Application Wizard With Master/Detail

21819913

Rows Per Page on a private saved report is not preserved upon import

21826787

Data Reporter: Whitelist error when creating interactive report

21839850

Real Player causes redirects in Application Express to start page with a changing session ID

21882582

SSO Authentication should use HTTP 302 redirect to login server

21882834

APEX_JSON: Invalid Output when combining Write(Cursor) with other writes

21886782

Unwanted encoding <BR /> in Page Views By Hour Page

21901376

ORA-06502 when calling APEX_UTIL.PREPARE_URL in classic report query

21901663

Labels/placeholders missing in Login field for Application Builder

21922914

Page Designer fails if a Date Column of an interactive report query changes to Timestamp

21945297

APEX_JSON.WRITE(NAME,SYS_REFCURSOR): Missing attribute name if nested cursors

21983878

App export error ORA-06502: PL/SQL: Numeric or value error: Raw variable length


5.4 Bugs Fixed in the 5.0.1.00.06 Patch Set

Table 4 lists bugs fixed in the Oracle Application Express 5.0.1.00.06 patch set.

Table 4 Bugs Fixed in the Oracle Application Express 5.0.1.00.06 Patch Set

Bug Number Description

14767963

Check boxes and radio groups in mobile apps have no label

16344730

Update item help for row version column (On DML Fetch And Process)

16658968

Application Express should hide report table space utilization percentage on Oracle Database Cloud

16872977

Date Picker show HTML tags in tooltip and screen reader output

17977563

Interactive Report - Icon View: Column names not substituted for some properties

18243331

Page Designer allows dynamic action on button which does not use #BUTTON_ID#

18609464

Define date format mask at interactive report column level

18629862

Cannot use computation in pivot row column nor in function column

18921174

Got ORA-06502 Error caused by Web service process without validation

20034145

Some ORA errors are not being handled by the error handling function

20107536

Use As Row Header does not work when row header column is Plain Text

20145584

Changing plug-in subscription with different internal name breaks application

20363312

Another window/tab is opened when edit data grid and added file

20364885

Application Express interactive report columns deleted when new computation column added

20394403

Invalid HTML output from Show_Help procedure

20433298

ORA-00904: 'R'.'ROWID': Invalid Identifier Error in interactive report using static LOV

20482204

Interactive report with fixed headers column widths get out of sync

20492142

Developer Toolbar issues in Internet Explorer with themes 8, 10, 13, 14, 15, 16, 18, 19, 20

20539071

ORA-00979: Not A Group By Expression raised on Application Express Active Sessions page

20554286

Page Designer: Success notifications are sometimes incorrectly hidden

20609114

Slidetooltip plug-in outputs rows with missing labels and duplicate IDs

20609989

Cursor focus on first page item fails if first item is in breadcrumb region

20611183

CSS calendar should use NLS Settings instead of WWV_FLOW.G_BROWSER_LANGUAGE

20626090

Provide list of valid default date formats on workspace user edit page

20662230

Team Development Home page has minor cropping issue at 200% zoom

20671898

RTL menu and menu bar style issues

20674579

ORA-29368 occurs when entering a non-existed resource consumer group

20692678

Page Designer > Property Editor inconsistently focusable cross-browser

20692698

Dialogs launched from menu items do not return focus to menu

20702715

No item help for Authentication Attributes In instance Administration

20713830

Open Door Authorization Login page gives JavaScript error

20717716

The navigation list name containing Chinese characters displays incorrectly

20718429

Create Classic Report is not translated after click Use First... task

20729435

Property Editor - Quick Picks sometimes fail for dependent properties

20744272

Page Designer: No text editor used for custom plug-in attributes of type Textarea

20754964

Linking To Multiple Interactive Reports On A Page Does Not Work

20755671

Theme Roller Search icon in Firefox does not have the right padding

20763423

CSV download raises 500 error if region title has HTML tags with double quotes

20765332

Sample Geolocation Showcase - Name in plug-ins

20780156

D3 line charts missing label

20780499

Duplicate labels on Tabular Form elements in Sample Database App > States

20787551

IR[Report ID]_Rowfilter URL syntax sets all interactive reports on a page

20798737

Keyboard shortcuts in sub menu widgets wrap to new line

20798740

Sample Charts application is missing D3 collapsible tree chart plug-in

20798884

Rich Text Editor icons alignments not well aligned

20799444

Disabled menu items in Universal Theme are not themerolled

20805679

Parameters in static file request should be ignored

20805943

Application deletion results in Application Not Available For Edit error

20806341

Theme Roller cannot set theme as current if theme is not themerollable

20806408

Change to a different theme in Theme Roller cuts off the header

20809628

The exported workspace file name does not display correctly in ZHS16GBk

20809777

Multibyte name is displayed in encoding when copy an existing app in ZHS16GB

20810506

In sample dynamic action packaged app - Unable to delete employee in page 18

20811612

Clicking on All Bugs link in Bug Dashboard results in logging out

20811765

Application name does not display correctly on Supporting Objects page

20812030

Calendar is not displayed completely in Date Picker when running an application

20817302

Checklist Manager: Add row button is invalid for checklist

20821612

Theme Roller does not remove vista.min.css when switching to new theme

20822429

Sample Charts: Missing jquery.flot.axislabels.js on line chart page

20826300

Unknown is not translated in Print Server value on Instance Administration page

20827635

Application Express replaces '|' With ':' when following a deep link on login

20828601

Dynamic Action On Buttons - Copy to page fails to select button

20838759

Column filter does not display any '0' values

20838980

Meeting Minutes: Error on long breadcrumbs

20839100

Changing dates in P-Track administration: Notifications throws an error

20841773

Bug Tracker packaged application: Edit bug, category missing

20842002

Bug Tracker packaged application: Clicking on Cancel button on Validate Bug Page, back to same page

20847790

Go Live Checklist: Detailedstatuslisttooltip Js error on home page

20848245

Workspace Request - Approved is not translated on Workspace Dashboard

20848475

Yes is not translated on the User Dashboard page

20860160

Cannot load > 32k spreadsheet data with copy and paste to an existing table

20874809

Developer Toolbar Quick Edit issue for some item types

20882245

ORA-6502 using APEX_Web_Service if response header value > 1024

20889405

Interactive reports incorrect headers when control break and aggregate enabled

20894725

Refreshing page fails after creating a trigger successfully in Object Browser

20895418

High Contrast Accessibility Mode has no effect in Builder and should be removed

20896713

High Contrast mode images not visible

20896730

Popup LOV hides the first entry when the windows gets too small

20896853

High Contrast mode border and layout issues

20896953

In High Contrast mode Developer Toolbar buttons do not show focus

20897047

In High Contrast mode many widgets have issues showing focus, selection state

20897075

In High Contrast Mode splitter is not visible

20900361

Grants Report only shows 15 rows with no pagination

20906091

Items containing SQL Or PL/SQL not using code editor

20915966

In High Contrast mode select list value not visible when select has focus

20929652

Splitter widget having issues when changing Application Builder language

20931298

Report download files are broken if database version < 11.2.0.3

20948475

Copy Page Wizard throws ORA-06502 Error on Lists and Auth Scheme steps

20950850

Interactive report pivot column link with column substitution does not work

20962689

Character Value Comparison Global attribute not used by tree region

20963834

Underscores/Descenders not visible in Theme 25

20964209

Inline select list does not display correctly in theme 42

20971291

Edit Authentication Scheme does not show all Session Not Valid attributes

20974582

APEX_JSON.PARSE errors when parsing Clobs if Oracle Database 11.2.0.3 or earlier

20979654

Error: Item ID (<Number>) Is Not An Item Defined On The Current Page

20981493

Move Application Builder specific icon classes from app_ui To apex_ui

20983185

Overwriting a script from SQL Workshop Scripts does not work

20994207

Page Designer: Creating components via Create Menu button do not show success message

20994398

Universal Theme: Value Attribute Pairs template renders incorrectly when showing Nulls

21019950

Bug Tracker packaged application: 'Fixed In Release' needs to allow null value

21024596

List Region: Rendering of Simple List ignores First template

21026665

Slow performance in Create Application Wizard

21031849

APEX_JAVASCRIPT.ADD_LIBRARY and APEX_CSS.ADD_FILE are ignoring P_Key parameter

21035588

Theme File Upload button has issues

21037987

NLS:Multibyte region name does not display correctly in ZHS16GBk

21041454

Password error in create workspace if Internal Auth Is LDAP or DB

21049605

APEX_WEB_SERVICE.MAKE_REST_REQUEST with basic authentication results in ORA-29267

21050888

Query Builder download results fails

21054557

Icon CSS classes are not copied by Copy Page/Region Wizard

21065830

Error editing static list of values in User Interface Defaults

21067090

Cannot delete Tree region where Selected Node Page Item is set

21067714

Calendar does not support multiple class names in List View

21068077

Fast Click breaks clicking on Windows 8 devices in Non-Internet Explorer browsers

21069792

Root Tree item does not show selection state

21074981

Browser text messages do not work if No NLS is used for App Language

21075026

APEX_JSON.TO_XMLTYPE fails if member names contain special characters

21075477

Adjust styles of Universal Theme Sample Application so that setting the style to Vista Looks better

21077208

Some regions do not render when "Show All" is hidden on Region Display Selector

21083688

Fast click on mobile breaks links with inline JavaScript blocks

21084214

Clicking On Implicit labels is broken

21085518

P-Track packaged application: Action items associated to milestones not showing up

21085954

P-Track packaged application: Action item flex column not displaying correctly

21092071

Universal Theme: Modal dialogs resize height upon opening

21097562

Interactive reports: JavaScript errors when Static ID contains space

21097774

Item ID is not an item defined...when pressing Enter on history of SQL Commands

21098867

APEX_WEB_SERVICE.MAKE_REST_REQUEST incorrectly sets content-length

21105758

Icon of buttons not displayed when using Alert Region template with hide icons

21105796

Oracle Internal Theme Images Directory (/i/themes/oracle/v1) missing in Application Express 5.0

21105932

Calendar widget obscured by interactive reports headers.

21106542

Universal Theme: Interactive report font sizes larger when using standard region

21111792

Create Master Detail Wizard throws error when no master report included

21113937

Close property in Dialog attributes breaks modal page

21126773

Multibyte export file workspace name does not display correctly

21126819

ORA-06502 raised for SQL statements containing umlaut in first line

21128463

Universal Theme - Interactive report dialogs no longer show error state

21129769

Universal Theme: Pivot View in interactive report does not enable user to scroll horizontally

21140748

Current workspace name containing multibyte characters display incorrectly

21145222

ORA-01403 Error occurs when clicking the feature name On Change History page

21149046

Sample Database Application default Nav Bar implementation set to 'Classic'

21149365

Server.Plugin API gives error when Poptions is omitted

21153228

Restful Services example Empsecformat/{Empname} does not handle duplicate data

21153723

Multibyte column name does not display correctly on the Load Data Wizard

21154638

Classic report does not show loading indicator when paginating, sorting, or refreshing

21155439

APXDLIMG.SQL should execute APEX_EPG_CONFIG.SQL

21160295

The schema name does not display correctly on the Edit Table Comment View

21170435

Full calendar CSS is overriding user specified colors and classes

21176245

Return To Page is not translated on View/Edit Feedback page

21200619

High Contrast Mode select list icon not visible

21201922

Add support for mail delivery In Oracle DBaaS

21202884

Universal Theme: List templates use incorrect #Image# substitution string

21203178

Universal Theme: Font Awesome icon font is hard coded for most icons

21205578

Multibyte page name does not display correctly on page directory

21205928

The automatically generated title does not display correctly in ZH16GBK.

21207953

Unwanted refresh of parent interactive report, when child interactive report is refreshed on a page

21214555

3D mode setting not working correctly for stacked charts in Page Designer

21214580

Interactive reports: Focus should not always be set to first element

21216535

Developer Toolbar Quick Edit broken if page has an Inline dialog

21229340

ORA-01403 Error occurs when creating websheet on Websheet pages

21231504

Page Designer right-click select in tree and grid layout not working as expected

21235537

Restful Web Service Source code editor can not be enlarged

21247877

Report SQL statement containing Application Express URL wrapped by double quotes fails

21248511

Dynamic action new line at start of JavaScript expression causes problem

21255756

P-Track packaged application: Navigation menu items missing

21256226

Universal Theme: Child tree navigation label elements do not support badges

21256468

Sequence Error: APEX$_WS_SEQ when manually provisioning workspace

21256752

Unable to respond to a dialog closing when launched from a Navigation Bar item

21262507

Bug Tracker packaged application: Error on installation

21263290

Customer Tracker packaged application: Updating the Contact,Update section of customer shows session D

21263484

Report links to dialog pages are not dialog links when no items are set

21263780

Menu item based on action is not an anchor

21270343

P_CHECKSUM_TYPE should not be passed into WWV_FLOW_UTILITITES.PREPARE_URL

21270599

Interactive report links do not include checksum if no page items are specified

21271393

Feedback-Feedback Timeline: An unexpected internal application error has occurred

21272253

Universal Theme: 'G', 'Y', And other hanging characters cut off in page title

21272740

Reading dialog cancel code for translated application fails for inline validation error

21273094

ORA-06502 if authorization scheme's PL/SQL code is > 4000 bytes and contains unicode

21278635

Ajax error when generating calendar

21281624

Universal Theme: Long Treenav labels do not wrap well

21286064

NLS: The User Interfaces do not display correctly in ZHS16GBk/JA16SJIS

21291696

Calendar does not display data in the first cell

21292450

P-Track packaged application: Categories badge shows incorrect number

21303648

APEX_JSON.WRITE(SYS_REFCURSOR): Inconsistent Output of Boolean values

21336551

Prompts for app substitution strings not displayed when installing supporting objects

21341835

Tree region should not be in Page Designer Gallery for mobile page

21350792

Theme subscription broken after app export / import


6 Known Issues

This section describes known issues in the Oracle Application Express 5.0.4.00.12 patch set.


Tip:

This section is current as of the writing of this document. To view the most current listing of known issues, go to the Known Issues page available off the Downloads page. See:

http://www.oracle.com/technetwork/developer-tools/apex/downloads/index.htm


6.1 Upgrading Data Reporter To a Newer Version Can Throw an Error

Attempting to upgrade (or uninstall and reinstall) some packaged applications results in an error in some configurations. This behavior has been noted with Data Reporter, P-Track, Application Standards Tracker, and Sample Reporting.

This issue is tracked with Oracle bug 21770724.

7 Other Issues and Changes

This section describes other issues and changes included in the Oracle Application Express 5.0.4.00.12 patch set.

7.1 Universal Theme Changes

Universal Theme changes include:

  • Tree Navigation:

    • Child/nested now support badges in labels.

    • Overly-long labels will now be truncated automatically without stretching the tree.

  • Mobile:

    • Microsoft Windows 8 Touchscreens and laptop hybrids no longer suffer from the "tap-then-click" event.

    • Fast-click adjusted to work with normal links and buttons.

  • Theme Roller:

    • Switching between Vista and Vita themes now adjusts the offset between the top navigation bar and the page.

    • Custom styles of Universal Theme Sample Application are now overridden by the Theme Roller styles.

  • Interactive Reports:

    • Font sizes are normal when using standard region.

    • Paginated reports overflow properly when maximized.

    • Pivot View in interactive reports regions now enables users to scroll horizontally.

    • Clear filter/setting button has the right padding in Vista theme style.

    • Horizontally scrolling interactive reports regions and classic reports is now significantly faster on mobile devices.

  • Misc Javascript:

    • Elements in the Hero Region are now focusable on page load.

  • Misc CSS:

    • AVP-List renders properly when null values are returned for any of its rows.

    • Date picker is placed on top of other elements.

    • Enabled contrast for disabled menu items.

    • Removed Font Awesome dependency in Universal Theme.

    • Increased line-height for page titles so 'g', 'y' and other lower characters are not truncated.

    • Icon color in Nav Bar menu now contrasts correctly with its background.

    • Select lists now displays as expected at larger sizes.

  • General Templates Additions:

    • Timeline for report regions.

  • Universal Theme Sample Application Templates additions:

    • Substitution string examples for reports and lists.

    • Template Option, Template Option Examples for Buttons.

    • Migration Guide - Transitioning to Universal Theme application explains the advantages of the Universal Theme and how to switch to it:

      https://apex.oracle.com/ut

7.2 Updated Packaged Applications

Oracle Application Express release 5.0.2 includes updates for the following packaged applications: Live Poll, P-Track, Data Reporter, Standards Tracker, and Sample Reporting. To take advantage of these updates, install the patch set and then upgrade the packaged application. Table 5 lists bugs related to these updates.

Table 5 Fixed Bugs Related to Updated Packaged Applications

Bug Number Description

21473086

Live Poll Authenticated Polls Do Not Work (Live Poll)

21494010

P-Track Timeline Region On Page 10 Throws Result Of String Concatenation Too Long (P-Track)


8 Documentation Accessibility

For information about Oracle's commitment to accessibility, visit the Oracle Accessibility Program website at http://www.oracle.com/pls/topic/lookup?ctx=acc&id=docacc.

Access to Oracle Support

Oracle customers that have purchased support have access to electronic support through My Oracle Support. For information, visit http://www.oracle.com/pls/topic/lookup?ctx=acc&id=info or visit http://www.oracle.com/pls/topic/lookup?ctx=acc&id=trs if you are hearing impaired.


Oracle Application Express Patch Set Notes, Release 5.0.4.00.12

E74949-01

Copyright © 2016, 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 is software or related documentation that is delivered to the U.S. Government or anyone licensing it on behalf of the U.S. Government, then the following notice is applicable:

U.S. GOVERNMENT END USERS: Oracle programs, including any operating system, integrated software, any programs installed on the hardware, and/or documentation, delivered to U.S. Government end users are "commercial computer software" pursuant to the applicable Federal Acquisition Regulation and agency-specific supplemental regulations. As such, use, duplication, disclosure, modification, and adaptation of the programs, including any operating system, integrated software, any programs installed on the hardware, and/or documentation, shall be subject to license terms and license restrictions applicable to the programs. No other rights are granted to the U.S. Government.

This software or hardware 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 that may create a risk of personal injury. If you use this software or hardware in dangerous applications, then you shall be responsible to take all appropriate fail-safe, backup, redundancy, and other measures to ensure its safe use. Oracle Corporation and its affiliates disclaim any liability for any damages caused by use of this software or hardware in dangerous applications.

Oracle and Java are registered trademarks of Oracle and/or its affiliates. Other names may be trademarks of their respective owners.

Intel and Intel Xeon are trademarks or registered trademarks of Intel Corporation. All SPARC trademarks are used under license and are trademarks or registered trademarks of SPARC International, Inc. AMD, Opteron, the AMD logo, and the AMD Opteron logo are trademarks or registered trademarks of Advanced Micro Devices. UNIX is a registered trademark of The Open Group.

This software or hardware and documentation may provide access to or information about 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 unless otherwise set forth in an applicable agreement between you and Oracle. 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, except as set forth in an applicable agreement between you and Oracle.