Oracle Fusion Technical – Oracle Integration Cloud (OIC/ICS)

Introduction
1 Introduction
2 Resources & Documentation

Types of Clouds
3 Types of Cloud Offerings – SaaS vs. PaaS vs. IaaS

Get Familiarized with the Tool
4 Get Familiarized with the Tool

Integration Styles in OIC
5 Integration Patterns in OIC

Build HelloWorld SOAP Web Service with OIC
6 HelloWorld Use Case
7 Configure SOAP Connection
8 Develop & Test the HelloWorld Integration

Build REST API with OIC
9 Introduction to REST API
10 REST API Use Case
11 Configure REST Connection
12 Develop & Test the REST Integration – Part I
13 Develop & Test the REST Integration – Part II

Import Bulk Data in Fusion using Oracle ERP Cloud Adapter (FBDI Based)
14 FBDI File Based Data Import Automation using importBulkData with SOAP UI
15 FBDI Understand Properties File
16 Import Journal Use Case (Scheduled Orchestration)
17 Pre-requisites for creating Oracle ERP Cloud Adapter
18 Configure Oracle ERP Cloud Adapter
19 Configure FTP Adapter
20 Create Integration & Define Variables
21 List the Files from FTP Server
22 Read File & Write to FBDI csv
23 Prepare the Properties File
24 Zip the FBDI csv & Properties File
25 Import Data in ERP Cloud
26 Archive the File
27 Activate & Test the Integration
28 Create Integration & Get Callback Message
29 Develop Callback Integration – IF Flow
30 Develop Callback Integration – ELSE Flow
31 Test Callback Integration

Integrate with On-Premise Systems via Connectivity Agent
32 What is Connectivity Agent – Architecture, Working Principle
33 Installation of Connectivity Agent

Inbound Integration with Fusion SaaS using Oracle ERP Cloud Adapter (SOAP)
34 Import Suppliers using SOAPUI
35 Import Suppliers Use Case
36 Configure File Adapter
37 Configure DB Adapter
38 Develop Import Suppliers Integration
39 Activate & Test Import Suppliers Integration

Extract Data from Fusion using BI Report with SOAP Adapter(Outbound Integration)
40 Enhance the Import Journal Integration (Scheduled Orchestration) Use Case
41 Walk Through the BI Report
42 Configure Report SOAP Connection
43 Enhance the Import Journal Integration
44 Activate & Test the Integration

Inbound Integration with Fusion SaaS using Oracle ERP Cloud Adapter (REST)
45 Import Receipt using Postman
46 Import Receipt using OIC (App Driven Orchestration) Use Case
47 Develop the Import Receipt Integration
48 Activate & Test the Import Receipt Integration

Outbound Integration with Fusion SaaS using REST Adapter
49 Get Receipt using Postman
50 Get Receipt using OIC (App Driven Orchestration) Use Case
51 Configure SOAP Trigger Connection
52 Configure Receipt REST Connection
53 Develop the Get Receipt Integration
54 Activate & Test the Get Receipt Integration

Lookups in OIC
55 Introduction to Lookups in OIC
56 Enhance the Import Journal Integration (Scheduled Orchestration) Use Case
57 Create Lookup in OIC
58 Enhance the Import Journal Integration

Publish & Subscribe in OIC
59 Publish To OIC Use Case
60 Develop Publish To OIC Integration
61 Activate & Test Publish To OIC Integration
62 Subscribe To OIC Use Case
63 Develop Subscribe To OIC Integration
64 Activate & Test Subscribe To OIC Integration

Exception Handling & Logging with Notifications
65 An Introduction to Exception Handling & Logging
66 Handle Exception in the Import Journal Integration Use Case
67 Enhance the Import Journal Integration to handle Exception
68 Activate & Test the Integration

Outbound Integration with Fusion using Oracle ERP Cloud Adapter(Event Based)
69 All about Business Events in Fusion
70 Develop the Business Event Based Integration
71 Activate & Test the Integration
72 Debugging of Business Event Subscription

Version Control & Packages in OIC
73 Version Control in OIC
74 Packages in OIC

OIC – Admin
75 Monitor Integrations in OIC
76 Schedule Integrations (Schedule Orchestration) in OIC
77 Migration Deploy OIC Integrations

Documentation in OIC
78 Integration Technical Specification

Prepare for OIC Interview
79 OIC Interview Questions

Use Case How to connect to ATP Database from OIC
80 Insert Log into an ATP Database Table
81 Create ATP Database Connection
82 Develop & Test the Integration

Use Case How to invoke BI Report from OIC and insert report output into DB
83 Invoke BI Report from OIC and insert report output into a Database Table

Use Case How to invoke BI Report in OIC and write the output to FTP Server
84 Invoke BI Report in OIC and write the output to FTP Server

Use Case How to read files from FTP to zip and write back to FTP
85 Read files from FTP to zip those and Write to FTP

Source Code
86 iar Files

Appendix A Service Oriented Architecture (SOA) Fundamentals
87 SOA Fundamentals
88 XML Fundamentals

Appendix B Crash Course Fusion ERP Technical
89 FBDI Understand the File Based Data Import Process
90 FBDI File Based Data Import Process Automation using SOAP UI
91 Fusion BI Getting Started
92 Fusion BI How to Develop BI Report
93 Fusion BI Add Parameters to the BI Report
94 Fusion BI Extract BI Report Output using Report Service through SOAP UI
95 Fusion BI How to migrate BI Report
96 Fusion Security Manage Users with Employee
97 Fusion Security Role Provisioning & Manage Data Access