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 ! 😊
Thanks for sharing
ReplyDeleteWelcome Shelja :)
DeleteThanks for the details, do you have any sample to exclude a particular day from the daily schedule? Thanks in advance.
ReplyDeleteVino, I have to check , will update you.
DeleteHi Vino, Oracle team has confirmed that as of now here is no iCal expression which will prevent integration from running on specific dates.
DeleteFREQ=MONTHLY;BYMONTHDAY=10,25;INTERVAL=1;
DeleteAll you have to do is change the values and specify the dates you want to run the schedule.
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 :)
DeleteCan 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.
ReplyDeleteDear you can try below one & please let me is it working or not :)
DeleteFREQ=DAILY;BYHOUR=9,10,11,12,13,14,15,16,17,18;
it is working. You can use it
Deletei have cloned an integration which has a schedule how to remove that schedule
ReplyDeletePlease check below article :
Deletehttps://www.oicbasics.com/2021/07/delete-schedule-in-oic-scheduled.html
I need to schedule an integration for first working day of every month. How to do this?
ReplyDeletethere is a limitation of iCal expression, i think you can't achieve your requirement using iCal expression. Please connect oracle support
DeleteHi Kabir,
Deletehttps://stackoverflow.com/questions/18101167/can-ical-schedule-an-event-for-the-first-weekday-after-bymonthday-if-bymonthday
i think this would help ....
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.
ReplyDeleteThanks
Srikar Sreeram
Yes Sreeram, you can pass Inputs as 'Schedule Parameters' in a Schedule Integration.
DeletePlease note currently I don't have any article related to it. Tomorrow I will share it with you 🙂
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
ReplyDeleteHi
ReplyDeleteI have an requirement, integration does not run on specific days plz help
Thank you.
with iCal expression you can't exclude dates.
Deletebut 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.
DeleteThanks for the post!
ReplyDeleteI am looking for how to develop custom adapters for OIC.
Do you get that info?
Please let me know how to submit OIC integration for multiple parameters and multiple Times.
ReplyDeleteEx: 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.
I don't know about it
DeleteSure Kabir.
ReplyDeleteCan 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?
ReplyDeletequery answered through the email. Please check
DeleteIf yes please tell how to write the ical expression
ReplyDeletehow to schedule a App Driven Orchestration integration.
ReplyDeletetrigger it from a schedule integration
DeleteCan we schedule OIC integration such that the job runs every day on hourly basis but skip Sunday 9 am to 6 pm?
ReplyDeleteHi Kabir, Is there any way or ical expression to schedule the integration on public holiday?
ReplyDeleteI think you can use iCal ....
DeleteIf you have the list of public holiday days available, you can try below expression :
FREQ=MONTHLY;BYMONTHDAY=10,25;
All you have to do is change the values and specify the public holiday dates you want to run the schedule.
With the help of Appdervien orchestration, can we change the scheduled timings for the scheduled integration.
ReplyDeleteHi Kabir sir
ReplyDelete.what is the difference between soap mapper level hardcoded the 'sizeOfDataChunkDownload' '-1' and '0' what is the main difference between these two?
.how do get more than 10mb data from fusion?
is this question related to this article ? no right ? better Anonymous SIR asked the question related with the article, don't just dump question SIR :)
DeleteHi kabir, can you please help on this requirement
ReplyDeleteIntegration should run every 12 days of a month and every Sunday, Integration should not run on Saturday.
I don't think iCal can handle this. You can connect oracle support for iCal expression.
DeleteBut we can do some workaround to achieve this, using some logic, please text me here 'thekabiryadav@outlook.com' . Will connect.