Hello,
I am using Apex 4.2.4
I have a saved report from an IRR and have created a subscription. The report shows several records but when the subscription is received it is blank. I checked the wwv_flow_worksheet_notify table and the following error is in the NOTIFY_ERROR column:
07/17/2014 10:00:00 ORA-20001: get_dbms_sql_cursor error ORA-00936: missing expression.
I retrieved the Reports' sql using the following query:
Select region_source
From apex_application_page_regions
Where source_type = 'Interactive Report'
And page_id = 31
And application_id = 123;
When I execute the query in the region_source, it works fine.
How can I find out what query the subscription is executing?
Thanks so much,
Becky