OIC - How to Skip OIC Schedule During Public Holidays

Skipping OIC Schedule During Public Holidays

Use Case:

In Oracle Integration Cloud (OIC), scheduled integrations run at predefined intervals. However, organizations may need to prevent these jobs from executing on public holidays to optimize resources and avoid unnecessary processing.

Example Scenario

A company has a daily OIC integration that syncs employee attendance data from an external system to Oracle HCM. Since no employees work on public holidays, the integration should be skipped on those days.

Solution Approach: Using an OIC Lookup Table

Steps to Implement:

1. Create a Lookup Table in OIC:

   • Go to Lookups in OIC and create a new lookup table.
   • Define two columns: HolidayDate and Flag
   • Populate the lookup with public holidays for the year.

2. Modify the Scheduled Integration:

   • Retrieve the current date in the integration.
   • Check the lookup table to see if today’s date exists.
   • If today is a holiday:
     • Log a message: "Skipping execution due to public holiday."
     • Exit the integration.
   • If today is not a holiday, proceed with execution.

3. Update the Lookup Table Annually:

   • At the start of each year, update the lookup table with the new list of public holidays.

Detailed screenshots:

If there is a need to run the integration ad hoc on a public holiday in certain cases, we can introduce a schedule parameter IsReprocess. If IsReprocess is set to "Y", the integration will run regardless of the holiday. Otherwise, it will check the lookup table and skip execution if today is a public holiday.

Conclusion

By using an OIC lookup table, scheduled integrations can dynamically check for public holidays and skip execution when necessary. This approach ensures efficient resource utilization and prevents unnecessary API calls.