Overview
The Oracle ERP integration provides a set of ready-made functions you can call when building mappings. They handle common lookups and conversions for Oracle ERP, such as resolving a company, customer, product, order, or location by a value you already have, checking whether a company exists in Oracle, calculating an extended price, and reading a value from a record's custom fields, so you don't have to write that logic yourself.
Where you can use these functions
These functions are available anywhere you write a formula for the Oracle ERP integration:
Dynamic Formula mappings: where a destination field's value is produced by a formula rather than mapped directly from a source field.
Mapping collection filters: where a formula decides whether a record should be processed.
Error filters: a mapping collection's error filter, which sits alongside its collection filter. When the error filter's formula resolves to true, the transfer raises an error that is held in the Error Logs for review and is not retried automatically.
Translation collections: where a translation entry uses a formula as its source value.
How to use them
Call a function by name and pass the values it needs in parentheses, for example:
await GetOracleProductBySku(Sku).Each function's signature shows its name, the parameters it accepts (with their types), and the type of value it returns. Use it as the reference for exactly how to call the function.
Function names and formula syntax are case-sensitive, so type each name exactly as shown. Whether the values a function matches are treated as case-sensitive varies by function, and is called out in the relevant parameter's description.
Some of these functions are asynchronous (their signature returns a
Task) and must be called withawait; the rest are synchronous and are called directly. Each function's How to call it example shows the correct form.Each function runs at sync time, against the data in your connected Oracle ERP account and your iPaaS.com subscription.
The functions are grouped below by the area of the integration they support.
Companies and Customers
Use these to resolve companies and customers between iPaaS.com and Oracle ERP during mapping.
GetOracleCustomerShipToOrgIdByiPaaSCompanyId
What it does: Finds the Oracle ship-to organization ID for a company, by looking up the company in iPaaS.com by its ID and then finding the matching Oracle customer by account number. Returns nothing if the company or ship-to organization ID is not found.
Signature: Task<string> GetOracleCustomerShipToOrgIdByiPaaSCompanyId(string Id)
How to call it: await GetOracleCustomerShipToOrgIdByiPaaSCompanyId(Id)
Parameter | Type | Required | Default | Description |
Id |
| Yes | N/A | The iPaaS.com company ID whose Oracle ship-to organization ID you need. |
Returns: string. The Oracle ship-to organization ID, or nothing if it is not found.
Example: await GetOracleCustomerShipToOrgIdByiPaaSCompanyId("2741") returns the Oracle ship-to organization ID for iPaaS.com company 2741.
When to use it: When mapping a shipping reference to Oracle and you have the iPaaS.com company ID but need the Oracle ship-to organization ID.
GetOracleCustomerShipToOrgIdByiPaaSCompanyIdAndOracleCustomerPartySiteNumber
What it does: Finds the Oracle ship-to organization ID for a specific customer party site, by looking up the company in iPaaS.com by its ID and then finding the matching Oracle customer by account number and party site number. Returns nothing if no matching record is found.
Signature: Task<string> GetOracleCustomerShipToOrgIdByiPaaSCompanyIdAndOracleCustomerPartySiteNumber(string Id, string partySiteNumber)
How to call it: await GetOracleCustomerShipToOrgIdByiPaaSCompanyIdAndOracleCustomerPartySiteNumber(Id, partySiteNumber)
Parameter | Type | Required | Default | Description |
Id |
| Yes | N/A | The iPaaS.com company ID whose Oracle customer record you need. |
partySiteNumber |
| Yes | N/A | The Oracle customer party site number that identifies the specific site. |
Returns: string. The Oracle ship-to organization ID for the matching party site, or nothing if no record matches.
Example: await GetOracleCustomerShipToOrgIdByiPaaSCompanyIdAndOracleCustomerPartySiteNumber("2741", "123456") returns the ship-to organization ID for party site 123456.
When to use it: When mapping a shipping reference to a specific Oracle customer party site.
GetOracleCustomerByiPaaSCompanyID
What it does: Checks whether an iPaaS.com company exists as a customer in Oracle ERP, matching on the company's account number. Returns "true" if a matching Oracle customer exists, otherwise "false".
Signature: Task<string> GetOracleCustomerByiPaaSCompanyID(string Id)
How to call it: await GetOracleCustomerByiPaaSCompanyID(Id)
Parameter | Type | Required | Default | Description |
Id |
| Yes | N/A | The iPaaS.com company ID to check against Oracle ERP. |
Returns: string. "true" if a matching Oracle customer exists, otherwise "false".
Example: await GetOracleCustomerByiPaaSCompanyID("2741") returns "true" when iPaaS.com company 2741 already exists as an Oracle customer.
When to use it: In a mapping filter, to decide whether an iPaaS.com company already exists in Oracle ERP before creating or syncing it.
GetiPaaSCompanyIdByAccountNumber
What it does: Looks up an iPaaS.com company by its account number and returns its iPaaS.com company ID. Returns nothing if no company matches.
Signature: Task<string> GetiPaaSCompanyIdByAccountNumber(object companyAccountNumber)
How to call it: await GetiPaaSCompanyIdByAccountNumber(companyAccountNumber)
Parameter | Type | Required | Default | Description |
companyAccountNumber |
| Yes | N/A | The company account number to look up in iPaaS.com. |
Returns: string. The iPaaS.com company ID, or nothing if no company matches.
Example: await GetiPaaSCompanyIdByAccountNumber("ACC-12345") returns the iPaaS.com company ID for account number ACC-12345.
When to use it: When you have a company account number and need its iPaaS.com company ID during mapping.
GetOracleCustAccountIdByAccountNumber
What it does: Looks up an Oracle customer by account number and returns the Oracle customer account ID. Returns nothing if no customer matches.
Signature: Task<string> GetOracleCustAccountIdByAccountNumber(object companyAccountNumber)
How to call it: await GetOracleCustAccountIdByAccountNumber(companyAccountNumber)
Parameter | Type | Required | Default | Description |
companyAccountNumber |
| Yes | N/A | The company account number to look up in Oracle ERP. |
Returns: string. The Oracle customer account ID, or nothing if no customer matches.
Example: await GetOracleCustAccountIdByAccountNumber("ACC-56789") returns the Oracle customer account ID for account number ACC-56789.
When to use it: When you have a company account number and need the Oracle customer account ID during mapping.
Products
Use these to resolve an Oracle product ID from an iPaaS.com product identifier.
GetProductExternalIdByItemNumber
What it does: Looks up an Oracle product by item number and returns its Oracle product ID (the inventory item ID Oracle uses as the external ID). Returns nothing if the item number is empty or no product matches.
Signature: Task<string> GetProductExternalIdByItemNumber(string ItemNumber)
How to call it: await GetProductExternalIdByItemNumber(ItemNumber)
Parameter | Type | Required | Default | Description |
ItemNumber |
| Yes | N/A | The iPaaS.com product item number used to look up the Oracle product. |
Returns: string. The Oracle product ID, or nothing if no product matches.
Example: await GetProductExternalIdByItemNumber("ABC123") returns the Oracle product ID for item number ABC123.
When to use it: When mapping a product reference to Oracle and you have the item number but need the Oracle product ID.
GetOracleProductBySku
What it does: Looks up an Oracle product by SKU and returns its Oracle product ID. Returns nothing if the SKU is empty or no product matches.
Signature: Task<string> GetOracleProductBySku(string Sku)
How to call it: await GetOracleProductBySku(Sku)
Parameter | Type | Required | Default | Description |
Sku |
| Yes | N/A | The iPaaS.com product SKU used to look up the Oracle product. |
Returns: string. The Oracle product ID, or nothing if no product matches.
Example: await GetOracleProductBySku("SKU123") returns the Oracle product ID for SKU SKU123.
When to use it: When mapping a product reference to Oracle and you have the product SKU but need the Oracle product ID.
Orders
Use these when preparing an Oracle order line during mapping.
GetOracleOrderHeaderIdByOrderNumber
What it does: Looks up an Oracle order by its order number and returns the Oracle order header ID. Returns nothing if no order matches.
Signature: Task<string> GetOracleOrderHeaderIdByOrderNumber(string OrderNumber)
How to call it: await GetOracleOrderHeaderIdByOrderNumber(OrderNumber)
Parameter | Type | Required | Default | Description |
OrderNumber |
| Yes | N/A | The order number used to look up the Oracle order. |
Returns: string. The Oracle order header ID, or nothing if no order matches.
Example: await GetOracleOrderHeaderIdByOrderNumber("ORD1001") returns the Oracle order header ID for order ORD1001.
When to use it: When mapping an order reference to Oracle and you have the order number but need the Oracle order header ID.
CalculateExtendedPrice
What it does: Multiplies a unit selling price by an ordered quantity and returns the extended price as text.
Signature: string CalculateExtendedPrice(string unitSellingPrice, string orderedQuantity)
How to call it: CalculateExtendedPrice(unitSellingPrice, orderedQuantity)
Parameter | Type | Required | Default | Description |
unitSellingPrice |
| Yes | N/A | The unit selling price of a single item, as text (for example |
orderedQuantity |
| Yes | N/A | The quantity ordered, as text (for example |
Returns: string. The extended price (unit price multiplied by quantity), as text.
Example: CalculateExtendedPrice("15.50", "4") returns "62.00".
When to use it: When mapping an order line and you need the extended (line total) price from a unit price and quantity.
Locations
Use this to resolve an iPaaS.com location ID from a location name.
GetLocationIdByName
What it does: Looks up an iPaaS.com location by name and returns its iPaaS.com location ID. Returns nothing if the name is empty or no location matches.
Signature: Task<string> GetLocationIdByName(string LocationName)
How to call it: await GetLocationIdByName(LocationName)
Parameter | Type | Required | Default | Description |
LocationName |
| Yes | N/A | The iPaaS.com location name to look up. |
Returns: string. The iPaaS.com location ID, or nothing if no location matches.
Example: await GetLocationIdByName("New York") returns the iPaaS.com location ID for "New York".
When to use it: When mapping a location by name and you need its iPaaS.com location ID.
Custom Fields
Use this to read a value from a record's custom fields.
GetValueFromCustomField
What it does: Reads the value of a named custom field from a custom field object. Returns nothing if the field is not present or has no value.
Signature: object GetValueFromCustomField(object customFieldObj, object textFieldName)
How to call it: GetValueFromCustomField(customFieldObj, textFieldName)
Parameter | Type | Required | Default | Description |
customFieldObj |
| Yes | N/A | The Oracle ERP custom field object (for example a record's additional properties) to read from. |
textFieldName |
| Yes | N/A | The name of the Oracle ERP custom field to retrieve. |
Returns: object. The custom field's value, or nothing if the field is not present or has no value.
Example: For a custom field object containing Active_Web_User set to "true", GetValueFromCustomField(customFieldObj, "Active_Web_User") returns "true".
When to use it: When mapping a value out of a record's custom fields in Oracle ERP.