I have an item whose value is populated by a query that then is used to render a region title. The example below shows how we have it:
Item : P1_ITEM
Item source: Select value from table where id = p1_id
Source type: SQL Query (return single row)
Item type : hidden
Region title &P1_ITEM.
The issue is, upon initial login in (new session), the title is blank, and the value of the javascript expression for the item $v('P1_ITEM') is also blank. However, if you click away and return, it renders the value of P1_ITEM and appears in the region title. I've tried everything from submitting the item in a blank plsql dynamic action to creating a region with the lowest sequence so that item gets rendered first on the page , but to no avail.
Any ideas on how to fix this ?
Thank you!