Enable Scheduling of BI Publisher Jobs on First Business Day of the Month

Khushi

Currently, BI Publisher does not allow scheduling a recurring job to run on the first day or first business day of each month. This functionality is not working. As a workaround, we are required to create 12 separate schedules per year, which is inefficient and time-consuming.

Our ERP system requires monthly reporting jobs to run on a consistent schedule (e.g., first day or first business day of the month). The inability to set this up as a single recurring job increases administrative overhead and introduces risk of errors when manually creating multiple schedules.

Sandeep S. Chauhan-Oracle

Hi,

You can achieve it using a Schedule Trigger in the data model. Schedule the job and use schedule trigger SQL that returns a row only on the first business day; if no row is returned, the job instance is automatically skipped.
https://docs.oracle.com/en/cloud/saas/otbi/otbi-pub-user/define-schedule-job.html#GUID-A5AD3ACE-520E-4065-BD90-31AAB071A70F