Report bursting and fix values in query - BIP on JD Edwards (8.12 or 9.0) 11.1.1.
I am trying to write a report that bursts by address book number and is sent to my mail address. I am failing, because the SQL result is "unable to parse..."
I have tried many different syntax forms (from the documentation etc.), but none worked. Here two examples (AN8 is primary key of F0101):
select "F0101"."AN8" as "KEY",
'CustomerAR' as "TEMPLATE",
'de_DE' as "LOCALE",
'PDF' as "OUTPUT_FORMAT",
'true' as "SAVE_OUTPUT",
'EMAIL' as "DEL_CHANNEL",
'GREGORIAN' as "CALENDAR",
'OpenAR2 by Customer' as "OUTPUT_NAME",
'John.Doe@Oracle.com' as "PARAMETER1",
'SCHUFA@BMF.eu' as "PARAMETER3",
'Open Invoices' as "PARAMETER4",