Oracle Integration allows you to create a planned integration that runs at a predetermined interval, such as once a day, twice a day, once a week, and so on. On occasion, a third-party program may be required to perform OIC scheduled integration in response to a certain event.
There are two ways to schedule OIC Integration
- Basic Type
- Advanced Type
Basic Type: Every 10 minutes, schedule the integration. A minimum frequency constraint of 10 minutes applies to this type. A validation error occurs when you try to set a schedule frequency of less than 10 minutes. To keep the integration time under 10 minutes, use iCal.
Advanced Type: Using an iCal expression, set the frequency to every 5 minutes
Steps to schedule OIC Integration using Basic Type
(1) After you’ve activated the scheduled integration, click the hamburger sign. Select the Add Schedule option.
(2) Add a Schedule by clicking the button
(3) By clicking on ‘Basic’ and ‘Only once’, you may now adjust the frequency.
(4) choose ‘Hours and Minutes’, Because we need to submit the Integration every 10 minutes
(5) In the minutes box, type 10.
(6) After that, click Save and then Close.
(7) Click on ‘Start Schedule’ button.
(8) Your integration will run every ten minutes. Close the schedule window at this point. Every 10 minutes, the integration will be submitted automatically.
Steps to schedule OIC Integration using Advanced Type
(1) After you’ve activated the scheduled integration, click the hamburger sign. Select the Add Schedule option.
(2) Add a Schedule by clicking the button
(3) By clicking on ‘Advanced’ , you may now adjust the frequency.
(4) To schedule the integration for every 5 minutes, enter the iCal Expression ‘FREQ=MINUTELY;INTERVAL=5;’
(5) Click on Start Schedule button
(6) Every 5 minutes, your integration will run. Close the schedule window at this point. Every 5 minutes, the integration will be submitted automatically.