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
Get Started: AI Resources for Oracle Cloud HCM – Go Here

Progress with Redwood: Redwood Resources for Oracle Cloud HCM -  Go Here

Unable to get data for Bursting even if no Bursting Parameters passed

I am using below query.
Requirement is to send email notification when :Mode of Report='Email' and this is working fine.
If the :Mode of Report='Print' , the report should just display output without sending notifications after scheduling the report.

Query:
WITH
Bursting AS
(
SELECT sales.SALESREP_NUMBER ,
papf.person_id ,
ppnf.FIRST_NAME||' '||ppnf.last_NAME salesperson,
pea.email_address salesperson_email,
rct.trx_number,
to_char(aps.due_date,'dd-mm-yyyy')due_date,
rct.invoice_currency_code,

to_char(rct.trx_date,'DD-MON-YY')invoice_date,
hp.party_name cust_name,
hp.party_number cust_numb,
hcu.location cust_site,

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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