Run Scheduled OIC Integrations from Oracle APEX: A Self-Service Launcher with Runtime Parameters
How to build a metadata-driven APEX screen that runs scheduled orchestrations in Oracle Integration Cloud on demand, with parameters, guardrails and live status tracking. Introduction Scheduled orchestrations in Oracle Integration Cloud (OIC) usually run on a fixed timetable. But support teams often need to run one right now: Re-run a failed sync for a specific date range Pull a single record…
This article explains how to create an Oracle APEX screen that enables self-service scheduling of Oracle Integration Cloud (OIC) orchestrations with runtime parameters, monitoring, and safety features. The solution involves designing a set of database tables to store integration information, parameter definitions, and run logs, as well as creating an APEX Web Credential to securely call the OIC API. A PL/SQL package is developed to handle the submission of runs, validation, logging, and status tracking of scheduled tasks.
Written by urgent.news from Dev.to's reporting — not their text. Machine-written — may contain errors; check the original before relying on it.
