Oracle Apex patch 4.0.2.00.06

Revion Solutions, Inc (founded in June 1999) is a web hosting company based in New York, NY USA. Our company offers a complete suite of professional services, including Oracle database, Oracle Apex and web site hosting, domain name registration, design and development, web templates, and web promotion. Revion Solutions, Inc is a privately owned company and has no outstanding debts or liabilities. Our team is composed of highly-qualified and devoted professionals, with diverse backgrounds, creating a powerful mix of high-quality web hosting and design specialists dedicated to providing our customers with one of the best products in the web hosting industry.

We are pleased to announce we have applied latest Apex patch 4.0.2.00.06
The following table lists bugs fixed in the Oracle Application Express 4.0.2.00.06 patch set:

1. Bug NumberDescription
2. 6360643
3. Missing RESTRICT_TO_USER_LIST in application export
4. 9752881
5. Read only quick picks on 4000:4311 and 4000:371 should show “Always”
6. 9855165
7. Incorrect results when viewing session state from Developer toolbar
8. 10024385
9. Ignore case and blanks in attributes which are referencing page items
10. 10024437
11. Flash 5 dial chart incorrect value displayed when value should be zero
12. 10024919
13. Map attribute labels does not control visibility of labels on map
14. 10030517
15. Popup LOV uses HTML Form Element attributes for anchor link
16. 10030798
17. Interactive report CSV download includes extra pair of DIV tags
18. 10037373
19. Unable to create forms conversion project using Internet Explorer 7 and Application Express Listener
20. 10041505
21. Popup LOV search should use LIKE operator
22. 10041816
23. Multi Row Delete process fails in some cases when display sequence was altered
24. 10049423
25. Named report template page not displayed when called from Page Edit tree
26. 10050404
27. String from other pages included in XLIFF page export
28. 10051384
29. Flash 5 Gantt chart does not support ‘DS’ application date format
30. 10055032
31. Children do not show up or are wrong in Query Builder
32. 10055407
33. Theme 1 – Hide/Show region template missing float left
34. 10057703
35. Cannot make ‘Simple Checkbox’ columns conditional
36. 10058590
37. APEX_DEBUG_MESSAGE.LOG_LONG_MESSAGE incorrectly splits the message
38. 10058669
39. ORA-01785 raised in sort-enabled classic reports when columns change
40. 10062523
41. APEX_DEBUG_MESSAGE.REMOVE_DEBUG_BY_AGE API parameter typo
42. 10066270
43. Session State Protection report shows wrong value for Item Session State Protection
44. 10066324
45. Multiple tree regions on same page may result in incorrect tree data
46. 10069374
47. Pressing ESCAPE key sets value to jQuery based datepicker with time
48. 10070849
49. Interactive report filter with next day gives ORA-00936: Missing expression
50. 10079075
51. Incorrect item layout on Create Calendar Region attributes page 4000:2006
52. 10090373
53. APEX_DEBUG_MESSAGE.REMOVE_DEBUG_BY_AGE API parameters should not have NULL defaults
54. 10090518
55. APEX_DEBUG_MESSAGE.REMOVE_DEBUG_BY_AGE API removes incorrect messages
56. 10090652
57. APEX_DEBUG_MESSAGE.REMOVE_DEBUG_BY_APP API parameters should not have NULL default
58. 10090699
59. APEX_DEBUG_MESSAGE.REMOVE_DEBUG_BY_VIEW API parameters should not have NULL defaults
60. 10091086
61. Flash 5 chart multiple Y axes only applied to first series of chart
62. 10092894
63. View APEX_DEBUG_MESSAGES sometimes returns incorrect EXECUTION_TIME
64. 10092991
65. Debugging flag shows and saves wrong value in Edit Application Properties
66. 10093329
67. APEX_DEBUG_MESSAGE.LOG_PAGE_SESSION_STATE API does not show item values
68. 10093980
69. Navigation bar logout entry created with condition type CURRENT_LOOK_IS_1
70. 10095760
71. ORA-20001: Error In MRU in LOV in migrated tabular, form empty
72. 10100985
73. Enabling debug using ENABLE_DEBUG_MESSAGES API results in missing debug information
74. 10103359
75. Interactive report hangs search string exceeds allowed character limit
76. 10104409
77. Runtime installation becomes invalid when using APXDEVRM.SQL
78. 10104883
79. ORA-29279 SMTP permanent error when using reporting period
80. 10107478
81. Region Display Selector attribute is ignored on import for certain region types
82. 10107616
83. Syntax error in SQL report results in HTTP 404
84. 10107767
85. Condition type “NONE” for validation might raise error
86. 10108363
87. Flash 5 Map Animation option missing from Map Attributes page
88. 10108919
89. Flash 5 charts checksum only applied to Action link for last record of series
90. 10118507
91. Recently created dates can show in the future when using SINCE format mask
92. 10119451
93. Application export with authentication scheme using ‘NOT’, ‘NOT’ is lost on import
94. 10121357
95. Interactive report: when SELECT updated, existing columns of type timestamp are refreshed
96. 10124254
97. Create Application on Spreadsheet Wizard: Theme selector region too narrow
98. 10124263
99. Create Application on Spreadsheet Wizard: Final page icons not properly displayed
100. 10124268
101. Install application final page ‘Update App’ icon not proper
102. 10126550
103. Region display point preview popup does not work in German
104. 10149191
105. Dynamic actions: should show ‘never’ in Page Definition component view
106. 10149623
107. Page items of type select list, check box, and radio group should allow refresh
108. 10149957
109. Update text field item to number field item
110. 10150718
111. APEX_INSTANCE_ADMIN.REMOVE_SAVED_REPORTS should not remove primary default report
112. 10150816
113. Error on application search
114. 10154666
115. Interactive report chart displays incorrect decimal separator in non-english application
116. 10158459
117. Application Express Autocomplete is replacing ampersand with ‘&’
118. 10158747
119. Unexpected behavior with interactive report filtering with multi column LOV
120. 10162569
121. Search on 4000:1 includes SESSION_ID when it should not
122. 10162590
123. Search on 4000:1500 includes SESSION_ID when it should not
124. 10165864
125. Reader access not granted to user that logs in when running a PUBLIC Websheet
126. 10169594
127. Error message does not show up when editing process and shortcuts are used
128. 10174506
129. Bad region template selected on page 4000:48, ugly button wrapping issue
130. 10177937
131. Interactive report row text contains filter includes filter disabled column. To learn more, see “Row Searches on Interactive Reports No Longer Search for Filter Disabled Columns”
132. 10185693
133. Interactive report row filter type displays filter disabled column
134. 10185939
135. Add an API in APEX_UTIL to delete interactive report subscription
136. 10185978
137. Flash 5 scatter chart displaying incorrect marker in legend
138. 10188925
139. Import of application with access control supporting objects throws error
140. 10189958
141. Interactive report after refresh event sometimes causes processing GIF to not be hidden
142. 10190015
143. NV function raises ORA-01722 if value contains group separator
144. 10195512
145. User granted create any table does not show up in spreadsheet data load
146. 10198879
147. Allow more than one email address in interactive report subscription
148. 10198889
149. Interactive report: subscription, format masks using substitutions are not supported
150. 10201943
151. Editing of page item fails if too many plug-ins are installed
152. 10202158
153. Page fails to load when many dynamic actions are defined on a page
154. 10202608
155. Team Development feedback, 4800:8000 does not search feedback column
156. 10202722
157. Editing Master Detail page in Create Application Wizard throws ORA-20001: NO DATA FOUND
158. 10203473
159. In a Oracle Database upgrade release 11.2.0.2, APXDBMIG.SQL may show errors
160. 10203596
161. Change Theme Number – Wizard templates too narrow for buttons
162. 10205497
163. Flash 5 line chart ‘Series type’ defaults to bar instead of line
164. 10206259
165. Flash 5 Map Wizard displays incorrect images for North America and South America, Asia, and Oceania
166. 10206411
167. Flash 5 combined chart not displaying label and tooltip information for all chart series
168. 10206510
169. Classic report row highlighting function not working for all themes
170. 10207277
171. List of values report, 4000:421, does not search Query column
172. 10210711
173. Add new placeholder #INTERNAL_MESSAGE# to error page template
174. 10210802
175. DHTML list (IMAGE) with sublist does not work
176. 10215164
177. Restful Web service support does not escape values when posting
178. 10215440
179. Interactive report displays LOV in filter and highlight when it is disabled
180. 10218361
181. Editing filter on pseudo column in Websheet data grid displays 2 operator lists
182. 10219253
183. List of values report,4000:4110, does not search Query column
184. 10221310
185. Data Grid validation dialog has misleading title
186. 10222168
187. Websheet data grid filtering on Tag column has inconsistencies
188. 10223154
189. Data Grid Pseudo column filter and highlight information display in red when it should not
190. 10226951
191. ORA-04030 encountered when displaying Flash chart in Oracle Database 11.2.0.2
192. 10228576
193. Interactive report email download and subscription send attachment in database character set
194. 10231413
195. APEX_ITEM.SELECT_LIST_* APIs behave incorrectly if P_SHOW_NULL = YES
196. 10232386
197. Multi-series chart does not display first chart
198. 10238450
199. Interactive report filter dialog raises a 404 "NO DATA FOUND" error if page is submitted
200. 10240360
201. Flash 3 charts throw ORA-01403 error if color schemes looks 6 or 7 used
202. 10244462
203. Confirmation page of Create Form on Web Service has buttons out of place
204. 10247924
205. Dynamic action When conditions does not work with shuttle, check boxes, or select list (with enabled Multi Select)
206. 10248011
207. Theme toolbar stretches after upgrading to Oracle Application Express 4.0.1 in Internet Explorer
208. 10252335
209. ORA-20001: GET_BLOCK when importing page which uses a not public user authentication scheme
210. 10254296
211. Access Migrations navigation region missing icons in generated applications
212. 10254433
213. Default theme should be set to theme 21 in Create Application Wizard
214. 10254660
215. Automatic Time Zone application with time zone at 0:00 loops forever
216. 10262671
217. Flash 5 chart series type item not displayed when page loaded using tree view
218. 10264946
219. ORA-44003 occurs when Set Autocommit off in SQL Commands page
220. 10270216
221. ERROR ERR-1016 / ITEM_PREFERENCE (Use item containing preference)
222. 10078661
223. Advisor fails with ORA-20999 Unknown Type if process type plug-in is used