Oracle® Application Express

Patch Set Notes

Release 5.1.4.00.08

E84555-04

December 2017

1.1 Overview

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

About These Patch Set Notes
Pre-Installation Tasks
Installing the Patch Set
Post-Installation Tasks
Fixed Bugs
Known Issues
Other Issues and Changes
Deprecated Features
Documentation Accessibility

2.1 About These Patch Set Notes

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.1.4.00.08 patch set can be applied to Oracle Application Express release 5.1 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.1 requires Oracle Database release 11.2.0.4 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.1.4 release from Oracle Technology Network (OTN):

If you have Oracle Application Express release 5.1 or later installed, download the Oracle Application Express 5.1.4 patch set and apply it.
If you have Oracle Application Express release 5.0 or earlier installed (including Oracle HTML DB release 1.5), download and install the entire Oracle Application Express 5.1.4 release from the Oracle Technology Network (OTN).
If you do not have Oracle Application Express installed, download and install the entire Oracle Application Express 5.1.4 release from the Oracle Technology Network (OTN).

3.1 Pre-Installation Tasks

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

Identifying the Oracle Application Express Installation
Downloading and Extracting the Installation Software
Optionally Backing Up the Oracle Database
Preventing Access to Oracle Application Express

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

3.1.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:

Download the p26795231_514_Generic.zip patch set installation archive to a directory that is not the Oracle home directory or under the Oracle home directory.
Unzip and extract the installation files as follows:
- Microsoft Windows - Double-click the p26795231_514_Generic.zip file
- UNIX or Linux - Enter the following command:
```
$ unzip p26795231_514_Generic.zip
```

3.1.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_050100 and FLOWS_FILES. This patch set updates the underlying tables and packages within the APEX_050100 account. If your installation fails, you will not be able to rollback the patch set installation process. After a patch set is installed, there is no way to remove it. Therefore, Oracle recommends that you perform a complete backup of your Oracle instance before you install the patch set.

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.

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

Stopping Oracle REST Data Services
Disabling the Embedded PL/SQL Gateway
Stopping Oracle HTTP Server

3.1.4.1 Stopping Oracle REST Data Services

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

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

3.1.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:

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

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.

3.1.4.2.2 Disabling HTTP on the Oracle XML DB Protocol Server

To disable HTTP on the Oracle XML DB Protocol Server:

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

Run the following statements:
```
EXEC DBMS_XDB.SETHTTPPORT(0);
COMMIT;
```

3.1.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).

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

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

4.1 Installing the Patch Set

To install the patch set:

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

Start SQL*Plus and connect to the database where Oracle Application Express is installed as SYS specifying the SYSDBA role. 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

Run the apxpatch.sql (or apxpatch_con.sql for CDBs) installation script. For example:
@apxpatch.sql
Review the log file apxpatch.log for any errors.
Follow the instructions in the next section, "Post-Installation Tasks."

5.1 Post-Installation Tasks

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

Updating the Images Directory
Starting Oracle Application Express
Adding New Translation Languages After Patching Oracle Application Express

5.1.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. The exact procedure varies depending upon your Web listener.

Updating the Images Directory When Using Oracle REST Data Services
Updating the Images Directory When Running the Embedded PL/SQL Gateway
Updating the Images Directory When Running Oracle HTTP Server

5.1.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 appropriate "Configuring Oracle Application Express Images" discussion for Oracle WebLogic Server, Glassfish Server, or Apache Tomcat in REST Data Services Installation, Configuration, and Development 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 p26795231_514_Generic.zip.

5.1.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:

Set your current directory to the top-level patch directory where you unzipped the p26795231_514_Generic.zip file.
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
```
Run apxldimg.sql passing the file system path to the patch directory where the p26795231_514_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
```

5.1.1.3 Updating the Images Directory When Running Oracle HTTP Server

To update the images directory:

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.
When you locate the images directory path, copy it to the existing ORACLE_HTTPSERVER_HOME home.
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.

5.1.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. The exact procedure varies depending upon your Web listener.

Starting Oracle REST Data Services
Enabling the Embedded PL/SQL Gateway
Starting Oracle HTTP Server

5.1.2.1 Starting Oracle REST Data Services

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

5.1.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:

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

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 Addresses" and "Port Number Limitations" in Oracle Database Net Services Reference

5.1.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).

Starting Oracle HTTP Server 12c
Starting Oracle HTTP Server with Oracle Database 10g Release 1

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

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

5.2 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.1.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.1.4, you will need to rerun this patch to upgrade the new language to the current version.

6.1 Fixed Bugs

The Oracle Application Express 5.1.4.00.08 patch set is a cumulative patch. The following section list bugs fixed in this patch set.

Fixed Bugs in 5.1.4
Fixed Bugs in 5.1.3
Fixed Bugs in 5.1.2
Fixed Bugs in 5.1.1

See Also:

"Known Issues"

6.1.1 Fixed Bugs in 5.1.4

The following tables list bugs fixed in the Oracle Application Express the 5.1.4.00.08 patch set.

Fixed Bugs in 5.1.4 — Interactive Grid

Table - Interactive Grid Bugs Fixed in the 5.1.4 Patch Set

Bug Number	Description
25974131	Interactive Grid: No data found error on save if source contains `WHERE` clause
26185831	Interactive Grid: Japanese column name causes session state protection violation
26199331	Interactive Grid: `ORA-06502`: When report metadata exceeds a certain limit

Fixed Bugs in 5.1.4 — Packaged Applications

Table - Fixed Bugs Related to Updated Packaged Applications in the 5.1.4 Patch Set

Bug Number	Description
22137819	P-Track: Search results links to Project page instead of Action Item
24753922	P-Track: Error displayed when adding more than one Action Item to Milestone
25677911	Sample Projects: Cannot create task
26405424	Incident Tracking: Cannot cancel 'Create Notification' dialog
26427454	Incident Tracking: Changes via 'Add Update' not refreshing parent report
26615182	P-Track: Link on Action Items card not working correctly
26619953	P-Track: Calculation of 'Past Due' for milestones and Action Items is incorrect
26645009	P-Track: Sender of report emails is incorrectly defaulting to the recipient
26671455	Script Planner: Setting of manage scripts not retained when application upgraded
26798190	P-Track: Status color of Action Item is inconsistent on milestone page
26828515	P-Track: Adding Action Item should not auto-populate the 'due date' attribute
26910177	P-Track: Add support for definition of custom link to appear in help dialog
26929359	P-Track: Action Item filter is not working
27111567	P-Track: No issue category in Issues report (page 22)
27111580	P-Track: Issues report project ID link not working (page 22)
27137760	P-Track: Status and summary email preferences are not displaying
27149490	P-Track: Error occurs when we click on any project on home page
27149571	P-Track: Unable to create project

Fixed Bugs in 5.1.4 — Other

Table - Other Bugs Fixed in the 5.1.4 Patch Set

Bug Number	Description
26526885	Interactive report date filters are incorrect when packaged app uses SSO authentication
26794433	`APEX_JSON.WRITE(XSLT):` " " followed by 0-leading digits treated as number
26812410	Interactive Report: Column header filter LOV does not respect row text search criteria
26839274	Workspace import fails if it contains REST service definition
26840384	Error accessing `APEX_UI_DEFAULT_UPDATE`
26920217	JET Chart: Datetime x-axis information not densified
26940266	JET Chart: Links defined for charts require double-click
27020227	`APEX.SESSION_STATE` error occurs if indention(new lines) exists in data
27097998	JET Chart: Data densification logic should not be applied to scatter chart

6.1.2 Fixed Bugs in 5.1.3

The following tables list bugs fixed in the Oracle Application Express the 5.1.3.00.05 patch set.

Fixed Bugs in 5.1.3 — Interactive Grid

Table - Interactive Grid Bugs Fixed in the 5.1.3 Patch Set

Bug Number	Description
25421265	Interactive Grid: Chart view does not refresh after settings change
25469797	Interactive grid performance issues with Microsoft Internet Explorer 11
25666081	Interactive grid column blank after update it with PL/SQL DA
25801903	Interactive grid search field doesn't show placeholder
25812329	Interactive Grid: Switching views can cause interactive grid to then rapidly switch by itself
25867311	Interactive Grid: UI issues caused by unwanted toolbar refreshing
26147254	Interactive Grid: Unwanted duplicate saved reports sometimes created
26245221	Interactive Grid: `NULL` display value not displayed in cascading select list
26260818	Interactive grid model `SETVALUE` can result in wrong column updated
26326589	Interactive grid exports wrong value for cascading LOV
26403861	Detail interactive grid in tabs/rds doesn't refresh when master selection change
26415403	Interactive grid setting `views.grid.features.reorderColumns=false` does not work

Fixed Bugs in 5.1.3 — Packaged Applications

Table - Fixed Bugs Related to Updated Packaged Applications in the 5.1.3 Patch Set

Bug Number	Description
25633396	Bug Tracking: 'Remove Products and bugs' throws unexpected error
26008377	P-Track: Cannot change start & due date of a milestone
26265280	P-Track: Upgrade of P-Track from Oracle Application Express 5.0 to Oracle Application Express 5.1.2 throws error
26278363	Opportunity Tracker: Product Families page not refreshed when new product added
26286210	Script Planner: Internal application error has occurred when add step as copy
26286274	Opportunity Tracker: Upgrade from 5.1.0.00.45 to 5.1.2.00.08 encounter error
26326761	Survey Builder: Can't edit questionnaire page 30, with ORDS 3.0.10 instance
26385020	P-Track: FLEX column labels/fields not aligning correctly
26449066	Live Poll: Add Community/Members page, there is no default radio button selected
26619820	P-Track: Can't delete Action item from project template
26679401	P-Track: Unable to create project when project logo is selected
26716101	P-Track: Deleting milestone in project template throws error

Fixed Bugs in 5.1.3 — Other

Table - Other Bugs Fixed in the 5.1.3 Patch Set

Bug Number	Description
25790200	Generated passwords should satisfy rules of `ORA12C_STRONG_VERIFY_FUNCTION`
26321431	`ORA-00942` in Object Browser when inserting data into case-sensitive column name
26328880	`ORA-06502` in `APEX_DEBUG` when emitting long strings that contain unicode
26352078	Full application export/import fails with `ORA-20001` error
26369194	`#THEME_DB_IMAGES#` and `#APP_IMAGES#` doesn't work when Allow Hostnames is set
26407686	Cannot save emoji in static content region via Page Designer
26407890	Select lists for create wizards show table names multiple times
26444114	Data loading loads invalid number values as `NULL` instead of throwing an error
26557911	JET Chart: Highlight and explode option on pie chart not working
26649483	Runtime installation fails in a 12c CDB
26717149	Header authentication does not log user in
26718756	JET Chart: Inconsistent times displayed on chart when ISO string has no timezone

6.1.3 Fixed Bugs in 5.1.2

The following tables list bugs fixed in the Oracle Application Express the 5.1.2.00.09 patch set.

Fixed Bugs in 5.1.2 — Interactive Grid

Table - Interactive Grid Bugs Fixed in the 5.1.2 Patch Set

Bug Number	Description
25421153	Interactive Grid: Switch to saved report with aggregation fails
25680628	Interactive Grid: Chart view resize broken after reset
25735528	Interactive Grid: Delete Row, Go To Next Page, and Save results in error
25755555	Interactive Grid: Over escaping of row filter in report settings
25801249	Interactive grid data > Aggregate menu is always disabled
25823461	Interactive grid combination no filterable columns and no toolbar gives error
25877967	Interactive grid Go To Cell broken cannot focus errors
25881930	Interactive Grid: Highlights and column filter do not work for translated apps
25909971	Interactive Grid: Export/import an app always sets toolbar buttons to displayed
25931766	Interactive Grid: ROWID and index organized table
25951160	Interactive Grid: CSV download appending double quote on filename in http header
25952891	Interactive Grid: Error when resetting a report with an aggregate defined
25967390	Interactive Grid: DML process does not use table name for insert
25991346	Interactive Grid: Empty 'Show Null Values As' attribute defaults to '-' on import
26099396	Interactive Grid: Download filename does not work as documented
26101182	Interactive Grid: problems when adding new columns to existing interactive grid regions

Fixed Bugs in 5.1.2 — Packaged Applications

Table - Packaged Applications Bugs Fixed in the 5.1.2 Patch Set

Bug Number	Description
25292024	Group Calendar: Missing Admin page for managing event type colors
25520573	Left with packaged apps that cannot be dropped if they fail installation
25632516	Bug Tracking: Upgrade from 4.2.5 to 5.1.1 Dashboard page title missing user name
25685270	Sample REST Services App: Running application throws `ORA-06550` error
25720634	Live Poll page 100 Respondents region generates errors
25825509	Survey Builder in Oracle Application Express 5.1 is not recording survey results
25909773	Unable to use packaged applications if schema name is all digits
26041805	P-Track: Editing user details page on Oracle Database 11g throws `ORA-00923`
26050347	Sample Geolocation Showcase has no prerequisite check for Oracle XE
26115554	Bug Tracker: Synchronize Bugs > Add Product > shows package not found
26120780	Incident Tracking "Updates" region displays HTML on Ticket Details page 50
26129383	Quick SQL App: History option broken

Fixed Bugs in 5.1.2 — Other

Table - Other Bugs Fixed in the 5.1.2 Patch Set

Bug Number	Description
22067754	All schema objects are listed for second schema when creating a page
25119626	Multiple axis bar chart XML data does not have secondary Axis attribute if series
25164612	Chart links activated when navigating chart sections with keyboard
25292024	Group calendar: Missing Admin page for managing event type colors
25520573	Left with packaged apps that cannot be dropped if they fail installation
25634350	Export file owner mismatch in `import_begin` and `create_flow`
25636767	Theme Roller: Remove Max Length from JSON configuration attribute of theme style
25685270	Sample REST Services App: Running application throws `ORA-06550` error
25718359	Stateful On Load page processes do not recognize their state being reset by URL
25720634	Live Poll page 100 Respondents region generates errors
25731766	Breadcrumb template Before First attribute no longer substitutes `#IMAGE_PREFIX#`
25790200	Generated passwords should satisfy rules of `ORA12C_STRONG_VERIFY_FUNCTION`
25825509	Survey Builder in Oracle Application Express 5.1 is not recording survey results
25838279	Reloading mobile page in Oracle Application Express 5.1.1 raises error `ERR-1002`
25841909	JET Chart: Links defined on chart using DateTime x-axis not working
25851580	JavaScript error when page has tabs or region display selector
25853436	App export losing bytes when app contains emojis
25855970	PL/SQL based shortcuts not rendering in post item text
25860859	Create interactive grid and form page not creating `Get PK` page process
25897246	Converting Oracle Application Express 4.2.5 to Application Express 5.1.0, limit in length allowed for region title in Application Express 5.1.0
25909773	Unable to use packaged applications if schema name is all digits
25940678	Unable to edit/delete workspace Admin
25992450	Oracle Application Express 4.2 images export file cannot be imported into Oracle Application Express 5.1.1 via UI
26004946	Shortcut URL not handling substitution of `p_lang` parameter
26022208	`APEX_JSON.WRITE(cursor)`: newlines in output after 8k chunks
26030893	JET Chart: Scatter chart missing Line Type attribute to render connecting line
26048323	`APEX_PLUGIN_UTIL.GET_PLSQL_FUNC_RESULT_CLOB` may throw `ORA-6502` in UTF8 database
26078193	`APEX_COLLECTION.GET_MEMBER_MD5` API misses certain columns in its calculation
26086869	`APEX_JSON.WRITE(cursor)`: Corrupt data with large JSON
26091214	Number item might corrupt input when decimal point is used in German NLS
26100707	REST Client Assistant cannot access `GITHUB REST` API
26105247	Data Loading Wizard: Ignores second upload column for table lookups
26137846	Upgrade Application: Cannot upgrade AnyChart based on function to JET chart
26161344	`APEX_JSON.WRITE(cursor)`: No output for CLOB column if value longer than 32k

6.1.4 Fixed Bugs in 5.1.1

The following tables lists bugs fixed in Oracle Application Express the 5.1.1.00.08 patch set.

Fixed Bugs in 5.1.1 — Interactive Grid

Table - Interactive Grid Bugs Fixed in the 5.1.1 Patch Set

Bug Number	Description
25442686	Interactive grid bar chart: 'Horizontal' orientation not working correctly
25164466	Interactive grid cell error state can be copied to the next or previous row
25354910	Interactive grid column headings in wrong place returning from single row view
25438651	Interactive grid combination page, control break, aggregate is broken
25374178	Interactive grid duplicates model Id column when there are multiple reports
25581052	Interactive grid error fetching detail when master record added
25393036	Interactive grid go to cell fails when records have multiple primary keys
25450118	Interactive grid highlight dialog cannot update highlight type from column to row
25435712	Interactive grid highlight dialog should not be restricted to filterable columns
25366799	Interactive grid JavaScript error when no columns enable filtering
25538911	Interactive grid overall aggregate row needs distinct style
25438167	Interactive grid popup LOV item in first column broken on add row
25410135	Interactive grid Rows-Per-Page action fails if used from toolbar select list
25518732	Interactive grid scroll paging can duplicate or skip rows
25438396	Interactive grid Single Row View exclude Nulls and displayed columns options have no effect
25368259	Interactive grid unusable when hidden and shown
25655794	Interactive grid with form raises `ORA-0172` for multibyte Primary Key column
25290734	Interactive Grid: Attempting to save funnel chart fails if no target specified
25451910	Interactive Grid: Autocomplete item type causes no data found error
25475878	Interactive Grid: CLOB column is updated to Null
25572912	Interactive Grid: Column header allows hide on column that should not be hidden
25407312	Interactive Grid: Display issues after deleting a chart
25436444	Interactive Grid: Does not allow disabling highlights on interactive grid level
25177090	Interactive Grid: Edits still allowed when Flashback is enabled
25387494	Interactive Grid: Keyboard resize does not work in first column
25387592	Interactive Grid: Most advanced column configuration options do not work
25510612	Interactive Grid: Pie chart throws JavaScript error `a.trim is not a function`
25374633	Interactive Grid: Resize logic does not work in right to left direction
25421991	Interactive Grid: Row menus stop working when toolbar is disabled
25525852	Interactive Grid: Substitution variable not substituted in format mask of column
25545569	Interactive Grid: When editable, select list shows double down arrows in Microsoft Internet Explorer 11

Fixed Bugs in 5.1.1 — Packaged Applications

Table - Packaged Applications Bugs Fixed in the 5.1.1 Patch Set

Bug Number	Description
25228201	Survey Builder: Did not refresh/reload questionnaire page once added answer set
25337675	Competitive Analysis: Error occurs when 'edit comparisons' is clicked
25493981	Sunburst Chart plug-in in Sample Charts application does not work
25632492	Bug Tracker: Upgrade from 4.2.5 to 5.1.1 results in missing bug statuses
25632504	Bug Tracker: Administration, Manage Assignee Group pop up authentication required
25632542	Bug Tracker: Add Assignee throws `Cannot Insert NULL into ACCESS_LEVEL_ID`
25633678	Customer Tracker: Updating the application throws error `ORA-00955`
25642699	P-Track: Error after upgrade of application from Oracle Application Express 4.2.5 -> 5.1.1

Fixed Bugs in 5.1.1 — Other

Table - Other Bugs Fixed in the 5.1.1 Patch Set

Bug Number	Description
23855006	Unable to import RESTful service when associated privilege is not present
24410383	Mandatory URI_Prefix in RESTful module creation page not marked as required
24517271	Websheet: Cannot add file to a row of data grid
24906541	Mobile Pages: Cannot access template options in Page Designer
25136927	Reloading mobile page in Oracle Application Express 5.0.4 can raise error `ERR-1002`
25181666	Cannot edit template in Japanese because buffer is too small
25202042	`APEX_WEB_SERVICE` should unzip CLOB response
25206891	Unnecessary HTML tags In CSV exported file
25216194	Create Form On Procedure Page Wizard not creating items or In and Out parameters
25225356	Using Oracle Real Application Security Administration Application (RASADM) in Oracle Application Express does not work for numeric users, works for alphabetic ones
25227883	Create Page Wizard: Unable to create Report On Web Service
25228201	Survey Builder: Did not refresh/reload questionnaire page once added answer set
25298133	`APEX_JSON.WRITE(CURSOR)`: Slow output for nested cursor query
25299037	`APEX_MAIL VIEWS`: `APEX_ADMINISTRATOR_READ_ROLE` should see all rows
25303884	Client-side messaging fails to substitute `#IMAGE_PREFIX#` in page notifications
25307229	Developer can see administrator and other developer saved SQL In SQL Workshop
25311325	`APEX_MAIL` should generate MESSAGE-ID header
25337675	Competitive Analysis: Error occurs when 'Edit Comparisons' is clicked
25353292	Application export does not include Warn On Unsaved Changes attribute for button
25373158	Cookie not set in Oracle Application Express 5.1
25374827	Workspace export does not include Team Development feature types
25378653	Packaged App upgrade in workspace with insufficient space throws `ORA-20100` error
25387853	Create Report With Form On Table Wizard does not work if existing page entered
25403527	Page Designer: Allow more than 60 column for Generic Column Count attribute
25403748	Plug-In Ajax Request fail if component ID is negative
25407597	Create Wizard Page not creating progress list due to missing theme identifier
25408443	Extraneous errors in SYS schema echoed in Oracle Application Express 5.1 installation log
25408849	Oracle Application Express dialog should not rely on content being a normal Oracle Application Express page
25409901	Timeout occurs while refreshing theme from Master Theme repository
25421700	Create Login Page Wizard throws `ORA-1400`
25422368	App Builder Language Preference not remembered across browser sessions
25423099	Interactive Report: Subscription error text remains after subsequent run succeed
25427480	Create Page Wizard - Report and Form On Table not creating Primary Key page process
25430809	Invalid build option mappings after application import
25435728	Error In Oracle HTTP Server (OHS) mod_security when URL parameters contain ../
25449679	Allow 0 for Instance parameters `MAX_SESSION_IDLE_SEC` And `MAX_SESSION_LENGTH_SEC`
25469158	Oracle Application Express tree component nodes cannot be opened or closed when left nav is collapsed
25473808	Checksum not working with session cloning in Oracle Application Express 5.1
25480899	Update Tabular Form To Interactive Grid Wizard throws `ORA-06502` error
25482334	Make `APEX_MIG_PROJECTS_UPDATE` and `APEX_UI_DEFAULT_UPDATE` invoker rights
25489876	`APEX_ITEM.DATE_POPUP` (Old "Popup" Datepicker) does render properly
25489933	Websheet: Data grid link syntax generates RPT_ID when no saved report name set
25493981	Sunburst Chart plug-in in Sample Charts app does not work
25503557	AnyChart HTML5 chart not displaying in Firefox 51.0.1 (32-BIT)
25510163	Modal dialog is blank when session timed out
25511529	Websheet login re-displays login page when user password is expired
25523429	JavaScript API: Added documentation For `APEX.MESSAGE`
25526157	Theme Roller: Setting Border-Radius does not work in Standard region template
25534094	CSS Calendar does not respect JavaScript Initialization of "Defaultdate"
25538561	CSS Calendar PDF output does not contain one-day-events with end date
25541109	Interactive report: Static ID containing space causes JavaScript errors
25551233	`APEX_JSON.WRITE(Cursor)`: NLS_NUMERIC_CHARACTERS should be set
25553597	Jet Chart region broken if in a collapsible (that is initially collapsed)
25573512	Data Workshop: Unload XML errors out on Microsoft Internet Explorer 11; Cannot close dialog in other browsers
25575764	CSS Calendar not displayed correct when in initially collapsed region
25583861	Jet Chart: Range chart not displaying Axes nodes in Page Designer
25585351	Page Submit On public home page when session expired has misleading error message
25592396	Item Type plug-in uses render function name for Ajax call
25595984	Umlauts not passed via URL without SESSION_ID
25604360	Interactive report: Layout broken in collapsible Or Region Display Selector
25632504	Bug Tracker: Administration, Manage Assignee Group pop up authentication required
25632516	Bug Tracker: Upgrade from Oracle Application Express 4.2.5 to 5.1.1 Dashboard page title missing user name
25632542	Bug Tracker: Add Assignee throws cannot insert Null into `ACCESS_LEVEL_ID`
25633678	Customer Tracker: Updating the application throws `ERROR-ORA-00955`
25642699	P-Track: Error after upgrade of application from Oracle Application Express 4.2.5 -> 5.1.1
25650850	`APEX_JSON`: Escaping is broken when data contains multibyte characters
25657519	Page Designer: Missing Since For Date format mask
25665392	`BRANCH_TO_PAGE_ACCEPT` with no session shows session expired error
25673144	`APEX_JSON.WRITE(Cursor)`: 12345. Is treated as number, should be quoted
25673293	`APEX_JSON.WRITE(Name,Cursor)`: "," before cursor values
25755793	Over escaping of page item value when application requires authentication

7.1 Known Issues

The following describes issues and changes included in this Oracle Application Express patch set. This section is current as of the writing of this document. To learn more about changed behavior, deprecated features, and desupported features see Oracle Application Express Release Notes.

Tip:

To view the most current listing of known issues, go to the Known Issues page available off the Downloads page.

Number Item Might Corrupt Input When Decimal Point Is Used In German NLS
Sample Projects: Administration Page Throws ORA-00942
Item Errors Not Cleared by Fallback for Non Universal Themes
Client-side Inline Error Message for Rich Text Item Gives JavaScript Error
Do Not Use Time Zone APIs and Constants in APEX_JSON Package

7.1.1 Number Item Might Corrupt Input When Decimal Point Is Used In German NLS

When using a "number type item" in previous releases, the item type validation accepted the point (.) as the decimal character for locales which use the comma (for example, German, French). This behavior can lead to side-effects and corrupt input when combined with Automatic Row DML processes.

To fix the bug, the number item type now only accepts the standard NLS decimal character. Therefore, for German or French locales, the comma must be used as the decimal character because using a point (.) results in the validation error Value must be numeric.

This issue is tracked with Oracle bug 26091214.

7.1.2 Sample Projects: Administration Page Throws ORA-00942

When attempting to navigate to the Administration page, page 24, of the Sample Projects application, an ORA-00942 error displays stating that table demo_states is missing. That table is incorrectly referenced in this application.

This issue is tracked with Oracle bug 26352194.

Workaround:

To workaround this bug:

Navigate to Packaged Apps.
Install Sample Database Application

The supporting objects associated with Sample Database Application will create the demo_states table.

7.1.3 Item Errors Not Cleared by Fallback for Non Universal Themes

Displaying inline item errors by using a fallback for non-Universal Theme apps sometimes results in errors not being cleared properly.

This issue is tracked with Oracle bug 25303970.

7.1.4 Client-side Inline Error Message for Rich Text Item Gives JavaScript Error

Client-side inline error messages for rich text items results in a JavaScript error if Reload on Submit is set to Only for Success. This issue typically occurs in older applications that use older themes.

This issue is tracked with Oracle bug 25305292.

Workaround:

To workaround this bug, set Reload on Submit to Always.

7.1.5 Do Not Use Time Zone APIs and Constants in APEX_JSON Package

APEX_JSON contains new, undocumented APIs and constants for reading and writing TIMESTAMP, TIMESTAMP WITH TIME ZONE and TIMESTAMP WITH LOCAL TIME ZONE values. These APIs and constants are subject to change in later releases, which will likely break any code that utilizes them at this point in time.

Workaround:

Do not use the undocumented timezone APIs and constants until they have been documented.

8.1 Other Issues and Changes

This section describes other issues and changes included in this patch set.

New APEXExport Parameters
JET Chart Pie Selection Effect
Removal of Flash Components from Images Folder
JET Chart Data Densification
Updated Packaged Applications

8.1.1 New APEXExport Parameters

You can export workspaces, applications, and related files from a command-line using the APEXExport located in the Utilities folder in the downloaded installation zip file. The APEXExport now includes the following new parameters:

-expNoSubscriptions: Do not export references to subscribed components     
-expComments: Export developer comments     
-expSupportingObjects: Pass (Y)es, (N)o or (I)nstall to override the default     
-nochecksum: Overwrite existing files even if the contents have not changed    
-split: Split applications into multiple files

See Also:

"Deprecation of APEXExportSplitter"

8.1.2 JET Chart Pie Selection Effect

When a pie or donut chart has a link defined on the chart series, then the 'Pie Selection Effect' attribute will have no effect on the chart. This behavior change is associated with the 5.1.4 bug fix 26940266. Now, the Oracle JET 'drilling' attribute is set when a link is defined on a chart, and the 'selectionMode' attribute is not set, to avoid having to double-click on a chart element to trigger the link.

8.1.3 Removal of Flash Components from Images Folder

With Oracle Application Express 5.1.4, the AnyChart and AnyGantt flash .swf files have been removed from the /images folder. This will result in your map chart and gantt charts no longer rendering. No error message displays, instead the region will be blank.

To address this issue, you need to download the files from the AnyChart Flash Content patch on OTN and apply the patch to your /images folder. To download the patch, go to the Known Issues page and find Changed Behavior, FLASH CHARTS AND GANTT CHARTS NO LONGER DISPLAY.

8.1.4 JET Chart Data Densification

Oracle JET requires that each series of a multi-series chart contains a data point for each label that is represented on the x-axis. Otherwise, the multi-series chart may not render correctly by Oracle JET. Prior to release 5.1.3, the user was required to handle the densification of their data in their chart SQL query to ensure that each series had the same number of data points, even if they were null or zero. Oracle Application Express release 5.1.3 now includes support to automatically fill in gaps, injecting missing data points for multi-series charts.

8.1.5 Updated Packaged Applications

To take advantage of updated packaged applications, install the patch set and then upgrade the packaged application.

Updated Packaged Applications in 5.1.4

Oracle Application Express release5.1.4.00.08 includes updates for the following packaged applications: Sample Charts, Sample REST Services, Quick SQL, Live Poll, Meeting Minutes, Survey Builder, APEX Application Archive, Application Standards Tracker, Data Reporter, Checklist Manager, P-Track, Customer Tracker, Incident Tracking, Community Requests, Group Calendar, Bug Tracking, Opportunity Tracker, Site Designer, Competitive Analysis, Script Planner, and Decision Manager.

Updated Packaged Applications in 5.1.3

Oracle Application Express release 5.1.3.00.05 includes updates for the following packaged applications: Sample Charts, P-Track, Data Reporter, Live Poll, Survey Builder, Opportunity Tracker, Script Planner, Bug Tracking and Group Calendar.

Updated Packaged Applications in 5.1.2

Oracle Application Express release 5.1.2.00.09 includes updates for the following packaged applications: Sample Charts, Sample REST Services, Brookstrut Sample Application, Sample Calendar, Sample Dynamic Actions, Sample Database Application, Universal Theme Sample Application, and Sample Geolocation.

Updated Packaged Applications in 5.1.1

Oracle Application Express release 5.1.1.00.08 includes updates for the following packaged applications: Survey Builder, Competitive Analysis, Bug Tracker, Customer Tracker, and P-Track.

9.1 Deprecated Features

Deprecated features are features which Oracle plans to desupport or remove in a future release of Oracle Application Express. If a feature is related to application metadata or an APIs, existing applications can still use the feature, but Oracle strongly recommends that developers start to modify their applications as described in this section. Use Oracle Application Express Advisor to scan existing applications for deprecated attributes.

Deprecation of APEXExportSplitter
Deprecation of jQuery Mobile and Mobile User Interface

9.1.1 Deprecation of APEXExportSplitter

The APEXExport program for exporting workspaces, applications, and related files now includes a -split parameter which enables developers to split exported applications into multiple files. Because of the addition of this new -split parameter, the APEXExportSplitter program has been deprecated.

9.1.2 Deprecation of jQuery Mobile and Mobile User Interface

The jQuery Mobile user interface has been deprecated. The last stable version of the jQuery Mobile open source library was released on 10/31/2014 and only provides support for jQuery versions 1.8 - 1.11 and 2.1, which no longer receive patches. Oracle Application Express release 5.2 will ship with jQuery 3.2. All new application development targeted at mobile devices should be done using the responsive Universal Theme. Existing mobile applications should be migrated to the Universal Theme prior to upgrading to Oracle Application Express release 5.2.

10.1 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.1.4.00.08

E84555-04

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.