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

Question

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

MandeepGupta · Answer

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.

Bhaskar Konar · Answer

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.