Installation Instructions for Integration Setup
Go to Subscriptions Management> Subscriptions and click Search Certified Integration Marketplace and Subscribe.
Click the Oracle ERP Integration title.
On the Subscription Detail page, click the Subscribe button.
Enter the Name of the subscription and select a Version. It can be set to any relevant and unique subscription name within the company where this subscription is created.
Format: [Product Name] - [Environment/Purpose]
Example: Oracle ERP – Release
Select Create Default Mappings (recommended). If you don’t want to create default mappings and want to create all mappings from scratch by yourself, then uncheck this box.
Provide the API endpoint for your Oracle ERP instance.
Test/Sandbox:
https://oracletest.hortonww.com:443Production: Provided by the client.
Enter your Username and Password.
Enter the value of Customer Address Fields to Match, a comma-separated list of address fields (for example, address_1,postal_code,city). The integration uses these fields to identify duplicate customer addresses. Two addresses are considered the same only if all specified fields match.
Enter the value of Product Search Poll Days, the number of days of historical product data to retrieve during the initial poll. For example, entering 100 retrieves product records from the past 100 days. If left blank, the system defaults to 4 days.
Enter the value of Product Inventory Search Poll Days, the number of days of historical inventory data to retrieve during the initial poll.
Enter the value of Company Search Poll Days, the number of days of historical company data to retrieve during the initial poll.
Enter the value of Time Offset. This is the number of hours to shift from UTC to match your local time zone. This ensures date and time values align correctly when exchanging data between systems.
Enter the value of Transaction Search Poll Days, the number of days of historical transaction data to retrieve during the initial poll.
Enter the value of Transaction Tracking Search Poll Days, the number of days of historical shipment data to retrieve during the initial poll. If left blank, the system defaults to 4 days.
Enter the API Throttle Limit. This setting prevents any single integration or user from overwhelming the system with too many requests. It protects system performance by controlling the number of API requests that can run simultaneously, ensuring fair usage.
Recommended Values
Initial Setup: 5
Ongoing Operations: 500
High Volume: 500
Enter the API Throttle Seconds. This defines the time window during which the API Throttle Limit is measured. If an integration makes too many requests within this time window, additional requests are rejected until the window resets.
Default Value: 60 seconds
Range: 60 seconds
Enter the number of Concurrent Connections. This specifies the maximum number of simultaneous API connections that the subscription can process for a user or integration. If this limit is exceeded, new requests are queued or rejected until a currently active connection finishes.
Default Value: 5
Range: 10
Enter the number of Concurrent Batch Executions. This specifies the maximum number of simultaneous batch executions that can be processed for an integration at one time. If this limit is exceeded, new requests are queued or rejected until a currently active connection finishes.
Default Value: 5
Range: 10
Click Apply to save the settings.
Post-Installation Verification
After completing the installation, perform these tests to verify the installation.
Data Sync Test
Initiate a sample data pull. (To iPaaS.com).
Initiate a sample data push. (From iPaaS.com).
Functionality Test
Run an end-to-end business process.
Validate key features like field mappings, workflow triggers, and logging.
Review integration logs in iPaaS.com.
Support and Troubleshooting
Click the Help button on any iPaaS.com page to contact Support or to search our documentation.
Documentation: Search our documentation at the top of this article
Support Portal: Click the Help and Support button at the lower-right of this window.
Contact Information: Contact iPaaS.com.



