Oracle Integration Cloud Service

1. Introduction to the OIC Training Course and Course Content

• Overview of Cloud offerings (IaaS, PaaS, SaaS)
• Overview of Oracle Integration Cloud (OIC) concepts
• Discussion on iPaaS offerings in market (OIC, DellBoomi, Mulesoft, etc.)
• Details about Oracle Certification – 1Z0-1042-20 (Oracle Cloud Platform Application Integration 2020 Specialist)
• Details about Oracle Free cloud account
• Technical and Business Benefits of iPaaS (OIC)
• Discussion on key integration terminologies– WSDL, SOAP, REST, XML, XSD, JSON
• Overview of Oracle Fusion Middleware Discussion on market value and prerequisites
• Demo    

2. WSDL, SOAP and REST Concepts

• Introduction to RPC and where Web Services come in Introduction to RESTful Services (GET, PUT, POST, PATCH, DELETE)
• Complete walkthrough of a WSDL

3.Create Integration and taking integration backup  

• Oracle Cloud Adapters Configuring Connections – Trigger, Invoke using REST adapter
• Working on App Driven Orchestration – Integration Style Working on MAP, SWTICH, ASSIGN activities
• Testing REST integration using Test option on OIC console
• Take backup of integration – Download iar file
• Activate, Monitor and Track integration flow  

3. Exposing REST service as SOAP, packages, and FTP connection

• Configuring Connections – Trigger, Invoke using FTP, SOAP adapter Writing files on FTP server (using FTP connection)
• Working on Call Integration action (calling existing Integration from OIC)
• Exposing REST service as SOAP Using SOAP-UI to call OIC SOAP based integration
• Discussion on packages Take backup of integration – Download par file
• Clone an Integration versioning  

4. Scheduled integration pattern

• Scheduled integration pattern
• READ csv file from FTP Read file using STAGE FILE data action
• WRITE csv file on FTP iCal expression Integration parameters

5. Conditional branching, looping, Global Variables  

• For Each collection action Download and process zip file from FTP
• Read multiple csv records
• Write separate json structure file per record
• Local variables
• Global Variables
• Data Stitch action MAP action vs Data Stitch

6. FTP adapter – List, Write, download operations

• LIST files using FTP adapter
• WRITE operation – STAGE file
• Convert csv to JSON Lookup, Note, Logger, Notification
• Practice

7. On-Prem Integrations – Agents

• Configuring On-Prem Connections – Trigger, Invoke using DataBase
• File adapter Discuss on Agent concept – Need of agent.
• Create database connection using On-Prem agent
• Create Basic Routing Orchestration
• Perform SELECT, UPDATE, INSERT operation Edit SQL and add parameters in DB query  

8. Oracle SAAS – Fusion cloud and Fault Handling

• Navigating Oracle Cloud ERP – Oracle Fusion R13
• Calling Oracle Cloud ERP  SOAP web service
• Using SCOPE Action handling fault demo

9. Advanced Fault Handling

• Fault Return Re-throw Fault Throw New Fault Global Fault Using Global Variables in fault handler

10. Publish and Subscribe To OIC Integration Style

• Discussion on messaging pattern, event-based integrations, loose coupling concepts
  Practice

11. Oracle Fusion – FBDI manual

• Introduction to Oracle SAAS Fusion ERP.
• Discussion on Conversion/Interface
• Describe FBDI manual process.
• Practice all FDBI steps manually

12. FBDI process using ERP Integration SOAP service  

• Discuss ERP integration SOAP service operations
• Configuring all FBDI steps using ERP integration SOAP service, including getting logs
• Discussing Oracle Fusion ESS job and it’s details
• How to get parameter details for ERP Integration service operations
• Comparing Oracle ERP Cloud Adapter with ERP Integration SOAP service (When to use what option)

13. FBDI Automation using Oracle ERP Cloud Adapter

• Discuss OIC Oracle ERP adapter concepts and usages
• Automate FBDI process using ERP adapter as Invoke
• Configuring properties file Configuring ERP cloud adapter for callback (configuring CSF key in Oracle SOA Composer)using ERP adapter as trigger to get FBDI logs Practice  

14. Oracle Fusion ERP – OTBI reports

• Discussion and Creation of OTBI report Analysis
• Dashboard demo Drill down report demo
• Practice

15. Oracle Fusion ERP – BI reports and Oracle Report Service (Outbound from Fusion SaaS)

• Creation of BIP report Creating parameter based BIP custom report Bursting, emailing output of report
• Using Report service to automate BIP report data extraction
• Practice  

16. Oracle Fusion ERP – REST Services

• Describe Fusion REST services Leverage parameters provided by Oracle on REST service
• Create integration to invoke Oracle Fusion REST service to create supplier  

17. OIC Admin steps and Code migrations Code migrations across instances

• REST API’s to manage OIC integrations Submit failed integrations without logging to OIC instance
• OIC user management SOA and OIC discussion/comparison

18. VBCS  

• Overview of VBCS
• Introduction to OJET Comparison of VBCS with other application tools (ADF, OAF) 
• Application development using VBCS  

19. PCS  

• Overview of PCS Form Development, approval patterns Demo PCS application – Approvals 

20. Interview Questions and Project write-ups for resume

• Interview Technical Questions
• Interview Scenario Questions
• Sample project write-ups
• Project Ideas