You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

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,

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!