Tuesday 12 December 2023

OIC_ICS_PCS_VBCS Course Content

 

Oracle Integration Cloud (OIC) Course Content

Course Duration - 45-50 Hrs., 5-6 Weeks

 Course Information 

Introduction To Oracle Integration Cloud Training

Oracle Integration Cloud

Oracle Integration Cloud has the power to integrate your cloud and on-premises applications, automate business processes, gain insight into your business processes, and develop visual applications—all in one place.

What you’ll learn

Ø  Build wide range of Integrations in OIC for SaaS to SaaS, and SaaS to On-Premise use cases.

Ø  Understand and build process automation using Oracle Process Cloud Service.

Ø  Build variety of visual applications using Oracle Visual Builder Cloud Service.

Ø  Build an END-TO-END PROJECT for REAL TIME CUSTOMER USE CASE using VBCS, PCS and ICS

Ø  We will provide Certification guidance and help you with Resume and Interview Preparation


Course Content

Module 1: Introduction to Oracle Integration Cloud

Ø  Why OIC?

Ø  Integration Challenges

Ø  What is OIC?

Ø  Introduction to OIC Components - Integration, PCS, VBCS

Ø  OIC Flavors

Ø  High level overview of the course content

 

Module 2: Oracle Cloud Account Sign Up Process & OCI Console Overview

Ø  Oracle Cloud Account Sign Up Process for Free Tier Account

Ø  Oracle Cloud Infrastructure Console Overview

Ø  Demo how to provision new Oracle Integration Cloud Instance

Ø  Explain how IDCS supports OIC with user authentication

Ø  Demo user creation and role assignment in Oracle Integration Cloud

 

Module 3: Navigation in Oracle Integration Cloud

Ø  Explain Home Page and Navigation Options available in OIC

Ø  Deep Dive into Integrations Designer Page and explain 7 options available there

Ø  Explore Visual Builder Cloud Service features available in web or mobile app build

Ø  Walkthrough of Process Cloud Service Work Area and explain processes, spaces, etc.

Ø  Monitoring Page options Usage Metrics, Monitor Integration Options etc.

Ø  Explain Settings available in OIC


Module 4: Web Service Basics

Ø  What are Web Services?

Ø  SOAP Service Basics

Ø  WSDL and XML

Ø  Test Standard SOAP Service ERP Integration Service

Ø  REST API Basics

Ø  Test Standard REST API – ERP Banks REST API

 

********* PART 1: Building Application Integrations in OIC

 

 

Module 5: Introduction to Integrations in OIC

Ø  Understand main components of Integration

Ø  Integration Development Workflow

Ø  6 Integration Styles available in Integrations

 

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: Salesforce to ERP Cloud Integration Service

Ø  Use Case: Create Customer Account in ERP Cloud as soon as it is created in Salesforce

Ø  Performs required setups in Salesforce and ERP Cloud

Ø  Establish connectivity with Salesforce and ERP Cloud from OIC

Ø  Build an Integration to integrate Salesforce with ERP Cloud

Ø  Activate, Test and Monitor the Integration runs

 

Module 16: 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 17: 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 18: 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

 

 

********* PART 2: Build Visual Applications using Visual Builder Cloud Service (VBCS)

 

 

Module 19: 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 20: 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 21: 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 22: Mobile App (Progressive Web App) in VBCS

Ø  Explain Progressive Web App (PWA) and it's 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

 

 

********* PART 3: Process automation using Process Cloud Service (PCS)

 

 

Module 23: Introduction to PCS

Ø  Introduction to PCS

Ø  Managing Process Applications

Ø  Understand and explore the seeded templates available in PCS

 

Module 24: 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 25: 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 26: 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 27: 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

 

********* PROJECT - Complex AR Invoice End to End (E2E) Solution (VBCS -> PCS -> ICS -> ERP)

 

 

Introduction to Project Use Case

Ø  Customer has a requirement to build a custom web application which will allow 250 odd users to login and submit AR Income Requests. These requests need to go through the Manager and Income Department approval and might also need Finance Director approval in case amount exceeds certain limit prior to interfacing into Oracle ERP Cloud.

Components required for Solution Build:

Ø  Complex VBCS App with advanced features

Ø  Multilayer Approval Process in PCS with Conditional Rules and Internal/External API Invocation

Ø  ICS REST API to create AR Invoice in ERP Cloud and update Invoice Request in VBCS

Ø  Test the End to End flow covering all failure points


Module 28: Build Complex AR Invoice Web App using VBCS

Ø  Build Complex AR Invoice Web App in VBCS

Ø  Design and Implement master detail design in UI

Ø  Explore and use all the features available in VBCS

Ø  Invoke ERP AR Invoice REST API to push AR Invoice to ERP Cloud

Ø  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 29: Build Complex Invoice 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 30: AR Invoice REST API Build in ICS

Ø  Build Complex AR Invoice REST API

Ø  PCS to invoke this REST API once Invoice is Approved

Ø  REST API to receive Invoice Id from PCS

Ø  Pull the Invoice and Invoice Line Details from VBCS

Ø  Create AR Invoice in ERP Cloud and update status back on VBCS Invoice Request


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

Ø  Login to VBCS App and submit Invoice 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

Ø  ICS REST API to create AR Invoice in ERP Cloud and

Ø  Update Transaction Number and Status back on Invoice Request in VBCS

 

 

Module 32: 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

No comments: