PeopleTools and Lifecycle Management - PSFT (MOSC)

MOSC Banner

Scheduled Query- to automatically update date to pull data for

edited Dec 16, 2024 9:13AM in PeopleTools and Lifecycle Management - PSFT (MOSC) 4 commentsAnswered

Hi

I have a scheduled query with a recurrence date of business day 1 to run every month.

This query should pull the prior month's data. For example, my queries run on Dec 2nd & I want it to pull all the data for the month of November. So each month I want the data to be pulled for the previous month on business day 1 automatically.

Currently, I have to remember to go in & update the date filter to pull the last most recent month. For ex. on Dec 2nd, I had to update my dates from 10/1/2024-10/31/2024 to 11/1/2024-11/30/2024, prior to the report being generated.

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center