Oracle Communities

Oracle Analytics and AI

Child Item

Ability to run agent on last day of the month

Description

We have some OTBI reports that we want to schedule to run on the last day of the month but currently have to create 3 separate agents to cover this as last day of the month date varies

Use Case and Business Need

When scheduling an agent under monthly frequency you have the select the actual date rather than being able to choose last day of the month. Many of our reports need to be triggered on the last day of the month so having this option would streamline our processes as we are currently having to create 3 versions of each agent run at the end of month to cover each end date (28,30,31).

An ER has been raised through MOS - Bug 25636241

Original Idea Number: 4461efb6ac

Find more posts tagged with

Submitted

Status: Submitted

Comments

Aaron Johnson-40082

I agree that greater flexibility for scheduling agents would be appreciated. With the ability to schedule for the last Sun, Mon, Tue,...Sat of the week this is an odd oversight.

I am sure you have already considered this: We get around this by having reports run right as early as possible on the 1st. You have to account for data refreshes etc. but it works out well for us.

James Hoffmann

This would also be extremely helpful for my team.

I have a requirement where I need to run monthly HC reports on the last day of the month. If I set the agent to run on the 1st day of the next month, the numbers would be inaccurate as any employee who terminates on the 31st, for example, would no longer be counted in our month-end active HC number. They are technically active through 11:59 PM on the 31st though, so I definitely want to count them. Another issue with agents on the 1st of the month is they would include any new hire with a start date on the 1st (which I definitely do not want).

This also applies to analyses using the standard measures in workforce trend SA (such as "Workforce Trend"."Period End Active Headcount"). In order to make the numbers in my monthly HC reports match the pivots/graphs in my trend analysis, I need to count those last-day-of-period terms as active on the last day.

rob1604

HI,

We also have a requirement for this functionality. The option to choose 'Last Weekday' when scheduling actually exists, however it does not function as expected. It is interpreted as the last Friday of the month, which is incorrect.

Our client has many OTBI reports that need to be scheduled on the last day of the month,

Etta Laura

This appears to be the same idea as 33935. Adding link to consolidate votes to one idea.

https://community.oracle.com/customerconnect/discussion/33935/agent-last-day-of-month-option-within-schedule

Bhaskar Konar

Much needed feature. It'll add so much values and will be helpful to reduce the duplication of agents. Upvoted.