Design Tools & Output Technologies - JDE1 (MOSC)

MOSC Banner

Report bursting and fix values in query - BIP on JD Edwards (8.12 or 9.0) 11.1.1.

Hi,

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",

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center