Oracle Application Express (MOSC)

MOSC Banner

Interactive Report Subscriptions not working - the SESSION_ID referenced is purged?

edited Sep 20, 2021 10:18AM in Oracle Application Express (MOSC) Question
We are trying to see if the Subscription option from an Interactive Report will give us what we want.

What we are seeing is that it works for a bit and then stops. We are trying to work out if this is something we're doing wrong or is there a flaw?

I am seeing that when I do this:

select application_id, page_id, report_name, session_id, owner, email_address, email_subject, start_date, notify_interval, status, created_on, created_by, last_updated_on, last_updated_by
from apex_application_page_ir_sub;

I see the subscriptions. I look at the SESSION_ID column in there. It seems to be the Session ID that initiated the first Subscription. I believe that when the Subscription is executed, that Session ID is duplicated for the IR Subscription to run - that'll preserve the session values I suppose - anything that might be used in the query (this is what we're testing!)

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center