Monday, February 08, 2010

Tale of a strange quirk in apex session state initialization

Always check out the original article at http://www.oraclequirks.com for latest comments, fixes and updates.

Today was a good day because i finally managed to allocate some time and get to the bottom of an old standing issue that I've been encountering at intermittent times during the last five or six years spent developing applications with Apex:

how come that sometimes page item initialization doesn't *always* work as advertised?

In brief, items, page and region items alike, come with a source value attribute that may contain an initialization value. This value can be set in a variety of ways, most common being a static value, a query or a PL/SQL expression.
Now, given Apex defaults, the most frequent usage pattern for an item is to define a source value of type static assignment to be used only when current value in session state is null.

For instance, say we have a region containing an item called P20_MAX_ROWS and we want to initialize it to 11.


Now, say we have a report in a nearby region based on a query like this:
select page_name
from apex_application_pages
where application_id = :APP_ID
and rownum <= :P20_MAX_ROWS
I guess that everybody would expect to see a report displaying a maximum of 11 rows (or less).
What you get instead is an empty report.

In other words, if you have a report containing an item belonging to a different region and this item is used in the WHERE clause, it's very likely that you get an inconsistent or empty report (it depends on the WHERE conditions of course) upon the first loading of the page. Subsequent page loads may not be affected if the page is submitted and session state is consequently updated, hence it's easy to be puzzled by this behavior.

This behavior seems to be "consistent" throughout various Apex releases, including the most recent one, 3.2.1, as shown in the linked test page.

It's interesting to note that:
  1. the type of source value (static, pl/sql expression or sql query) doesn't seem to make any difference.
  2. if we relocate the item inside the report region, the initialization seems to work just fine and the report is generated correctly.
If we cannot relocate the item to the report region, then another workaround is to add a before header computation for initializing the item(s).

This is the way I've always dealt with this problem until now, even without knowing exactly what was wrong with item initialization, but this isn't always the best approach, it's much better to know how and when a certain feature will work or not.

7 comments:

Anonymous said...

Please see this post for a little more information on this issue:
http://c2anton.blogspot.com/2008/12/oracle-application-express-apex-three.html

Byte64 said...

Hi,
thanks for the link.
If you noticed Patrick's comment, that's exactly the case mentioned here.
Nevertheless i find rather hard to consider this as a feature, probably it should be considered as a known quirk that we have to live with for some reason :-)

Flavio

Jeffrey Kemp said...

Thanks for this article, it's clarified this for me. I did already understand (somewhat) that the Default value for an item does not cause the item to be "initialised" - the item's value only gets set when the page is submitted or if I have an onload process that sets it.

Anonymous said...

If you've been developing using Apex for 5 years and only just know about the submit based init issue now then what have you been developing?!

Byte64 said...

Thanks for the most clever comment in all history of this blog, anonymous.

Too bad you don't want to disclose your identity, but i guess you have very good reasons to not do so, do you?

driller said...

Hi, thanks for your post.
I also had a problems like that. But I use Default value for initializing item values. It works for reports with partial page refresh turned off.
PPR reports does not see values set by Default value attribute if the sort link in the report's header is clicked? for example.

Byte64 said...

Driller,
i must say that i ignore if the sort settings make a difference in that case. What i can tell you is that recently i worked on a PPR report where i had problems with session state too and i decided to "hack" the built-in $a_report javascript function so that i could include items in the URL being generated, thereafter my problems were solved.

Flavio

yes you can!

Two great ways to help us out with a minimal effort. Click on the Google Plus +1 button above or...
We appreciate your support!

latest articles