Session user for bursting BIP report
Summary
Session user for bursting BIP reportContent
How can i burst BIP report to the session user ( the user that run the BIP report ) ?
what parameter i should add after the : ?
select
cust_acct.cust_account_id as "KEY",
'Customer Statement Printout' TEMPLATE,
'RTF' TEMPLATE_FORMAT,
'PDF' OUTPUT_FORMAT,
'EMAIL' DEL_CHANNEL,
hp.party_name output_name,
(select pea.email_address from per_users peu, per_email_addresses_v pea where 1 = 1 and peu.person_id = pea.person_id and peu.username = : ) PARAMETER1,
null PARAMETER2,
'My Company' || '<' || '[email protected]' || '>' PARAMETER3,
'Customer Statement' PARAMETER4,
'Dear Customer, Please find the attached customer statement' PARAMETER5,
Tagged:
0