--- 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 --- # Look up primary data in Oracle EBS # Look up primary data in Oracle EBS {#ariaid-title1} * Release version: Yokohama * * Updated July 31, 2025 * * ![](https://www.servicenow.com/docs/portal-asset/ico-clock) 1 minute to read You can run a job to look up primary data from different ERP sources into ServiceNow. Before you start the ERP integration, you must configure the integration services record for the 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](https://servicenow-prod.fluidtopics.net/gcMl94qzHYy5r1Yp8QPjXQ "Create Integration Service records for entities using the sn_fcms_intg_service table."). Figure 1. Look up primary data in Oracle EBS You can manually run jobs for the following entities:{#look-up-primary-data-oracle-ebs__table_dtd_mwx_y2c__entry__3} | Entity | Description | Table name | |-|-|-| | Cost Centers | Lookup cost centers from Oracle EBS | [Cost Center Stage inbound staging table](https://servicenow-prod.fluidtopics.net/_W~jZX99UIajd0C1gfW2fA "The Cost Center Stage inbound [sn_fcms_intg_imp_cost_center] staging table temporarily stores important data about cost centers before this data is sent to the primary table. You can use this table to lookup all the cost center details.") | | Product Models | Lookup product models from Oracle EBS. | [Product Model Stage inbound staging table](https://servicenow-prod.fluidtopics.net/pUXpMnRL6~XzM0N3seGe7g "The Product Model Stage inbound [sn_fcms_intg_cmdb_model_stage] staging table temporarily stores important data about product models before this data is sent to the primary table.") | | Payment Terms | Lookup payment terms from Oracle EBS. | [Payment Terms Stage inbound staging table](https://servicenow-prod.fluidtopics.net/L4Cer3sid4HG5rL8NGxaGA "The Payment Terms Stage inbound [sn_fcms_intg_payment_term_stage] staging table temporarily stores important data about payment terms before this data is sent to the primary table.") | | Purchasing Orgs | Lookup purchasing orgs from Oracle EBS. | [Purchase Entity Stage inbound staging table](https://servicenow-prod.fluidtopics.net/TmPZ7nJLHcMQWWCsf9nQ2Q "The Purchase Entity Stage inbound [sn_fcms_intg_imp_purchase_entity] staging table temporarily stores important data about purchase entities before this data is sent to the primary table.") | | Departments | Lookup departments from Oracle EBS. | [Department Stage inbound staging table](https://servicenow-prod.fluidtopics.net/VmNQ6G1dRncgyiLZFMGg0g "The Department Stage inbound [sn_fcms_intg_department_stage] staging table temporarily stores important data about departments before this data is sent to the primary table.") | | GL Accounts | Lookup GL accounts from Oracle EBS. | [GL Account Stage inbound staging table](https://servicenow-prod.fluidtopics.net/eFPhaRummAMFFYEmwtUnwQ "The GL Account Stage inbound [sn_fcms_intg_gl_account_stage] staging table temporarily stores important data about General Ledger (GL) accounts before this data is sent to the primary table.") | | Currencies | Lookup currencies from Oracle EBS. | [FX Currency Stage inbound staging table](https://servicenow-prod.fluidtopics.net/zPxpalWIo1UiMuerILCBaA "The FX Currency Stage inbound [sn_fcms_intg_fx_currency_stage] staging table temporarily stores important data about FX currencies before this data is sent to the primary table.") | | FX Currency rates | Lookup FX rates from Oracle EBS. | [FX Rate Stage inbound staging table](https://servicenow-prod.fluidtopics.net/j6~T~lUp81K0Z3hVjwSb3A "The FX Rate Stage inbound [sn_fcms_intg_fx_rate_stage] staging table temporarily stores important data about FX rates before this data is sent to the primary table.") | | Invoice Payment Details | Lookup invoice payment details from Oracle EBS. | [Invoice payment detail import inbound table](https://servicenow-prod.fluidtopics.net/iEc0PWmFtfJ2tPzcv8Cu2Q "The Invoice Payment detail import inbound [sn_spend_intg_imp_invoice_payment_detail] staging table temporarily stores important data about supplier before this data is sent to the [sn_shop_invoice_payment_detail] primary table.") | | Suppliers | Lookup suppliers from Oracle EBS. | [Supplier location inbound staging table](https://servicenow-prod.fluidtopics.net/a49DydWrkEhGj1NAnVBNOQ "The Supplier location inbound [sn_fcms_intg_supplier_location_inbound] staging table temporarily stores important data about the geographical location of a supplier before this data is sent to the Supplier Location [sn_slm_m2m_location] and Location [cmn_location] primary tables.") | | Plant addresses | Lookup plant addresses from Oracle EBS. | [CMN Location Stage inbound staging table](https://servicenow-prod.fluidtopics.net/r2pzhCfLKxS1EZQaYlMObg "The CMN Location Stage inbound [sn_fcms_intg_cmn_location_stage] staging table temporarily stores important data about locations before this data is sent to the primary table.") | | Legal entities | Lookup legal entities from Oracle EBS. | [Legal Entity Stage inbound staging table](https://servicenow-prod.fluidtopics.net/YhUPIstj0WPfg11nTjNCsA "The Legal entity stage inbound [sn_fcms_intg_legal_entity_stage] staging table temporarily stores important data about legal entities before this data is sent to the primary table.") | | Invoices | Lookup invoices from Oracle EBS. | [Invoice import inbound staging table](https://servicenow-prod.fluidtopics.net/S1tW7ZiPIWrwBnDB4xQI4A "The invoice import inbound [sn_spend_intg_imp_invoice] staging table temporarily stores important data about the imported invoice before this data is sent to the [sn_shop_invoice] primary table.") | [Table 1. Look up primary data in Oracle EBS] {#look-up-primary-data-oracle-ebs__table_dtd_mwx_y2c} ## Transformation maps and subflows {#look-up-primary-data-oracle-ebs__section_ptd_b2b_1fc} To learn more about the Transformation maps and subflows, see [Source-to-Pay integration framework transform maps and subflows](https://servicenow-prod.fluidtopics.net/0Qg6pQO6FqaUw0q9tDH4Rg "The transform maps transform the source-to-pay data from the inbound staging tables to the Source-to-Pay primary data tables. The subflows move the source-to-pay data from the outbound staging tables to a third-party ERP system."). **Related concepts** * [ERP source configuration for Oracle EBS](https://servicenow-prod.fluidtopics.net/RupRAGsUYcIJcisquQNang "Configure your Source-to-Pay (S2P) instance to support inbound and outbound integration with your ERP system. This integration configuration enables you to automatically post purchase order, receipt, invoice, and download primary data from the ERP.") * [Scheduled jobs to look up primary data in Oracle EBS](https://servicenow-prod.fluidtopics.net/gaPV3rWXZhO89zHF7YmluA "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.") **Related tasks** * [Define ERP source configuration for Oracle EBS](https://servicenow-prod.fluidtopics.net/kZomh47YksEZ8QZIr8U7uA "ERP source configuration determines the ERP source to which your ERP system connects. Map the integration payload with the Oracle EBS tables.") * [Configure integration services for Oracle EBS](https://servicenow-prod.fluidtopics.net/UCDjuE3nZRwqMtATr0QHVA "For configuring integration services, provide the connection end point and the Oracle EBS ERP credentials that you set up for your authentication profile. Also, create a separate web service record for each service request that you want to customize.") * [Load data to ERP user-mapping table for Oracle EBS](https://servicenow-prod.fluidtopics.net/aBWjnG3DFwosAu7mazeWXQ "Set up Oracle EBS and ERP User ID mapping for the integration to work. The mapping is maintained for all active users who have the procurement buyer role in ERP. These users should be used in the requisition assignment rule.")