Service Limits
Review the following service limits for Oracle Integration 3 resources. A service limit is the quota or allowance set on a resource. You cannot change the service limits configured for your tenancy.
The service limits described below are enforced.
Oracle Cloud Infrastructure Console Service Limits
For more Oracle Cloud Infrastructure Console service limits, see Service Limits in the OCI documentation.
Resource | Service Limit |
---|---|
Integration service instance count |
200 service instances per region. Note: This value is the number of service instances you provision per region, and not the number of integration instances (for example, application and schedule) that you activate and monitor under the Observability tab in Oracle Integration. |
Service instance creation |
The ability to create service instances outside your home region depends on several factors. See Restrictions. |
Private endpoint limits |
|
Custom endpoints - maximum number |
1 custom endpoint |
Oracle Integration internal diagnostic logs retention in Oracle Cloud Infrastructure Logging |
Retained for 30 days for debugging use. See Logging Analytics. |
Component: Adapters
Resource | Service Limit |
---|---|
For structured payloads delivered on trigger connections or as a response from invoke connections | 100 MB limit for cloud endpoints (not using the connectivity agent). The limit is 100 MB if the endpoint is enabled with a private endpoint. |
For binary (unstructured) payloads (for example, attachments, MTOM) | 1 GB limit for trigger connections and responses from invoke connections. |
For connectivity agent-based adapters, the payload limits for structured payload (JSON, XML). | 50 MB limit for SOAP and REST.
For file and FTP with the connectivity agent, the limit for an invoke response is 50 MB for structured payloads. For any other protocol (for example, database, JMS, MQ, Kafka, and others), the payload limit is 10 MB for structured payloads. |
File Adapter - file size | Read File operation:
Polling with the connectivity agent: 50 MB Download File operation: 1 GB Note
The size of CSV files increases when translated into a message. Therefore, the file size must be less than 50 MB, so that the after-translation message size does not exceed 50 MB. |
FTP Adapter - file size |
For invoke configurations Read File operation:
Download File operation: 1 GB (when used both with or without a connectivity agent). Write File operation: There is no limit. |
REST Adapter |
For trigger configurations
For invoke configurations
|
REST-Based Adapters (Adapters that expose REST endpoints on the inbound or adapters invoking external REST endpoints. For example, Oracle Commerce Cloud Adapter, Oracle Field Service Cloud Adapter, and so on.) |
For trigger configurations (wherever applicable)
For invoke configurations (wherever applicable)
|
SOAP Adapter |
For trigger configurations
For invoke configurations
|
SOAP-Based Adapters (Adapters that expose SOAP endpoints on the inbound or adapters invoking external SOAP endpoints. For example, Oracle Logistics Adapter.) |
For trigger configurations (wherever applicable)
For invoke configurations (wherever applicable)
|
Database Adapters (Oracle Database Adapter, IBM DB2 Adapter, Microsoft SQL Server Adapter, MySQL Adapter, Netezza Adapter, PostgreSQL Adapter, Oracle Autonomous Data Warehouse Adapter, Oracle Autonomous Transaction Processing Adapter, Oracle Database Cloud Service Adapter, SAP ASE (Sybase) Adapter, and Snowflake Adapter) |
For trigger configurations
For invoke configurations
|
JMS Adapters (Oracle WebLogic JMS Adapter and IBM MQ Series JMS Adapter) |
For trigger configurations
For invoke configurations
|
Apache Kafka Adapter |
For invoke configurations
|
Oracle E-Business Suite Adapter |
|
SAP Adapter | 50 MB
For the SAP Adapter as a trigger connection, the limit is 50 MB for all document types. . |
Oracle CPQ Adapter - response payload | 50 MB. |
AS2 Adapter file size limit | 10 MB. |
Timeouts for all connectivity agent-based outbound adapter invocations | Connection timeout is set to 4 minutes. |
Timeouts for all outbound adapter invocations | The following values are set and cannot be changed:
|
Oracle Autonomous Data Warehouse Adapter, Oracle Autonomous Transaction Processing Adapter, Oracle Database Cloud Service Adapter, MySQL Adapter, Microsoft SQL Server Adapter, Oracle Database Adapter, and IBM DB2 Adapter | Starting with the August 2021 release, all new integrations that include stored procedure or PureSQL database operations must finish within 240 seconds. Otherwise, the query times out. |
Salesforce Adapter - batch file size | 8 MB (10,000 records). See Process Large Data Sets Asynchronously with Different Bulk Operations. |
SAP Ariba Adapter | |
Connectivity agent - memory |
A minimum of 8 GB memory with 4 GB of heap size dedicated to the on-premise agent's Java Virtual Machine (JVM). To include any other processes on the host besides the agent, increase the physical memory to a value greater than 8 GB. |
Connectivity agent - message payload |
10 MB, through the use of compression. All connectivity-agent-enabled adapters
SOAP and REST adapters configured with connectivity agent
|
Component: Integrations
Resource | Service Limit |
---|---|
Active integrations limit | 800.
See Activate an Integration in Using Integrations in Oracle Integration 3. |
Integration invocation depth | 16 invocations.
For example, a parent integration (schedule integration) invokes a child integration (application integration), which in turn recursively invokes the parent integration. Integration entry points along the request execution path are counted towards the limit. When 16 is exceeded, it results in an error. |
String size limit | Restricted to 10,000 characters.
The limit is applicable to all variables of type string, including global variables. The limit is also applicable to all functions, including a concat function used inside an assign, stitch, or mapper. |
Parallel action concurrency limits | Parallel action branches independent of the integration
type (synchronous, asynchronous, and so on) count towards the
concurrency limits on synchronous requests.
For example. a parallel action with three branches needs two extra concurrency slots for the duration of the parallel action; one branch is counted towards the original flow already obtained. |
Triggers (maximum number of concurrent requests) |
|
Maximum number of integrations that can subscribe to events | 50 integrations can subscribe to events per service instance. |
Maximum number of tracking events per integration instance |
After those limits are reached, events are no longer recorded in the activity stream, but they continue to be processed and the integration instance overall state is calculated. This ensures that the integration instance state is updated in all scenarios. |
Maximum activity stream payload sizes | The total payload size stored per integration instance in the activity stream is limited to 25 MB. There is no limit for payloads stored in the Object Store. Only payloads under 32k are stored in the activity stream. |
Maximum duration for integration flows |
|
Stage file action (in integrations) - file size |
Read Entire File operation: 100 MB. For files greater than 100 MB, use the Read File in Segments operation. Encrypt File operation: 1 GB. Decrypt File operation: 1 GB. |
Synchronous integration message timeout | 300 seconds.
Synchronous integrations (integrations that return a response payload) return a timeout error if they run more than 300 seconds. |
Oracle Integration Messaging - message size | 10 MB. |
Encode and decode file attachment content (mapper) | The functions encodeReferenceToBase64(String
reference) and decodeBase64ToReference(String
base64Content) have a file size limit of 10 MB.
|
Lookup column length | 1024 characters. |
Notification action - attachments size |
Both the email body and attachment are considered in calculating the total size. See Configure Notification Emails and Email Delivery Service Capabilities and Limits. |
Maximum number of outbound emails you can send from Oracle Integration in a rolling 24-hour window |
See Configure Notification Emails and Email Delivery Service Capabilities and Limits. |
JavaScript execution timeout threshold | 15 seconds. |
JavaScript function maximum parameter support | 20 parameters. |
Maximum duration of an XSLT execution | 120 seconds. |
Concurrency |
|
Number of concurrent integration instances of given schedule integration | 1 for scheduled and out-of-band and 1 for ad-hoc.
Where:
|
Tenant and user requests | 100 requests per second per tenant and 20 requests per second per user. |
Execution time threshold for long running schedule integrations | Terminated by Oracle Integration if integration exceeds 6 hours. See When a Schedule Integration Instance Gets Terminated in Using Integrations in Oracle Integration 3. |
Maximum number of iterations to execute for a while loop | 5000.
Note: There is no limit for a for-each loop. |
Maximum number of iterations captured across all loops for a single integration instance ID for which tracking data is captured | 1000. |
Project limits |
|
Deployments to Oracle Cloud Infrastructure API Gateway | An Oracle Cloud Infrastructure API Gateway instance supports a maximum of 20 deployments. Each deployment can contain up to 50 routes. This provides you with a capacity of 1000 integration endpoints to which to deploy. |
Maximum number of branches in a parallel action | 5. |
Tracking variable - value | 8191 characters. |
Service instance data retention | Retention is based on the trace level set during
integration activation:
|
Time window for recovering a failed integration instance that's recoverable | The integration instance is recoverable until one of the
following occurs:
|
Activity stream displayable rows | 5000 rows maximum are displayable when expanding the tree. |
Total size of activity stream (REST response) | No limit. |
Maximum number of integration instances shown on Instances and Errors pages | 500. |
Maximum number of tracking events per integration instance | 40,000. |
Maximum number of resubmissions allowed per integration instance ID | 10. |
Schedule parameter - value length | 256 characters. |
Maximum number of schedule parameters per integration | 5 parameters. |
Integration properties - value | 256 characters. |
Integration/Connection - name | 50 characters. |
Integration/Connection - package name | 50 characters. |
Integration/Connection - version | 10 characters. |
Integration/Connection - description | 1024 characters. |
B2B for Oracle Integration - Trading partner management and B2B message tracking |
See Manage Trading Partners and Track B2B Messages in Using B2B for Oracle Integration 3. |
Maximum offset supported (REST API) | 500 (Cannot be overridden). |
Maximum limit supported (REST API) | 500 (Cannot be overridden). |
Maximum timeout for a factory API | 2 minutes. |
Payload size for publishing and subscribing to events in integrations | The same limit supported by the inbound (trigger) adapter. See Component: Adapters. |
Component: Robotic Process Automation
Resource | Service limit |
---|---|
Maximum duration for a robot instance |
4 hours. |
Timeout for assigning a robot instance to an environment |
Varies, depending upon the environments:
|
Maximum wait time for downloading a file |
180 seconds by default but the robot builder can specify a different value while creating a robot. |
Maximum file size for downloading a file |
50 MB. |
Frequency at which the robot agent polls Oracle Integration for work |
15 seconds. |
Maximum time that Oracle Integration waits for the robot agent to poll for work before changing its environment's status to Unavailable |
35 seconds. |
Maximum number of environments in an environment pool |
100 environments. |
Character limits for robots |
|
Character limits for environment pools |
|
Character limits for robot connection types |
|
Character limits for robot connections |
|
Component: File Server
Resource | Service Limit |
---|---|
Storage | 500 GB. |
Concurrent connections | Maximum of 50 connections per service instance. |
Component: Process Automation
For Process Automation service limits, see Service Limits in Administering Oracle Cloud Infrastructure Process Automation.
Message Pack Usage and Synchronous Requests
The following table describes the request limits based on the number of message packs.
Message Packs Assigned | Synchronous Request Limit |
---|---|
6 | 600 |
5 | 500 |
4 | 400 |
3 | 300 |
2 | 200 |
1 | 100 |
When to Increase Message Packs
Examples | Message Packs |
---|---|
How quickly can a customer consume message packs with high synchronous concurrency? |
Assume a customer has 2 message packs assigned (10K
messages per hour). Each synchronous request takes 5 seconds to
complete. Therefore:
|
When is the 600 synchronous requests limit reached? |
The 600 concurrent synchronous request limit is
reached when the customer applies 6 message packs to the Oracle Integration instance. Consider
the following example in which each synchronous request takes 10
seconds to execute:
|
- Less than 5K messages per hour
- A burst of synchronous requests that exceed 100 messages