День 2 OIC Fox Oracle Apps Solutions

🔧 Oracle Integration Cloud Gen3 (OIC Gen3) Online Training 2026 — Session 02 In Day 2 we go fully hands-on and build our first real Schedule Integration from scratch — reading an invoice CSV file from an SFTP server and inserting the data into an Oracle ATP database table. No slides, pure practical! ✅ What you will learn in this session: • Real project requirement analysis — SFTP (source) to ATP DB (target) • How to prepare a sample CSV invoice file for testing • Creating and querying an Oracle ATP staging table with WHO columns • Connecting SQL Developer to ATP database using cloud wallet • What are adapters? How connections use adapters in OIC • Creating FTP/SFTP connection in OIC — host, port, credentials • Creating ATP connection in OIC — cloud wallet, JDBC over SSL • Understanding Trigger vs Invoke vs Trigger & Invoke connection roles • Creating a Schedule Integration and navigating the canvas • Configuring Read File operation — uploading CSV schema • Mandatory vs optional columns in file schema configuration • Adding ATP endpoint and configuring Insert operation on staging table • Visual Mapper — array to array mapping (automatic For Each loop) • Using expression builder to hardcode values (status = N, process message = NEW) • Mapping OIC metadata — integration name, instance ID, current date • Business identifier / tracking variables — why every integration needs one • Tracing levels — Production, Audit, Debug explained • Activating and running integration on ad hoc basis • Debugging using activity stream — reading XML payload logs • Verifying inserted records in ATP database using SQL Developer • Using OIC instance ID and WHO columns to track integration executions 📁 Files used in this session: • Invoice CSV file (foss_inv1.csv) — placed on SFTP file server • ATP staging table: FOSS_INVOICE_STG — created live in SQL Developer • Cloud wallet (ZIP) — used to configure ATP connection in OIC 0:00 Intro & Day 2 overview — what we will build today 0:33 Requirement — SFTP to ATP database inbound integration 1:49 Understanding source (SFTP) and target (ATP database) 3:32 Creating the invoice CSV file in Excel 7:22 Creating the ATP database table in SQL Developer 8:35 Connecting SQL Developer to ATP using cloud wallet 14:23 Understanding adapters and connections in OIC 18:34 Placing the CSV file on the SFTP file server 21:03 Navigating OIC — Design, Integrations, Connections 22:22 What are adapters and connections in OIC? 24:49 Creating FTP connection in OIC — step by step 26:06 Trigger vs Invoke vs Trigger & Invoke — explained 32:00 Creating ATP connection in OIC — cloud wallet setup 36:43 Creating the Schedule integration in OIC 38:32 Integration canvas overview — endpoints explained 42:05 Adding FTP endpoint to read file from SFTP 44:53 Configuring Read File operation — schema upload 50:04 Making columns mandatory vs optional in file schema 53:06 Adding ATP endpoint to insert data into table 57:14 Selecting table and performing Insert operation 1:03:20 Mapping — source (FTP read) to target (ATP table) 1:06:37 Array to array mapping — automatic For Each loop 1:08:12 Mapping functions — current date, expression builder 1:14:21 Adding business identifier / tracking variable 1:16:54 Activating the integration — tracing levels explained 1:17:52 Running integration ad hoc — activity stream debug 1:21:00 Reading the XML payload — file data in activity log 1:24:35 Verifying data inserted into ATP database table 1:27:01 Integration instance tracking — WHO columns usage 1:28:21 Q&A session and next steps #OracleIntegration #OICGen3 #OracleATP #FTPAdapter #ATPAdapter #OracleCloud #OICTraining2026 #OracleFusionERP #CloudIntegration #OICDeveloper #ScheduleIntegration #OracleDatabase #OICMapper #FoxOracleAppsSolutions #iPaaS