first day of previous month and last day previous month Schedule Report Job in oracle fusion

Ramesh A · Aug 20, 2025 2:32PM

I want to schedule a BI Report job - first day of previous month and last day previous month Schedule Report Job in oracle fusion

using : {$FIRST_DAY_OF_MONTH()$}
{$LAST_DAY_OF_MONTH()$}

For example :

i am scheduling on 1st AUG - need to schedule dynamically every month ( 1st day)

From date : 01-JUL

To Date : 31-JUL-25

Bhaskar Konar · Aug 20, 2025 4:03PM

https://community.oracle.com/products/oracleanalytics/discussion/26811/first-day-of-previous-month-and-last-day-previous-month-schedule-report-job-in-oracle-fusion

Hi @Ramesh A,

Welcome to the Oracle Analytics Community!

Please take a look into the following Oracle Note which might be useful for the initial starting point and the understanding.

https://support.oracle.com/knowledge/Oracle%20Cloud/2052711_1.html

Thank you.

MandeepGupta · Aug 22, 2025 7:27AM

https://community.oracle.com/products/oracleanalytics/discussion/26811/first-day-of-previous-month-and-last-day-previous-month-schedule-report-job-in-oracle-fusion

Hi Ramesh,

Welcome to Oracle Analytics community.

Can you please clarify if you want to dynamically pass the values of date parameters to first of the previous month and last day of the previous month or it is about scheduling?

Thanks.

Oracle Analytics Publisher

Categories

first day of previous month and last day previous month Schedule Report Job in oracle fusion

Answers