Use schedule flows in Oracle EBS

  • Release version: Yokohama
  • Updated July 31, 2025
  • 4 minutes to read

    • Use the schedule flows to retrieve information from Oracle EBS, including invoices, cost centers, product models, payment terms, purchasing organizations, departments, GL accounts, currencies, FX rates, invoice payment details, suppliers, plant addresses, and legal entities.

    You can either use the subflows to perform the required tasks or you can create a copy of the subflows and then customize it according to your requirements.
    Important:

    These subflows are read-only. To modify a flow or subflow, create a copy and then apply the required changes.

    The Source-to-Pay with Oracle EBS integration supports the following subflows.

    Primary Data Integration with Oracle

    The Primary Data Integration with Oracle supports the following subflows and system properties:

    Subflows for Primary Data Integration with Oracle
    Table 1. Scheduled subflow details for Primary Data Integration with Oracle
    Subflow Description
    Fetch Cost Centers Use this subflow to lookup cost centers from Oracle EBS.
    Fetch Product Models Use this subflow to lookup product models from Oracle EBS.
    Fetch Payment Terms Use this subflow to lookup payment terms from Oracle EBS.
    Fetch Purchasing Orgs Use this subflow to lookup purchasing orgs from Oracle EBS.
    Fetch Departments Use this subflow to lookup departments from Oracle EBS.
    Fetch GL Accounts Use this subflow to lookup GL accounts from Oracle EBS.
    Fetch Currencies Use this subflow to lookup currencies from Oracle EBS.
    Fetch FX Currency Rates Use this subflow to lookup FX rates from Oracle EBS.
    Fetch Invoice Payment Details Use this subflow to lookup invoice payment details from Oracle EBS.
    Fetch Suppliers Use this subflow to lookup suppliers from Oracle EBS.
    Fetch Plant Addresses Use this subflow to lookup plant addresses from Oracle EBS.
    Fetch Legal Entities Use this subflow to lookup legal entities or company code details from Oracle EBS.
    Fetch Invoices Use this subflow to lookup invoices from Oracle EBS.
    System Properties for Primary Data Integration with Oracle

    Use these system properties to configure settings for the Primary Data Integration with Oracle from the System Properties page. For more information, see Source-to-Pay integrations with Oracle reference.

    Role required:
    • Read Role: sn_shop.procurement_specialist, sn_shop.shopper, sn_fcms_intg.admin
    • Write Role: sn_fcms_intg.admin
    Table 2. System Properties for Primary Data Integration with Oracle
    Property Name Description
    sn_orcl_data_int.action_default_page_size Oracle EBS action's default page size.
    sn_orcl_data_int.common_object_details_service_flow_name Use this subflow to look up common object details in Oracle.
    sn_orcl_data_int.cost_centers_service_flow_name Use this subflow for fetching cost centers from the Oracle system.
    sn_orcl_data_int.currencies_service_flow_name Use this subflow for fetching currencies from Oracle EBS system.
    sn_orcl_data_int.fetch_purchasing_organizations_service_flow_name Use this subflow for fetching purchasing organizations from the Oracle system.
    sn_orcl_data_int.full_load_time_range_default Defines the default time range for full data loads.
    sn_orcl_data_int.fx_rates_service_flow_name Use this subflow for fetching FX rates from the Oracle system.
    sn_orcl_data_int.glide.rest.max_content_length Defines the maximum content length allowed for REST API payloads.
    sn_orcl_data_int.gl_account_service_flow_name Use this subflow for fetching GL accounts from the Oracle system.
    sn_orcl_data_int.inventory_items_flow_name Use this subflow for fetching inventory items from the Oracle system.
    sn_orcl_data_int.legal_entities_service_flow_name Use this subflow for fetching legal entities from the Oracle system.
    sn_orcl_data_int.payment_terms_service_flow_name Use this subflow for fetching payment terms from the Oracle system.
    sn_orcl_data_int.plant_address_flow_name Use this subflow for fetching plant address from the Oracle system.
    sn_orcl_data_int.purchase_groups_service_flow_name Use this subflow for fetching purchase groups from the Oracle system.
    sn_orcl_data_int.supplier_service_flow_name Use this subflow for fetching suppliers from the Oracle system.
    sn_orcl_data_int.timeout_value Maximum timeout duration (in milliseconds) for subflow execution.

    Default value: 10000000

    Supplier Lifecycle Operations Integration with Oracle

    The Supplier Lifecycle Operations Integration with Oracle supports the following subflows:
    Table 3. Scheduled subflow details for Supplier Lifecycle Operations Integration with Oracle
    Flow Description
    Create or update or deactivate supplier Creates or updates or deactivates supplier in Oracle EBS.
    Create or update supplier location Creates or updates supplier location in Oracle EBS.
    Create or update supplier payment information Creates or updates supplier payment information in Oracle EBS.
    Important:

    These subflows are read-only. To modify a flow or subflow, create a copy and then apply the required changes.

    System Properties for Supplier Lifecycle Operations Integration with Oracle

    Use these system properties to configure settings for the Supplier Lifecycle Operations Integration with Oracle from the System Properties page. For more information, see Source-to-Pay integrations with Oracle reference.

    Role required:
    • Read Role: sn_shop.procurement_specialist, sn_shop.shopper, sn_fcms_intg.admin
    • Write Role: sn_fcms_intg.admin
    Table 4. System Properties for Supplier Lifecycle Operations Integration with Oracle
    Property Name Description
    sn_slo_orcl_int.supplier_location_service_flow_name Use this subflow to fetch supplier location data from the Oracle system.
    sn_slo_orcl_int.supplier_payment_service_flow_name Use this subflow to fetch supplier payment information from the Oracle system.
    sn_slo_orcl_int.supplier_service_flow_name Use this subflow to fetch supplier data from the Oracle system.

    Sourcing and Procurement Operations Integration with Oracle EBS

    The Sourcing and Procurement Operations Integration with Oracle EBS supports the following subflows:
    Table 5. Scheduled subflow details for Sourcing and Procurement Operations integration with Oracle EBS
    Flow Description
    Create or updates or cancels purchase order Creates or updates or cancels purchase order in Oracle EBS.

    Accounts Payable Operations Integration with Oracle EBS

    The Accounts Payable Operations Integration with Oracle EBS supports the following subflows:
    Table 6. Scheduled subflow details for Accounts Payable Operations Integration with Oracle EBS
    Flow Description
    Create AP invoice Creates AP invoice in Oracle EBS.