BIP Bursting report fails
Summary:
Creating a report that will be emailed (bursting) to employees that have outstanding PCard charges that need to be added to a report for reconciliation.
The report generates the data just fine however my burst is failing to send. I'm not sure where the error is??
Error Msg = ORA-00923: FROM keyword not found where expected
Content (please ensure you mask any confidential information):
SELECT USERNAME AS KEY,
'Tronc_AP_Unattached_Card_Expenses_Email' AS TEMPLATE,
'en-US' AS LOCALE,
'pdf' AS OUTPUT_FORMAT,
'EMAIL' AS DEL_CHANNEL,
'Unattached_Expenses_' || TO_CHAR (SYSDATE, 'MMDDYY') AS OUTPUT_NAME,
pea_emp.email_address AS PARAMETER1,