Apex 23.1 on 19.29
I've got a legacy page that I'm trying to edit.
It's got a static content section that is populated using a legacy ‘automatic row fetch’ that displays the parent table data. There are a bunch of interactive reports that show the content of various child tables dependant on characteristics of the parent.
I'm adding a new child table that can only have one row, so have added it as a form item, populated using a 'Form - initialization' that has a server side condition of ‘rows returned’ and a query to check if a row exists for ‘select * from child table where FK_column = :P705_CODE’.
When the parent is saved, the page is submitted and the interactive reports all refresh quite happily, ( all using queries of the form ‘select from child table where FK_column = :P705_CODE’ ). The new form region won't refresh until the page is submitted a 2nd time, seemingly because the condition is not being met (debug is showing it performing the server side check, and then not performing the data query)
I'm not understanding why the IRs are able to query using the :P705_CODE, but the condition for the form is failing.