Module 1: Introduction to Oracle Integration Cloud
- Why do we need OIC?
- Integration Challenges What is OIC?
- Introduction to OIC Components - Integration, OPA, VBCS
- Understand Salesforce to ERP Service use case in OIC
- High level overview of the course content
- Navigation Basics in OIC, Create Vs Import
- Integration Styles in OIC, Connections, and Packages
- Explain usage of Lookups and Agents
- Complete Integration Designer options overview
Module 2: Integration Designer Options Overview in OIC
- 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: SOAP Service Basics
- What are Web Services?
- SOAP Service Basics
- XSD, WSDL and XML
- Test Standard SOAP Service – ERP Integration Service
Module 4: REST API Basics
- What are Web Services? REST API Vs SOAP HTTP Methods, Params
- URI and JSON Payloads
- Test Standard REST API – ERP Banks REST API
********* PART 1: Building Application Integrations in OIC Gen 3
Module 5: Projects Creation in OIC
- Understand Projects creation in OIC
- Access Control in Projects
- 3 Integration Styles available in Integrations
Module 6: Build First REST API in OIC – Application Orchestration Style
- Build the API
- Enable Tracking on the API
- Activate the API
- Basic Auth vs OAuth
- Test the API & Monitor the request
Module 7: Build First SOAP Service in OIC - App Driven Orchestration Style
- Build the SOAP Service
- Enable Tracking & Activate Service.
- Concrete vs Abstract WSDLs
- 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 PO Invoice REST API - App Driven Orchestration Style
- Use Case – Build REST API with multiple Endpoints to Import Purchase Orders in ERP
- Expose GET endpoint to fetch Purchase Order Details from ERP Cloud
- Expose POST endpoint to create Purchase Orders in ERP Cloud
- Use DATA STITCH and GLOBAL variables to capture PO status
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
- FBDI Stage File Options and extensive usage of ATP DB in FBDI
Module 12: Publish to OIC Services
- Build Publish to OIC Service which subscribes to SaaS business event
- Publishes message to OIC Events Streaming
- Activate, Test and Monitor the Publish to OIC Service
Module 13: Subscribe to OIC Services
- Build Subscribe to OIC Services to subscribe to message in OIC Event Streaming
- Write file to FTP from 1 subscriber service and insert details into ATP.
- Activate, Test and Monitor the Integration runs
- Business Event Driven Approach vs BIP Report bulk extraction
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 Service & HCM Data Loader Services
- Use Case: Create Customer Account in ERP Cloud as soon as it is created in Salesforce
- Performs required setups in Salesforce and ERP Cloud
- Build an Integration to integrate Salesforce with ERP Cloud
- Use Case – Data load to HCM Cloud using HCM Data Loader
- Activate, Test and Monitor the Integration runs
Module 16: Build HCM Extracts & Atom Feed Services
- Build Outbound flows using HCM Extracts for bulk extraction from HCM
- Build Outbound flows using HCM Atom Feed for low volume of HCM
- Comparison between HCM Extracts vs Atom Feeds
- 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
- Stage File read BIP Output and send it to various destinations like ATP, REST, SOAP etc.
Module 18: Versioning and Cloning, Migration of Integrations using Packages & Projects
- 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 Redwood Web Apps using Visual Builder Cloud Service (VBCS)
Module 19: Introduction to VBCS Redwood Framework
- Introduction to VBCS Redwood Framework
- Understand in depth the redwood patterns and templates
- Understand the data sources available in VBCS
- Managing the life cycle of VBCS app
Module 20: Build HR Redwood Web Application
- Build HR Web Application using VBCS
- Load Business Objects using Excel and use them as data source
- Use Redwood Page Welcome and General Overview Templates
- 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: Build Complex Order Management Redwood App
- Understand how to use All redwood templates in VBCS
- Build Complex order management app using all the features
- Create Complex action chains
- Activate and Test the VBCS app
Module 22: 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
********* PART 3: Oracle Cloud Infrastructure Process Automation (OCI)
Module 23: Introduction to OPA
- Introduction to OCI OPA
- Understand OPA Components
- Understand and explore the seeded templates available in PCS
Module 24: Build First OCI OPA application
- Build OPA app using Quick Start template
- Understand various options available in OPA app
- Activate, Test and Monitor the process runs
- OPA 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) Redwood 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 Redwood VBCS App with advanced features
- Multilayer Approval Process in OPA/PCS with Conditional Rules & 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 Redwood App using VBCS
- Build Complex AR Invoice App using Redwood
- Design & Implement Smart Search Redwood Page
- 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 OPA
- Build Complex Invoice Approval Process in OPA
- Multilayer approval process with conditional rules
- Design a form and attach to trigger connection in OPA
- 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 OPA 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