OIC - How to schedule an Integration

 Scheduling an Integration in OIC also bit tricky, if you are working as a beginner. There are few limitations, as per Oracle mentioned, we cannot schedule integration within 10 minutes if you are using 

Click on 3 lines once you activated the Integration.

In the actions list, you can schedule, click on schedule.

Click on Edit button on the Top-right corner

You can select Simple or iCal option to schedule as per you requirement.

In Simple selection, you can schedule the integration to execute in frequency of below mentioned and showed in screen shot.

• Hours and Minutes
• Days
• Weeks
• Months

In Case of, you want to schedule other than the default options in Simple, you can select iCal option, where you can update Expression to schedule the integration. 

For Example: To schedule integration to execute in weekdays, 2 times a day. you can use below code.

FREQ=WEEKLY;BYDAY=MO,TU,WE,TH,FR;BYHOUR=2,14;BYMINUTE=30;

Usage commands:

INTERVAL

BYSECOND

BYMINUTE

BYHOUR

BYDAY

BYMONTHDAY

BYYEARDAY

BYWEEKNO

BYMONTH

BYSETPOS

WKST

enddate = date

enddate =/ date-time ;An UTC value

byseclist = seconds / ( seconds *(“,” seconds) )

seconds = 1DIGIT / 2DIGIT ;0 to 59

byminlist = minutes / ( minutes *(“,” minutes) )

minutes = 1DIGIT / 2DIGIT ;0 to 59

byhrlist = hour / ( hour *(“,” hour) )

hour = 1DIGIT / 2DIGIT ;0 to 23

bywdaylist = weekdaynum / ( weekdaynum *(“,” weekdaynum) )

weekdaynum = [([plus] ordwk / minus ordwk)] weekday

plus = “+”

minus = “-”

ordwk = 1DIGIT / 2DIGIT ;1 to 53

weekday = “SU” / “MO” / “TU” / “WE” / “TH” / “FR” / “SA”

Reference: https://docs.oracle.com/en/cloud/paas/integration-cloud/integrations-user/define-integration-schedule.html

Thanks,

Mady