---
sourceDocument: Yokohama Finance and Supply Chain
sourceDocumentLink: https://servicenow-prod.fluidtopics.net/r/yokohama/source-to-pay-operations

 Release :

    - yokohama

ft:locale :

    - en-US

ft:publication_title :

    - Yokohama Finance and Supply Chain

ft:clusterId :

    - stpop

bundleId :

    - stpop

workflow :

    - Employee


---

# Use schedule flows in Oracle EBS

# Use schedule flows in Oracle EBS {#ariaid-title1}

* Release version: Yokohama
* 
* Updated July 31, 2025
* 
* ![](https://www.servicenow.com/docs/portal-asset/ico-clock) 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 {#using-schedule-flows-oracle-ebs__section_kdv_r2x_y2c}

The Primary Data Integration with Oracle supports the following subflows and system properties:  
Subflows for Primary Data Integration with Oracle  
{#using-schedule-flows-oracle-ebs__table_fzr_2pj_k2c__entry__2}

| 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. |
[Table 1. Scheduled subflow details for Primary Data Integration with Oracle]

{#using-schedule-flows-oracle-ebs__table_fzr_2pj_k2c}  
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](https://servicenow-prod.fluidtopics.net/2CcQbjDuAiAqxECWXq_NLw "Reference topics provide additional information on integrating Source-to-Pay Operations with Oracle, including sales orders, procurement, finance, and so on, between Source-to-Pay and ERP systems.").  
Role required:

* Read Role: sn_shop.procurement_specialist, sn_shop.shopper, sn_fcms_intg.admin
* Write Role: sn_fcms_intg.admin
{#using-schedule-flows-oracle-ebs__ul_kkm_2rh_4hc}  
{#using-schedule-flows-oracle-ebs__table_zhx_grm_nhc__entry__2}

| 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 |
[Table 2. System Properties for Primary Data Integration with Oracle]

{#using-schedule-flows-oracle-ebs__table_zhx_grm_nhc}

## Supplier Lifecycle Operations Integration with Oracle {#using-schedule-flows-oracle-ebs__section_zm5_x2x_y2c}

The Supplier Lifecycle Operations Integration with Oracle supports the following subflows:{#using-schedule-flows-oracle-ebs__table_enj_ggx_y2c__entry__2}

| 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. |
[Table 3. Scheduled subflow details for Supplier Lifecycle Operations Integration with Oracle]

{#using-schedule-flows-oracle-ebs__table_enj_ggx_y2c}  
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](https://servicenow-prod.fluidtopics.net/2CcQbjDuAiAqxECWXq_NLw "Reference topics provide additional information on integrating Source-to-Pay Operations with Oracle, including sales orders, procurement, finance, and so on, between Source-to-Pay and ERP systems.").  
Role required:

* Read Role: sn_shop.procurement_specialist, sn_shop.shopper, sn_fcms_intg.admin
* Write Role: sn_fcms_intg.admin
{#using-schedule-flows-oracle-ebs__ul_oqb_5bq_4hc}  
{#using-schedule-flows-oracle-ebs__table_zzj_wbq_4hc__entry__2}

| 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. |
[Table 4. System Properties for Supplier Lifecycle Operations Integration with Oracle]

{#using-schedule-flows-oracle-ebs__table_zzj_wbq_4hc}

## Sourcing and Procurement Operations Integration with Oracle EBS {#using-schedule-flows-oracle-ebs__section_jws_mgx_y2c}

The Sourcing and Procurement Operations Integration with Oracle EBS supports the following subflows:{#using-schedule-flows-oracle-ebs__table_h3s_bfx_y2c__entry__2}

| Flow | Description |
|-|-|
| Create or updates or cancels purchase order | Creates or updates or cancels purchase order in Oracle EBS. |
[Table 5. Scheduled subflow details for Sourcing and Procurement Operations integration with Oracle EBS]

{#using-schedule-flows-oracle-ebs__table_h3s_bfx_y2c}

## Accounts Payable Operations Integration with Oracle EBS {#using-schedule-flows-oracle-ebs__section_fcg_sgx_y2c}

The Accounts Payable Operations Integration with Oracle EBS supports the following subflows:{#using-schedule-flows-oracle-ebs__table_mkp_xgx_y2c__entry__2}

| Flow | Description |
|-|-|
| Create AP invoice | Creates AP invoice in Oracle EBS. |
[Table 6. Scheduled subflow details for Accounts Payable Operations Integration with Oracle EBS]

{#using-schedule-flows-oracle-ebs__table_mkp_xgx_y2c}
* **[Manually trigger flows or subflows in Oracle EBS (Inbound)](https://servicenow-prod.fluidtopics.net/lJrTvhHkjhMxiGf8a4JOaw)**   
  You can manually trigger flows or subflows in Oracle EBS on demand. Follow these steps to manually trigger a flow or subflow.
* **[Use a flow or subflow in Oracle EBS (Outbound)](https://servicenow-prod.fluidtopics.net/IHZMPyQkSUmwd9IMRvHC6g)**   
  A flow or subflow can be executed in Oracle EBS using the Workflow Studio. Follow these steps to run a flow or subflow.
* **[Copy a flow or subflow in Oracle EBS](https://servicenow-prod.fluidtopics.net/nRDke1woo~seiojXSxkC8g)**   
  You can create a copy of the a flow or subflow and make the necessary modifications. Use the following steps to activate a flow or subflow.

