How does user-defined flow schedules work?

When you schedule a flow, a flow instance is created. The application evaluates the flow parameters at the time of submission, and uses the task flow parameters when the flow is actually run or executed.

For example, if you have defined a monthly schedule, the Process Date will automatically increment 30 days from the value you have provided for the first instance of the flow.

However, if you need to define a date parameter to be set based on a defined value, you must define the value at the flow task level parameter.

For example, if you want to set the Process End Date to be 30 days after the Process Start Date, you must use an SQL to derive the Process End Date accordingly. For example, define the Process End Date as follows:

Parameter Basis: SQL Bind

Parameter Value: select PROCESS END DATE+30 from dual