This content has been marked as final. Show 6 replies
Sanjay / Toby,
Does your Interactive report query use item value in the where clause by any chance? The reason I ask is because if Interactive report result depends on a APEX item value for the session, the subscription will not send any result as it runs in the background and not within APEX environment.
i have a smilar problem with Email subscriptions, i don't use items, but i use collections in the where clause!
select * from PUMA_MMRDB_GSM_LB a
when (select C001 from APEX_COLLECTIONS where COLLECTION_NAME = 'TMP_SELECTION') = 'BRD' then 1
when (select C001 from APEX_COLLECTIONS where COLLECTION_NAME = 'TMP_SELECTION') = 'REGION' and (a.Region in (select C001 FROM APEX_COLLECTIONS WHERE COLLECTION_NAME = 'REGION_M')) then 1
when (select C001 from APEX_COLLECTIONS where COLLECTION_NAME = 'TMP_SELECTION') = 'NL' and (a.NL in (select C001 FROM APEX_COLLECTIONS WHERE COLLECTION_NAME = 'NLK')) then 1
end = 1
Sometimes i see the Errror ORA-01722 in the 'error message' field of the apex_application_page_ir_sub view. I don't know if this related to the above.
Can you point me in the right direction?
The collections are session based as well. Interactive report subscription does not work on session based values as it runs in the background outside of APEX. The query needs reference table or view with where clause that does not depend on collection for subscription to work.