Scheduled jobs to look up primary data in Oracle EBS

  • Release version: Zurich
  • Updated March 12, 2026
  • 1 minute to read

    • You can schedule on-demand jobs to be run at specific intervals of time to fetch primary data from different Oracle EBS ERP sources into ServiceNow.

    Before you start the Oracle EBS ERP integration, you must configure the integration services record for target ERP source using the sn_fcms_intg_service table. The sn_fcms_intg_service table is a mapping table between sub flows and target ERP source. For more information on creating an integration service record, see Create Integration Service record.

    Scheduled jobs are configured for entities using scripts. Example: Fetch cost center from ERP systems. For more information on configuring scheduled jobs using scripts, see Automatically run a script of your choosing. The script invokes a subflow, which is associated with an entity as shown in the following figure. The subflow queries the active entities or ERP source configuration (optional) listed in the integration service table.

    Scheduled script execution