On Oracle SOA Suite 220.127.116.11.0, when we tried to create an error notification rule to alert on failed ESS scheduled jobs, we experienced an issue where the dropdown was not showing any schedules. Unfortunately, the solution to apply patch 26088894 does not work.
Patch 26088894 is a zero downtime ESS patch and applicable for Oracle SOA Suite versions 12.1.3, 12.2.1, 18.104.22.168, and 22.214.171.124.
It addresses the issue of the Adapter Schedule generating a Null Error on the GUI, which may appear to be the issue we experienced, but it is not.
Problem: Error Notification Rule Issue
- Log in to the EM Console
- Navigate to Scheduling Services > Job Request > Define Schedules
- Create a schedule called "Ahmed_Job_10Minutes"
- Navigate to SOA > soa-infra (soa_server1) > SOA Infrastructure > Error Notification Rules
- Click on Create
When trying to create an error notification rule, you can see that the Schedule dropdown box is empty, preventing us from being able to create a rule.
Solution: Define the Proper Schedule Package
When creating the job schedule, it must be in the package /oracle/apps/ess/custom/soa. See screenshot below. That's it!
Only schedules in package /oracle/apps/ess/custom/soa of application EssNativeHostingApp can be used for creating error notification rules.