In legacy versions of Oracle Utilities Customer Care And Billing, there was a Workflow based batch scheduler made available. The scope of that implemented was very limited to be able to execute a chain of batch jobs. It was implemented to aid customers migrating from the PeopleSoft CIS product to the Oracle Utilities Customer Care And Billing product.
With the introduction of Outbound Messages and the Oracle Scheduler the use of both workflow and the workflow based scheduler have been declining. It is recommended to customers who continue to use the workflow scheduler migrate to the Oracle Scheduler as it has the following advantages:
- Broader Scope. The Oracle Scheduler can be used with all Oracle Utilities Application Framework. The workflow scheduler only supported Oracle Utilities Customer Care And Billing. The Oracle Scheduler also supports local or remote invocation from a wide set of technology which means it can be used for third party application scheduling as well.
- Local and Enterprise Wide implementation. The Oracle Scheduler can be attached to the Oracle Utilities Application Framework based product or the Oracle Utilities Application Framework product can be just one of the application using the scheduler. This means the Oracle Scheduler can be used locally for an application or be shared globally for enterprise deployments (it requires an additional agent installation which is part of the Oracle Client installation to be used remotely).
- Robust. The Oracle Scheduler is part of all editions of the Oracle Database and is used across many Oracle products including Oracle Database, Oracle Enterprise Manager etc..
- Cloud Friendly. The Oracle Scheduler is automatically deployed inside the Oracle Utilities SaaS Cloud Services as the main scheduler. Schedule maintenance is provided via REST API or via the Oracle Utilities Cloud Services Foundation that is supplied exclusively with Oracle Utilities SaaS Cloud Services. The workflow scheduler is not supported on the Oracle Utilities SaaS Cloud Services.
- Extensive Calendaring Support. The Oracle Scheduler uses a extensive calendaring syntax to allow flexible scheduling of work. This supports the time zone and daylight savings capability built into the database.
- Broad Management Capabilities. The management of the schedule within Oracle Scheduler can be performed via the command line, Oracle SQL Developer and/or Oracle Enterprise Manager. In the Oracle Utilities SaaS Cloud Services, the schedule can be maintained via the Oracle Utilities Cloud Service Foundation.
For more information about the Oracle Scheduler refer to Oracle Scheduler Concepts and Batch Scheduler Integration (Doc Id: 2196486.1) available from My Oracle Support.