Oracle Integration Cloud (OIC) is Oracle’s managed cloud integration platform — available on Oracle Cloud Infrastructure (OCI) — that provides application integration (connecting Oracle and third-party applications through visual flow-based integrations), process automation (human workflow and approval automation), and API management (publishing and managing internal APIs for internal and external consumption). OIC includes pre-built adapters for Oracle’s own applications — Oracle EBS, Oracle Fusion ERP/HCM/SCM, Oracle EPM Cloud (EPBCS, FCCS, ARCS), Oracle Database — as well as adapters for hundreds of third-party applications (Salesforce, Workday, SAP, Microsoft 365, banking APIs). For GCC enterprises running Oracle EPM Cloud alongside Oracle EBS or Oracle Fusion, OIC provides the native integration infrastructure that connects these Oracle applications with minimal custom development — the Oracle EPM Cloud adapter handles the EPM Cloud REST API authentication, job triggering, and status polling that would otherwise require custom code.
OIC Capabilities
| Capability | Function | Finance Use Case |
|---|---|---|
| Application Integration | Scheduled and event-triggered integration flows between applications via pre-built adapters | Oracle EBS GL close completion → trigger FCCS data integration run; FCCS consolidation complete → trigger Power BI refresh |
| Process Automation | Human workflow automation — approval routing, task assignment, notification, escalation | Journal entry approval workflow: auto-route to controller for entries above threshold; escalate if not approved within 2 hours |
| API Platform | Expose internal integrations as governed APIs; manage API lifecycle, security, and rate limiting | Expose Oracle EBS vendor master as an internal API consumed by the supplier portal |
| File-based integration | Stage, transform, and route files between on-premise and cloud systems via FTP/SFTP/Object Storage | Bank statement SFTP receipt → OIC transformation → Oracle Cash Management bank file load |
| ZATCA API adapter | Pre-built connectivity to ZATCA Fatoora API for e-invoice clearance | Oracle EBS AR invoice → OIC ZATCA adapter → Fatoora clearance → EBS status update |
OIC in the GCC Oracle EPM Integration Stack
OIC is the integration layer in the standard Oracle EPM Cloud deployment architecture for GCC enterprises — connecting Oracle EBS (the actuals source) to Oracle EPBCS (planning) and Oracle FCCS (consolidation) through managed, monitored data flows. The EBS-to-FCCS integration via OIC replaces the legacy approach of manual data file extraction, FTP upload, and Data Management load — automating the data chain from EBS period close through FCCS consolidation trigger, replacing a multi-step manual process (2–4 hours of finance team coordination) with an automated sequence that executes within 15 minutes of the EBS period close signal. For GCC group consolidations where FCCS consolidates data from Oracle EBS entities across Saudi Arabia, UAE, Egypt, and other markets, OIC provides the event-driven integration backbone that ensures data flows from each entity’s EBS to FCCS automatically, with monitoring that alerts the consolidation team if any entity’s data fails to arrive before the consolidation deadline.
What Goes Wrong in Practice
The most common OIC production failure is an integration flow that stops monitoring after the initial API call — calling the Oracle EPM Cloud REST API to trigger a data integration run but not implementing the polling loop that monitors the job status and waits for completion before triggering the next downstream step. The OIC flow reports “success” (the job was triggered) while the FCCS data integration job is still running (it may take 10–30 minutes for large entity datasets); downstream steps that are triggered immediately after the trigger call attempt to start the FCCS consolidation before the data integration has finished — failing the consolidation due to incomplete data. Every OIC flow that triggers an asynchronous EPM job must poll the job status endpoint until the job reports completion before advancing.
How Loop Wise Solutions Implements OIC
We are experienced implementers of Oracle Integration Cloud in GCC enterprise Oracle stack environments — designing OIC integration flows for EBS-to-FCCS, EBS-to-EPBCS, FCCS-to-Power BI, and ZATCA integration use cases, with explicit job status polling, error handling, retry logic, and monitoring dashboards for the integration operations team.
