Tuesday, 25 November 2025

Oracle Apex Classic Report Not Refreshing from Dynamic Action Dialog Closed

 I've had this issue previously where the data in a classic or Interactive report on the same page as a Form disappears after the data in the report is edited. After searching around for ages I finally found the issue and it's nothing to do with the report or the dynamic action!

If you have reports on a page that you want to refresh you need to ensure that the Session state of the Primary key of the form on the page is set to Per Session (Persistent) rather than Per Request (Memory).

Oracle Apex Classic Report Not Refreshing from Dynamic Action Dialog Closed
Oracle Apex Classic Report Not Refreshing from Dynamic Action Dialog Closed

Change this value and the dynamic action will now refresh the data in the report!

Oracle Apex Classic Report Data disappears from Dynamic Action Dialog Closed
Oracle Apex Classic Report Data disappears from Dynamic Action Dialog Closed

https://stackoverflow.com/questions/65327945/oracle-apex-20-interactive-report-not-showing-any-rows-on-refresh

No comments:

Post a Comment