OIC – Add Suppliers from External System to Fusion HomeCoursesOIC – Add Suppliers from External System to Fusion Current Status Not Enrolled Enroll in this course to get access Price Included with OEG One Get Started Unlock Access Dates & Timings List of Contents OIC Integration Flow – Data Extraction to Fusion List of Contents Problem Statement • The integration flow focuses on extracting structured data from the database environment. • Exporting the extracted data as a file for downstream system consumption. • Creating the records in Fusion instances. Integration Flow General Use Case / Scenario • When a customer is operating with multiple systems. • Some data is available in one system and needs to be synchronized with another system. • Oracle Integration Cloud (OIC) plays a key role in automating the data synchronization between systems. • Example: A customer creates suppliers in the Salesforce system while using Fusion for invoicing. • All suppliers from Salesforce should remain synchronized with the Fusion supplier records. • This synchronization can be achieved using OIC. Approach Overview • REST Trigger / Scheduled Integration → ATP Database Adapter → Data Transformation → File Generation → FTP Adapter → Load into Fusion Solution Overview • This pattern enables structured data extraction from a database. • Transformation of the data into file formats such as CSV. • Delivery of the generated file to secure FTP locations. • Commonly used for reporting feeds, partner integrations, and enterprise data distribution. Key Integration Concepts Demonstrated • File-based enterprise integration using FTP adapters. • Data transformation and schema mapping in Oracle Integration Cloud. • Record-level processing using looping constructs. • Loading the data into the Fusion environment. • Bidirectional data exchange between file systems and databases. • Designing scalable and reliable batch data pipelines. If you have a paid account, login here. (You are not logged in. You need to login to access the videos.) Login Remember me Forgot Password? Sign in Lost your password? Please enter your username or email address. You will receive a link to create a new password via email. Email Reset Link Course Content Meeting Invite Meeting Invite – OIC – Add Suppliers from External System to Fusion (19 & 20-Mar-26) Sample Lesson
