Automating Date Parameter for "Update or Close Sales Orders" ESS Job

Summary:

Looking for guidance on setting the “Update or Close Sales Orders” ESS Job to automatically adjust its date parameter daily. The goal is for the job to close sales orders of the current day each night and then shift focus to the next day's orders without manual intervention. Seeking advice on enabling incremental date changes for this ESS Job to meet our business requirement of dynamically targeting daily sales orders.

Content (please ensure you mask any confidential information):

Hi Oracle Community,

I'm seeking advice on configuring the “Update or Close Sales Orders” ESS Job for a specific requirement. Our business needs this job to automatically adjust its operation based on the current day’s date. Essentially, if sales orders are loaded on February 19th, we want the job scheduled to run that night to close orders from February 19th. Then, automatically, on the next day, the job should update to focus on orders from February 20th, and so on.