icon-arrow icon-check icon-mail icon-phone icon-facebook icon-linkedin icon-youtube icon-twitter icon-cheveron icon-download icon-instagram play close icon-arrow-uturn icon-calendar icon-clock icon-search icon-chevron-process icon-skills icon-knowledge icon-kite icon-education icon-languages icon-tools icon-experience icon-coffee-cup
Werken bij Whitehorses
Blog 11/10/2012

Slow loading of tabular forms in Application Express

Slow loading

Under some circumstances, there is an issue (observed in Application Express that page tabular forms take very long to load, up to several minutes. Even if there is a very small dataset in the underlying table.  When I encountered this issue, the report ran fine on Development en Test environments, but in the almost identical production environment the page took minutes to load.

When examining the debug, I found the following line of Apex generated code, taking up to 30 seconds:

   select /*+ cardinality(t 10) */ 
       , val 
         bulk collect 
   into wwv_flow_utilities.g_display
      , wwv_flow_utilities.g_value 
   from table(wwv_flow_utilities.get_temp_lov_data(4)) t 
   order by insert_order, disp; 

The main culprit appears to be the wwv_flow_utilities.get_temp_lov_data. This function is called whenever you create an item of the type “Select List (Named LOV)”. The workaround I found is to change the type to “Select List (Query Based LOV)” or “Select List (Static LOV)”. After altering the report attribute type, the report is loading normally.

Report Attributes

Downside is that it will make your code less maintainable. Hopefully the problem is fixed in Apex 4.2.

Overzicht blogs

Geen reacties

Geef jouw mening

Reactie plaatsen

Reactie toevoegen

Jouw e-mailadres wordt niet openbaar gemaakt.


  • Geen HTML toegestaan.
  • Regels en alinea's worden automatisch gesplitst.
  • Web- en e-mailadressen worden automatisch naar links omgezet.

Wil je deel uitmaken van een groep gedreven en ambitieuze integratiespecialisten? Stuur ons jouw cv!