Oracle Fusion Integration Cloud Services Training

Module 6: Build First REST API in OIC – App Driven Orchestration Style

• Build the API
• Enable Tracking on the API
• Activate the API
• Test the API & Monitor the request

Module 7: Build First SOAP Service in OIC – App Driven Orchestration Style

• Build the SOAP Service
• Enable Tracking on the SOAP Service
• Activate the Service
• Test the SOAP Service & Monitor the request

Module 8: Build Complex File Transfer Service – File Transfer Style

• Understand FTP Adapter Capabilities
• Demo on PGP Encryption
• Build File Transfer Service to move files using FTP adapter
• Demo Basic and Advanced Scheduling Options
• Activate, Schedule, Test and Monitor the Integration runs

Module 9: Build Complex Journal Import Service – App Driven Orchestration Style

• Use Case – Import Journals in ERP Cloud using web services approach
• Build complex integration with App Driven Orchestration style
• Perform complex transformations in Integration
• Use Scope, Loops and Notifications in OIC
• Use Fault Handling Mechanism & Notifications
• Activate, Test and Monitor the Integration runs

Module 10: Build Complex AR Invoice REST API – App Driven Orchestration Style

• Use Case – Build REST API with multiple Endpoints to Import AR Invoices in ERP Cloud
• Expose GET endpoint to fetch AR Invoice Details from ERP Cloud
• Expose POST endpoint to create AR Invoice in ERP Cloud
• Understand how to invoke seeded REST APIs using ERP Adapter

Module 11: FBDI Automation Service – Scheduled Orchestration Style

• Use Case – Automate the load of GL Daily rates in ERP Cloud using FBDI approach
• Build FBDI automation integration using scheduled orchestration style
• Kick off bulk import in ERP Cloud to import data in cloud
• Build Callback Integration to feedback user and to download log/output files from ERP Cloud
• Activate, Test and Monitor the Integration runs

Module 12: Publish to OIC Service

• Build Publish to OIC Service which subscribes to SaaS business event
• Publishes message to OIC Pub/Sub Channel
• Activate, Test and Monitor the Publish to OIC Service

Module 13: Subscribe to OIC Service

• Build Subscribe to OIC Service to subscribe to message in OIC Pub/Sub Channel
• Prepare file with details and move it to FTP
• Activate, Test and Monitor the Integration runs

Module 14: SaaS to On Premise Service with Connectivity Agent

• Use Case – Item updates in ERP Cloud should be synced automatically to On Premise database
• Introduce Agent Group concept in OIC
• Establish connectivity between SaaS cloud and On Premise using an agent
• Build Integration to push item updates from ERP Cloud to On Premise database
• Activate, Test and Monitor the Integration runs

Module 15: HCM Data Loader Automation Service

• Use Case – Automate the data load to HCM Cloud using HCM Data Loader
• Build HCM DL automation integration using scheduled orchestration style
• Feed status back to user based on HCM DL Completion status in HCM Cloud
• Activate, Test and Monitor the Integration runs

Module 16: Outbound Flow/Bulk Extraction from ERP Cloud

• Use Case – Set up Outbound Flow/Bulk Extraction from ERP Cloud to SFTP using BIP report
• Build Integration using App Driven orchestration style
• Kick off BIP report using External Report Service
• Decode the output and push it to SFTP

Module 17: Versioning and Cloning, Migration of Integrations using Packages

• Understand and use versioning in Integrations
• Understand and use cloning in OIC
• Use Packages to do bulk migration of Integrations
• Use Integration archive files to migrate 1 integration at a time

Module 18: Introduction to VBCS

• Introduction to VBCS
• Understand and explore the components involved in VBCS app
• Understand the data sources available in VBCS
• Managing the life cycle of VBCS app

Module 19: Build First VBCS Application – Build HR Web Application using VBCS

• Load Business Objects using Excel and use them as data source
• Use Charts in VBCS Pages
• Understand the building blocks of VBCS
• Create and Use Datatypes, Variables, Pages, Routings etc.
• Explore Action Chains and all the available features
• Activate and Test the VBCS app

Module 20: Using REST Services in VBCS

• Understand how to use REST services as data source in VBCS
• Build connections in VBCS using REST APIs
• Build data flow and UI in VBCS app
• Activate and Test the VBCS app

Module 21: Mobile App (Progressive Web App) in VBCS

• Explain Progressive Web App (PWA) and its build process
• Build Mobile App in VBCS as PWA
• Stage the app and demo installation using QR Code
• Explain how updates can be pushed downstream automatically

Module 22: Introduction to PCS

• Introduction to PCS
• Managing Process Applications
• Understand and explore the seeded templates available in PCS

Module 23: Build First PCS Application – Build PCS app using Quick Start Template

• Understand various options available in PCS app
• Activate, Test and Monitor the process runs
• PCS App Life Cycle Management
• Migration and Deployment of PCS App

Module 24: Build Dynamic Process in PCS

• Understand how Dynamic Process works in PCS
• Create a Dynamic Process for a Use Case
• Explore and use Stages, Activities, Roles, and Markers in Dynamic Process
• Activate the dynamic process, Test and Monitor the process

Module 25: Build Mix and Match Process in PCS

• Understand How Mix and Match Process works in PCS
• Invoke Structured process from Dynamic Process and vice versa
• Activate the Mix and Match process, Test and Monitor the process

Module 26: Build Decision Model in PCS

• Understand how Decision Model works in PCS
• Create a Decision Model for a Use Case
• Activate Decision Model and Create a snapshot
• Create PCS App and invoke Decision Model created above

Module 27: Introduction to Fusion Applications

• Architecture of Fusion Applications
• Overview and Accessing Fusion Applications UI
• Fusion Navigator and Tools section
• Introduction to Setup & Maintenance

Module 28: Fusion Reporting

• BIP Reporting
• Create Datamodel
• Add input params
• Create BIP report
• Configure for different formats
• Create default template
• Download Report

Module 29: Build Complex Leave Approval Web App using VBCS

• Build Complex Leave Approval Web App in VBCS
• Design and Implement master detail design in UI
• Explore and use all the features available in VBCS
• Invoke PCS Approval Process from VBCS on invoice submission
• Implement sorting and filtering in app
• Explore Validation Options available in VBCS
• Use Java Script functions to do custom validations
• Activate and Test the VBCS App

Module 30: Build Complex Leave Approval Process in PCS / Build Complex Invoice Approval Process in PCS

• Multilayer approval process with conditional rules
• Design a form and attach it to trigger connection in PCS
• Register and Invoke Internal and External APIs
• Build PCS application tying all the components together
• Activate, Test and Monitor the process runs

Module 31: Leave REST API Build in ICS

• Build Complex Leave REST API
• PCS to invoke this REST API once Leave is Approved
• REST API to receive Leave ID from PCS
• Pull the Leave Line Details from VBCS
• Update status back on VBCS Leave Request

Module 32: Test the E2E Flow – VBCS -> PCS -> ICS -> ERP Cloud

• Login to VBCS App and submit Leave Request
• Approval process in PCS should be triggered and Manager should receive notification
• Once Invoice is finally approved, REST API should get kicked off in ICS
• Update Leave Request in VBCS

Module 33: Guidance on Certification and Resume Preparation, Interview and Job Assistance

• Explain certification options available in OIC
• Provide tips on how to prepare for Certification
• Help with Resume Preparation as Integration Specialist
• Discuss common interview questions in OIC

1. Report Integration – Fusion Integration using Fusion SOAP services

• Run report and Extract data of BIP using Report Service
• Integration for invoking ReportService
• Invoke ReportService on Fusion SaaS by passing the required inputs
• Download the report to on-premise file system/FTP
• Manipulate the report data using xml schema
• Extract the data and send them to On-premises database
• Extract the data and send them to FTP server in a separate file for each record
• Expose as REST to accept Params
• Send multiple params as input to Datamodel

2. FBDI Automation – Fusion Integration using ERP Cloud Adapter

• FBDI – End to end Integration using OIC/Orchestration
• FBDI using Oracle ERP Cloud Adapter
• Read FBDI input data from FTP
• Invoke Import Data operation of ERP Cloud Adapter
• Get status of the Process
• Wait until the process is completed
• Download the FBDI Logs
• Write the logs to FTP folder
• Repeat the same Automation using ERP Integration Webservice

3. Extract Suppliers – Integration Using Fusion REST API

• Extract all the suppliers from Fusion
• Extract the suppliers and use various params for filtering
• Discuss about JSON structure received from Fusion
• Extract a specific supplier using supplier id as REST template param
• Discuss about Template Params with the example

4. Create Suppliers I – Fusion Integration using Fusion SOAP

• Source supplier data from On-premise Database
• Schedule integration to read the new records from the DB
• Create supplier records in Fusion
• Handle Errors with OIC Fault Management
• Send notification based on Success or Failure
• Update the status back in On-premise Database

5. Create Suppliers II – Fusion Integration using Fusion SOAP

• Source supplier data from On-premise file system

6. Create Suppliers III – Fusion Integration using Fusion SOAP

• Source supplier data from FTP file containing multiple records in csv

1. Oracle ADF

• Overview of JDevelopler, Weblogic Server
• Develop HR Emp Search, Edit, View Pages
• Developing ADF Business Objects (EO, VO, AM)
• Developing ADF UI
• Develop Taskflows to navigate from Search to View/Edit
• Deploy and run ADF application

2. Oracle SOA

• Overview of Oracle SOA
• Compare Oracle SOA and OIC
• Decision making factors between SOA and OIC
• Develop SOA composite applications
• Mediator
• File Adapter
• DB Adapter
• SOAP Adapter
• BPEL Orchestration
• Deploy and Test SOA Applications
• Oracle Enterprise Manager (FMW Controller)
• Weblogic Console

3. Oracle Process Cloud Service (PCS)

• Overview of PCS
• Features available in PCS
• Creating forms in PCS
• Create Order Approval Application
• Test Approval Applications
• Integrating Human Task in PCS
• Integration Integrations in PCS
• Managing PCS Applications

4. Oracle Visual Builder Service (VBCS)

• Overview of VBCS
• Compare VBCS and ADF
• Develop HR application (CRUD) using VBCS
• Develop Business Objects
• Develop UI
• Build and Test HR application
• Build VBCS Application using OIC REST services
• Retrieve Suppliers list in VBCS using Fusion REST APIs
• Develop Supplier Details page in VBCS based on Supplier ID
• Link Supplier List and Supplier Details using REST APIs

Job Support and Mock Interview

Job support and mock interview guidance are included in the supplied course content.