Become an OIC 2 Master: Oracle Integration Cloud Masterclass
What you'll learn
- Oracle integration Cloud OIC for Oracle EBS Consultants and fusion consultants
- Soap Adapter ,Rest Adapter with REST API and SOAP API
- FTP Adapter - READ an WRITE and MOVE Files and Load file data into Tables
- Cloud Adapter -FBDI and Interfaces and conversions and Call Back
- ATP Adapter - INSERT ,UPDATE,DELETE ,MERGE and Calling Procedure and Packaged Procedure
- Call Bi Report From OIC and Load Data into Custom Tables
- Stage File action ,Schema File Creation
- App Driven Integration with Complex JASON Payload
- Creating Common logger integration
- For Loop ,While Loop, Fault , Re through Fault in OIC
- Scope and Exception Handling in OIC
- Email Notification with HTML body in OIC
- Web Services Testing using POSTMAN and SOAP UI
- Working With Attachments in Oracle OIC
- Call Back In Oracle OIC
- Business Events in OIC
- ORDS - Oracle Rest Data Service
- Content Sever
- Call BI Report from OIC using soap Webservice
REST Adapter: Connects to RESTful web services, enabling integration with a wide range of external systems using HTTP methods (GET, POST, PUT, DELETE).
SOAP Adapter: Interacts with SOAP-based web services, using XML-based messaging to exchange data.
FTP Adapter: Facilitates file transfers between Oracle Fusion and FTP servers, supporting both secure and unsecure protocols.
ATP Adapter: Interacts with Oracle Application Transaction Platform (ATP), a high-performance transaction processing server for handling high-volume, mission-critical operations.
FBDI Adapter: Handles File-Based Data Import (FBDI) processes for loading data from flat files (CSV, XML, etc.) into Oracle Fusion applications.
Other Key Components:
ORDS (Oracle REST Data Services): Enables the creation of RESTful APIs for accessing Oracle Fusion data, providing a way to expose and consume data in a RESTful manner.
Business Events: Asynchronous notifications triggered by specific actions or data changes within Oracle Fusion, allowing other systems or processes to react to these events.
Callback: A mechanism for Oracle Fusion to notify external systems upon completion of certain tasks or events, enabling those systems to take further actions based on the outcome.
REST Adapter: Integrating with external APIs, consuming web services, exchanging data in JSON or XML format.
SOAP Adapter: Interacting with SOAP-based systems, legacy applications, or web services that primarily use SOAP.
FTP Adapter: Transferring files for data exchange, backups, or integration with file-based systems.
ATP Adapter: High-volume transaction processing, integrating with ATP-based applications for critical operations.
FBDI Adapter: Loading data from flat files into Oracle Fusion for batch processing or data migration.
ORDS: Exposing REST APIs for integration with mobile apps, web applications, or other systems accessing Oracle Fusion data.
Business Events: Triggering actions in external systems based on specific events within Oracle Fusion, enabling real-time responses.
Callback: Notifying external systems of task completion or events, allowing for further actions or updates.
Unlock the Power of Oracle Integration Cloud: A Comprehensive Guide for Oracle Fusion and Apps/EBS Consultants
Master Oracle Integration Cloud (OIC) and seamlessly connect your Oracle Fusion and EBS applications with this hands-on, expert-led course.
Oracle Fusion Technical Consultants
Oracle Apps/EBS Technical Consultants
Professionals seeking to advance their OIC expertise
Key topics covered:
OIC Instance and ATP Database Setup: Learn how to create and configure your OIC instance and ATP database, laying the foundation for integrations.
Notifications and Emails: Master notification creation and email formatting for effective communication and alerts.
REST API Integration: Connect to RESTful web services with confidence, using Postman for testing and mastering query and template parameters.
ATP Adapter Mastery: Perform essential database operations (insert, update, delete, select) with and without parameters, and call procedures directly from your integrations.
SQL Developer for Database Connectivity: Gain proficiency in connecting to databases using SQL Developer for seamless data access.
FTP Integration: Transfer files effortlessly using FTP adapters, covering read, write, move, delete, list, and download actions.
Stage File Handling: Work with files effectively using Stage File actions for reading, writing, listing, and downloading.
SOAP API Integration: Connect to SOAP-based web services with ease, using SOAP UI for testing and creating SOAP connections in OIC.
BI Reporting: Retrieve BI reports efficiently, handling both small and large datasets seamlessly.
FBDI for Data Import: Master File-Based Data Import (FBDI) for loading data from flat files into Oracle Fusion applications.
Advanced Concepts: Explore ORDS, Cloud Adapter connections, Callbacks, Attachments, Business Events, and ESS job integration.
By completing this course, you'll:
Confidently build and manage integrations in Oracle Integration Cloud.
Streamline workflows and data exchange across Oracle Fusion and EBS applications.
Enhance your career prospects in the in-demand field of Oracle integration.
Enroll now and unlock the limitless possibilities of Oracle Integration Cloud!
Oracle Fusion Technical BI Reports and OTBI Reports available in udemy please go through it
How to Create OIC Instance in OCI
How Create ATP Data Base in OIC
How create a notification in OIC
How Create Email Notification With EMAIL body parameters OIC
How Create Email Notification With HTML body parameters in OIC
How Test Rest API Using Post man
How to Create REST Adapter connection in OIC
How To create integration using REST API with query and template parameters in OIC
How to Create ATP Adapter Connection in OIC
Insert - With parameters and without parameters
update - With parameters and without parameters
Delete - With parameters and without parameters
Select - With parameters and without parameters
Call Procedure from Integration
How to connect to DB using SQL developer
How to Create FTP Adapter Connection in OIC
How To create integration using FTP In OIC
Stage File Action in OIC
Read entire file
Read File in Segments
How to run Soap Api Using SOAP UI
How to create Soap connection in OIC
How to call Bi report with <10Mb data from SAAS using last_run_date
How to call Bi report with >10Mb data from SAAS
FBDI - File based data Import
BI Cloud Connector
ORDS(Oracle REST Data Service) in Oracle Database
How to Create Cloud Adapter connection OIC
How To create Call Back in oracle OIC
How to work with attachments in Oracle OIC
Business Events in Oracle OIC
How to call ESS job from OIC and SOAP UI
How to create ESS job in oracle Fusion ERP
Who this course is for:
- Oracle Apps technical consultants
- Oracle Fusion Technical (HCM or SCM or Finance)
- Oracle SOA Developers
- Oracle Developers
Working As A Oracle Apps/Fusion Technical Consultant In One of the Top 2 Leading MNC India .
• Having 4 Years Of total Experience As Oracle Apps/Fusion Technical Trainer
• Providing training for clients around World (India , USA ,Dubai , South Africa, Qatar )
• Having work experience in Financials ( Account Receivables , Account Parables) ,Order Management , Purchasing and Inventory modules in Oracle Applications R12 and Cloud.
• Having Experience in Oracle Cloud Integration(OIC) and Cloud BI Reports and OTB Reports , WMS Cloud Reports