Get Started: AI Resources for Oracle Cloud HCM – Go Here
Progress with Redwood: Redwood 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,
Tagged:
0