' oicbasics: How to schedule OIC integration and iCal Expression
March 1, 2020

How to schedule OIC integration and iCal Expression



USE CASE I: [BASIC TYPE] Schedule the integration for every 10 minutes. For this type there is minimum frequency limit of 10 minutes. If you try to define a schedule frequency of under 10 minutes, a validation error occurs. Use iCal to schedule the integration below 10 minutes.

USE CASE II: [ADVANCE TYPE] Schedule the frequency for every 5 minutes using iCal expression. 


- Advertisement -




Lets see the steps in detail :

CASE I :
Step 1 : Activate the scheduled integration and then click on the hamburger 
             sign. Select Add Schedule.


Knowledge :  👀 
App Driven Orchestration ? : It enables you to create an integration that uses an event or business object to trigger the integration. In laymen's terms  - you have to pass some inputs to trigger the app driven orchestration integrations.

Scheduled Orchestration ? : It enables you to create an integration that uses a schedule to
trigger the integration instead of an adapter. After designing such integration, you can schedule when to run it.

- Advertisement -



Step 2 : click Add Schedule


Step 3 : Now set the frequency by clicking on Only once


Step 4 : Select Hours and Minutes because our requirement is to submit the 
             Integration in every 10 minutes.


              Note : you can select other option(Days, Weeks etc.) as per your requirement.


- Advertisement -



Step 5 : Enter 10 in minutes box.


Step 6 : Click Save and then click Close.



- Advertisement -



Step 7 : Click Start Schedule.

                  
            Click Start. 


Done. Your integration is scheduled for every 10 minutes. Now close the scheduling window. Integration will automatically get submitted in every 10 minutes interval of time.




- Advertisement -


CASE II :

Step 1 :  After step 2 in case I, select TYPE : ADVANCED


Step 2 : Enter below iCal Expression to schedule the integration for 5 every
             5 minutes interval of time.


                                    FREQ=MINUTELY;INTERVAL=5;
       
              Click Validate Expression.


Knowledge :  👀 

FREQ=MONTHLY;BYMONTHDAY=1,10,15;BYHOUR=5,10,15,20;BYMINUTE=15;

The following expression indicates that this integration runs each month on the 1st, 10th, and 15th days of the month at 5:15 AM,10:15 AM, 3:15 PM , and 8:15 PM.

- Advertisement -


 Step 3 : Click Start Schedule

                 
             Click Start.


Done. Your integration is scheduled for every 5 minutes. Now close the scheduling window. Integration will automatically get submitted in every 5 minutes interval of time.






- Advertisement -



Thank you ! 😊




31 comments:

  1. Thanks for the details, do you have any sample to exclude a particular day from the daily schedule? Thanks in advance.

    ReplyDelete
    Replies
    1. Vino, I have to check , will update you.

      Delete
    2. Hi Vino, Oracle team has confirmed that as of now here is no iCal expression which will prevent integration from running on specific dates.

      Delete
    3. FREQ=MONTHLY;BYMONTHDAY=10,25;INTERVAL=1;
      All you have to do is change the values and specify the dates you want to run the schedule.

      Delete
    4. Hi Unknown , we need expression to exclude a specific day from daily scheduler (example 15th August, 26 Jan etc). What you are suggesting is already discussed and it's not practical. Requesting you to please cross check and share practical solution :)

      Delete
  2. Can we schedule a job in OIC such that the job runs every hour only from 9:00 AM to 6:00 PM. It doesn't run for the entire day.

    ReplyDelete
    Replies
    1. Dear you can try below one & please let me is it working or not :)

      FREQ=DAILY;BYHOUR=9,10,11,12,13,14,15,16,17,18;

      Delete
  3. i have cloned an integration which has a schedule how to remove that schedule

    ReplyDelete
    Replies
    1. Please check below article :

      https://www.oicbasics.com/2021/07/delete-schedule-in-oic-scheduled.html

      Delete
  4. I need to schedule an integration for first working day of every month. How to do this?

    ReplyDelete
    Replies
    1. there is a limitation of iCal expression, i think you can't achieve your requirement using iCal expression. Please connect oracle support

      Delete
    2. Hi Kabir,

      https://stackoverflow.com/questions/18101167/can-ical-schedule-an-event-for-the-first-weekday-after-bymonthday-if-bymonthday

      i think this would help ....

      Delete
  5. Hi, Is there anyway to pass some date parameters as input to Scheduler in OIC ? For Example, send previous day's date as input when the scheduler runs.

    Thanks
    Srikar Sreeram

    ReplyDelete
    Replies
    1. Yes Sreeram, you can pass Inputs as 'Schedule Parameters' in a Schedule Integration.

      Please note currently I don't have any article related to it. Tomorrow I will share it with you 🙂

      Delete
  6. integration does not run an particular period of time by using ical expression like for example...integration doesnot run on month jan1,march4,and aug10

    ReplyDelete
  7. Hi
    I have an requirement, integration does not run on specific days plz help

    Thank you.

    ReplyDelete
    Replies
    1. with iCal expression you can't exclude dates.

      Delete
    2. but I can suggest you one solution for your requirement : Just Store holiday list in a DB table or OIC lookup. If Interface Run date = Holiday date then stop the interface at the start.

      Delete
  8. Thanks for the post!
    I am looking for how to develop custom adapters for OIC.
    Do you get that info?

    ReplyDelete
  9. Please let me know how to submit OIC integration for multiple parameters and multiple Times.
    Ex: Parameter: C01, Time : 2PM, 3.30PM, 7.45PM
    Parameter: C02 ,Time : 8PM, 11.45PM.
    Currently we are achieving with wrapper integrations which is not appropriate.

    ReplyDelete
  10. Can we schedule a job in OIC integration such that the job runs every day but not from 12:00 am to 8:00 am on Sunday?

    ReplyDelete
    Replies
    1. query answered through the email. Please check

      Delete
  11. If yes please tell how to write the ical expression

    ReplyDelete
  12. how to schedule a App Driven Orchestration integration.

    ReplyDelete
  13. Can we schedule OIC integration such that the job runs every day on hourly basis but skip Sunday 9 am to 6 pm?

    ReplyDelete

If you have any doubts, Please let me know.

Top