Scheduling and JavaScript Custom Functions in Oracle Integration Cloud

 

Techniques for scheduling integrations, utilizing JavaScript libraries, and configuring email notifications within Oracle Integration Cloud (OIC).

 

 Integration Scheduling

Simple Scheduling:

Suitable for straightforward requirements where an integration runs on an hourly, daily, weekly, or monthly basis. There must be at least a 10-minute gap between consecutive runs.

iCal Scheduling:

Used for complex requirements, such as running an integration on specific dates, hours, or minutes. The minimum frequency for scheduling an integration in Oracle Integration (OIC) is one minute when using an iCal expression.

Configuration:

Users must define the frequency, interval, and specific timing parameters using iCal syntax. It is essential to include a semicolon at the end of the expression to ensure it validates correctly.

Advanced Features:

Users can specify a start date and an optional expiry date to stop the schedule. Additionally, OIC allows for the configuration of time zones.

 

 JavaScript Libraries

Custom Functions:

When standard functions are insufficient, users can create custom JavaScript functions to handle complex logic, such as calculating student rankings based on multiple attributes.

Implementation:

    1.  Write the logic and save the file with a ‘.js’ extension.

    2.  Import the file into the OIC library section.

    3.  Define input and output parameters within the integration mapper, where the custom function will appear under "user-defined" functions.

 

 Email Notifications

Purpose: Notifications are used to alert business or support teams regarding the success or failure of an integration.

Configuration:

       The "Notification" action allows for the specification of recipient email addresses (To, CC, BCC), a "From" email address, subject line, and the email body.

    Dynamic Data:

Values such as report IDs can be passed dynamically into the body or subject by using bracket syntax (e.g., ‘{variable}’) and mapping the corresponding parameter to the desired source value.

    Attachments:

To send file attachments, users must map a file reference to the attachment section within the notification configuration.

 

FAQ

1. What is the minimum time gap allowed between consecutive runs when using the "Simple" scheduling option?

• A) 1 minute
• B) 5 minutes
• C) 10 minutes
• D) 15 minutes

2. Which syntax or expression type is required for complex scheduling requirements, such as running an integration on specific days of the month at multiple specific times?

• A) Simple Expression
• B) iCal Expression
• C) JavaScript Function
• D) SQL Query

3. When using an iCal expression, what does the value "15" represent in the "by hour" field?

• A) 15:00 (3:00 p.m.)
• B) The 15th minute of every hour
• C) 15 minutes past the hour
• D) The 15th day of the month

4. True or False: In newer versions of the integration platform, users have the flexibility to change the time zone for a schedule.

• A) True
• B) False

5. Why would a developer use a JavaScript library in an integration?

• A) To schedule integrations more frequently
• B) To create custom functions when standard functions do not meet the requirement.
• C) To send automatic email notifications
• D) To connect to external databases

6. What file extension must be used when saving a JavaScript code file for import into the library?

• A) .txt
• B) .java
• C) .js
• D) .zip

7. Where can you find and use your custom-defined JavaScript functions within the integration designer?

• A) Under "Standard Functions"
• B) Under "User Defined" functions in the mapper
• C) In the "Schedule" menu
• D) In the "Notification" action

8. How can you pass a value, such as a Report ID, dynamically into the body of a notification email?

• A) Hardcode the value directly in the body
• B) Use brackets or flower brackets to define a parameter in the body and then map it in the parameters section
• C) Attach a separate text file containing the ID
• D) It is not possible to pass dynamic values in the body

9. What type of reference is required to send a file or image as an attachment in a notification?

• A) String reference
• B) File reference
• C) URL link
• D) Binary code

10. What are the minimum scheduling intervals supported in Oracle Integration Cloud for both the Simple and iCal expression modes?

A: The minimum interval for a Simple schedule is 10 minutes, while using an iCal expression allows for a more frequent minimum of 1 minute. Intervals shorter than 60 seconds are not supported by the OIC scheduler.