Skip to Main Content

APEX

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Clear cache for Report query using BI Publisher layout

Jeremy WebbApr 2 2019 — edited Apr 5 2019

Apex 18.1

Hi,

I have created a simple BI publisher layout and have loaded this into apex. I have defined two report queries which are used by the layout to display the required data. The queries reference a page item

which is an event_id field.

This works fine.

However, if the user selects to view different event, so the event_id page item is changed from the original, when I click the button to download the PDF, it still shows the original event_id value, not the newly selected one.

It is as if the event_id item is being cached and not getting the new one. The only way around this is to log out and log back in to the apex application, and then select the new event_id that is required.

Any ideas, how, either within the URL syntax that I am using for downloading the PDF, or modifying the report queries or report layout, how I can force it to use the new event_id page item rather than the "cached" version.

The URL is of the syntax: f?p=&APP_ID.:0:&SESSION.:PRINT_REPORT=EVENT

Any help would be appreciated.

Thanks,

Jeremy

This post has been answered by Jeremy Webb on Apr 5 2019
Jump to Answer
Comments
Post Details
Added on Apr 2 2019
1 comment
2,111 views