Oracle Fusion Technical - Oracle Integration Cloud OIC Gen2

Explore cloud computing and the three service models IaaS, PaaS, and SaaS, along with public, private, and hybrid deployments, and Oracle's integrated cloud offerings.

Explore the Oracle integration cloud tool, its home page, tasks, processes, integrations, business-to-business documents, visual builder, insight, and monitoring, and learn to create connections and monitor health.

Explore the six integration patterns in OIC: app driven orchestration, scheduled orchestration, file transfer, basic routing, publish to topic, and subscribe to topic.

Build a hello world soap web service in Oracle Integration Cloud OIC Gen2 using a soap trigger endpoint that takes a name input and transforms the request to 'Hello, <name>'.

Create a hello world soap trigger connection, upload the wsdl, define input name and greeting response, apply basic authentication, test and save to configure the soap connection.

Develop and test a hello world soap service in Oracle Integration Cloud, mapping hello before the name, configuring tracking, enabling tracing with payload, and validating via SoapUI.

Explore rest API concepts in Oracle Fusion Cloud ERP, including http verbs and json or xml data formats, and locate rest APIs for expenses, journals, and payables.

Build a hello world rest api with Oracle Integration Cloud Gen2 by configuring a rest trigger, creating a rest connection, and returning a greeting like Hello Raja.

Learn to configure a rest connection in Oracle Integration Cloud Gen2 by setting the role to trigger, choosing basic authentication for the rest endpoint, testing the connection, and saving.

Develop and test a rest integration in OIC Gen2 by creating an app-driven orchestration, configuring a rest trigger, mapping a greeting template, and validating with tests and tracing.

Develop and test a rest integration in OIC Gen2 by converting a template parameter to a query parameter, updating the endpoint, validating with postman, and activating with trace enabled.

Automate bulk data imports in Oracle ERP Cloud using importBulkData with SOAP UI and REST API, uploading base64-encoded load interface files, submitting import jobs, and tracking status.

Create a dot properties file to drive FBDI data imports in Oracle Fusion. Configure job package name, job name, and zip prefix for journals and invoices.

Develop a scheduled orchestration to import journals in bulk using inbound api with Oracle ERP Cloud Connection, reading from ftp and importing into Oracle Fusion SaaS, with a callback integration.

Configure Oracle ERP Cloud adapter in Oracle Integration Cloud Gen2 by creating a connection, selecting Oracle ERP Cloud, naming it, setting trigger and invoke roles with username password token, testing.

Configure an ftp connection in Oracle Integration Cloud Gen2 by selecting the ftp adapter, set host and port 22, choose public key authentication, test, and save.

Create an inbound API integration to import journals into Oracle Fusion ERP Cloud, defining and assigning variables within a scheduled orchestration.

Configure an ftp connection to list files from the input directory, set maximum files and minimum age, enable list files recursively, and map the source file path.

Learn to use a for-each loop to read ftp files, convert them to a csv for FBDI, and map fields for journal entry upload in Oracle Integration Cloud Gen2.

Create and map a properties file in Oracle Fusion Technical on OIC Gen2, specifying the file name and output path, then run a test to validate the mapping.

Zip a csv and properties file in staging area using a stage file activity and the zip files operation, specifying the file name, directory to zip, and the output directory.

Learn how to create an Oracle Cloud ERP connection to import journals using a dynamic properties file, map file references, and configure email and bell notifications with callback.

Archive the source file in Oracle integration cloud by creating an ftp connection, configuring a move operation with source and target paths, and mapping file name from the list files.

Activate and test the integration on an ad hoc basis, upload input files to the ftp server, and monitor submission, import journals, and archive status through Oracle Fusion Applications.

Create an event-based app-driven orchestration in Oracle integration cloud to implement import journals callback, using ERP cloud and FTP connections, and download outputs or zipped summaries based on job status.

Develop Callback Integration in Oracle Integration Cloud Gen2 using an if flow to compare import journals child job status and, when succeeded, invoke ERP Cloud adapter to download execution details.

Define an else flow to handle error or warning statuses by extracting the callback XML, staging a log file, zipping it, and transferring it to an FTP server.

Test callback integration in Oracle Integration Cloud Gen2 by uploading files to the input directory, submitting jobs, and verifying successful callbacks and outputs in universal content management.

Explore how the connectivity agent acts as a gateway to on-premises systems with Oracle Integration Cloud via a pull, ssl, and 443 port, using heartbeat and design-time and runtime workflows.

Install and configure the connectivity agent for Oracle Integration Cloud Gen2 by creating an agent group, downloading and extracting the agent, and configuring the installer with OIC URL and credentials.

Create suppliers in Oracle Fusion Cloud via a SOAP web service using soap UI. Configure roles and privileges, use the WSDL, authenticate requests, and verify the supplier in procurement.

Import suppliers into Fusion using the soap services catalog of Oracle Cloud ERP Connection, and drive an app-driven orchestration that pulls a file and inserts data into a database.

Create a file connection to a local file system behind a firewall using an agent, configure an agent group, test the connection, and save the configuration.

Configure an Oracle database connection in OIC for on premise databases behind the firewall by using an agent, entering localhost and port details, testing the connection, and saving the configuration.

Import suppliers into Fusion via Oracle Cloud ERP soap catalog, reading supplier data CSV, mapping to supplier service, and recording import status in the system schema's sub status table.

Enhance the Oracle Fusion journal import inbound integration by using a soap connection to fetch ledger and data access set ids via the run report operation, replacing hardcoded values.

Build a business intelligence report to fetch data access set id and ledger id by passing data access set name and ledger name, removing hard coding and enabling dynamic replacement.

Configure a soap connection to invoke the fusion report service in Oracle Integration Cloud Gen2, provide the WSDL URL and basic authentication credentials, and verify the test passes.

Activate and monitor Oracle Fusion integrations in OIC Gen2. Fix mappings, enable tracing, and extract Fusion report output via a soap connection with base64 payload and IDs.