I have upgraded from version 3.0.1 to version 4.0.1 and I am having an issue.
I have a page with a tabular form (SQL Query - updateable report) which allows me
to select items I want to print.
The report looks like the following:
Name Print
---- -----
Template 1 Y/N
Template 2 Y/N
Template 3 Y/N
Template 4 Y/N
The print column is a static LOV with a 'Y' or 'N' option.
When I submit the page, a MRU runs and sets a flag for each item I want to print in the database.
It then branches using "Branch to URL Identified by Item (Use Item Name)". The URL specifies an Oracle report
server and the oracle report to print.
All this works fine and the items that were selected, print out. An Oracle Reports Job Status is displayed
on screen (this originates from the oracle report server) to indicate that it has "successfully run" along with
an OK button. The OK button contains the following code: javascript:history.back()
A process also exists on the page ("On Load - Before Regions") that resets any flags that were set in the database
when the page is loaded and so the report will displays all N's in the Print column.
Now my problem is that in version 3.0.1 when I hit the OK button it would return to the page in the apex
application that branched to the oracle report and the page would be reloaded, where as in version 4.0.1
the page is not reloaded.
Any ideas how to fix this or can someone suggest a new way of achieving the same result.
Any help would be appreciated.
Regards,
Ryan