BI Publisher (MOSC)

MOSC Banner

Cannot do Bursting with FILE (DEV_CHANNEL)

edited Oct 27, 2017 1:36AM in BI Publisher (MOSC) 6 commentsAnswered

I want to do bursting with FILE (DEV_CHANNEL) so that i can store the report at my Laptop. 

But when i do it, it's not working.

Here are my SQL :

select

"HZ_PARTIES"."PARTY_NAME" as "KEY",

'PDF' as OUTPUT_FORMAT,

'FILE' as DEL_CHANNEL,

'C:/Users/LENOVO/Desktop/' as PARAMETER1,

'AP_' || "HZ_PARTIES"."PARTY_NAME" || '.PDF' as PARAMETER2

from

"FUSION"."HZ_PARTIES" "HZ_PARTIES",

"FUSION"."POZ_SUPPLIERS" "POZ_SUPPLIERS",

"FUSION"."AP_INVOICES_ALL" "AP_INVOICES_ALL"

where  

"AP_INVOICES_ALL"."VENDOR_ID"="POZ_SUPPLIERS"."VENDOR_ID"

and "POZ_SUPPLIERS"."PARTY_ID"="HZ_PARTIES"."PARTY_ID"

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