Securing Dialogs and refreshing underlying reports

I plan on using this blog as a way of noting down handy bits of code that you usually have to search for.

First post is refreshing an underlying report from a modal window.

So you have a modal window, see Eoghain's presentation about securing dialogs, but you want to update a record in the dialog window and then for the dialog to close and to refresh the underlying report.

Following a post from the Oracle forums all you do

Create a page item such as P1_SUBMIT which is hidden

Create a page process after reset of items that sets P1_SUBMIT

P1_SUBMIT := 1

Then create a Dynamic action which is conditioned on :P1_SUBMIT not being null, set the action to type Javascript with the following code


And that is it...

Remember and clear the cache when requesting the dialog page.