Tips & Tricks for Oracle Integration 2 (OIC 2)

Learn to implement out-of-the-box retry logic in Oracle integration by configuring a retry count, using variables and a while loop to retry failed API calls up to three times.

Create a rest over https integration in Oracle integration (OIC 2), exposing multiple resources and verbs such as get and post, with trigger setup, mapping, and testing.

Learn to convert a scheduled integration into an app driven rest trigger, configure a rest trigger connection, map inputs and outputs, and test and activate the new rest exposed workflow.

Configure a rest connection in Oracle integration using the auth custom two-legged flow, building the access token request and optional refresh token handling with Microsoft Graph as an example.

Configure a REST connection in Oracle integration using OAuth custom three-legged token-based authentication, covering authorization, access and refresh tokens, consent, and testing with Microsoft Graph email.

Learn to use the for each function in the mapper with XSLT to iterate student lists, mapping name and class via the user interface or code, with validation.

Learn to group and filter data in xslt using for-each and for-each-group, including how to apply group by with single or multiple fields and handle duplicates in an integration mapper.

Learn to convert datetimes between time zones in integration mapper using the adjust date time to timezone function with xsd date time duration, featuring India, UAE, Bahamas, daylight saving time.

Learn how to apply XPath functions in JavaScript libraries within Oracle Integration, decode base64 data, update and map a JavaScript function, and test an integration end-to-end.

Package a JavaScript function into a jar file to create a library for Oracle integration, then import the jar and encrypt a message with a secret key using crypto js.

Schedule a wrapper procedure to call long running stored procedures asynchronously. Use DBMS_SCHEDULER to fire and forget the main procedure, preventing integration timeouts beyond four minutes.

Overcome the ten MB limit of database adapters by using offset and fetch first to read large data in batches, implemented via stored procedures and iterative offsets.

Generate the authorized shared key for Azure storage using JavaScript in Oracle integration, building a signed request with HMAC-SHA256, canonicalized headers, and the UTC date.

Learn to send WhatsApp and SMS messages from Oracle Integration Cloud using the Twilio adapter, with connection setup, mode configuration, and from-to-body mappings and testing.

Navigate to Oracle BI Publisher in Fusion or Oracle SaaS by logging in, expanding the left navigation, and selecting reports and analytics to browse the catalog.

Create a data model and a BI Publisher report in Oracle, using shared and custom folders, and invoke reports via a SOAP web service.

Create a report from the saved data model by clicking create report, selecting the learn_site_users_xdm data model, choosing a table layout, and saving it to the learn_bip_site_users_zero_one path.

Build Oracle integration to invoke a BI publisher VIP report, fetch CSV, and process data by writing base64 to a stage file and reading CSV in a scheduled orchestration.

Learn the manual FBDI import of suppliers in Oracle Fusion Cloud, using the file-based data import approach, Excel template, batch IDs, and load interface and import suppliers processes.

Build a scheduled Oracle integration to perform FBDI bulk import of suppliers into Fusion using FTP, ERP cloud, and zip-based CSV and properties files, with callback and mapping.

Create a callback integration in Oracle Integration Cloud to trigger on Fusion ESS job completion, write logs to an FTP directory, and map the job reference for archive.