Look up primary data in Oracle EBS
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.
You can manually run jobs for the following entities:
| Entity | Description | Table name |
|---|---|---|
| Cost Centers | Lookup cost centers from Oracle EBS | Cost Center Stage inbound staging table |
| Product Models | Lookup product models from Oracle EBS. | Product Model Stage inbound staging table |
| Payment Terms | Lookup payment terms from Oracle EBS. | Payment Terms Stage inbound staging table |
| Purchasing Orgs | Lookup purchasing orgs from Oracle EBS. | Purchase Entity Stage inbound staging table |
| Departments | Lookup departments from Oracle EBS. | Department Stage inbound staging table |
| GL Accounts | Lookup GL accounts from Oracle EBS. | GL Account Stage inbound staging table |
| Currencies | Lookup currencies from Oracle EBS. | FX Currency Stage inbound staging table |
| FX Currency rates | Lookup FX rates from Oracle EBS. | FX Rate Stage inbound staging table |
| Invoice Payment Details | Lookup invoice payment details from Oracle EBS. | Invoice payment detail import inbound table |
| Suppliers | Lookup suppliers from Oracle EBS. | Supplier Location inbound staging table |
| Plant addresses | Lookup plant addresses from Oracle EBS. | CMN Location Stage inbound staging table |
| Legal entities | Lookup legal entities from Oracle EBS. | Legal Entity Stage inbound staging table |
| Invoices | Lookup invoices from Oracle EBS. | Invoice import inbound staging table |
Transformation maps and subflows
To learn more about the Transformation maps and subflows, see Source-to-Pay integration framework transform maps and subflows.