Limits on Time or Size of Certain Services
Oracle Utilities cloud services have some time and data size limits.
In the online application, pages have a default timeout limit of two minutes. This is to prevent an endlessly running transaction, and is often an indication that there is an underlying performance issue (for instance a slow-running SQL) or inherent limit on how much work can be accomplished in the time period (such as attempting to generate a bill online for an account with hundreds of service agreements, which should be done in batch).
Analytics Publisher Limits
The table below lists a number of pre-set limits in Analytics Publisher for reporting:
| Process/Report | Limit |
|---|---|
| Execution of SQL to build an Online report | 10 minutes |
| Execution of SQLto build a report (Scheduled (offline) report output) | 30 minutes |
| Number of concurrent reports | 10 |
| XML format report output | 500MB |
| CSV format report output | 1,000,000 Rows |
| Online/Browser report output | 300MB |
| Scheduled (offline) report output | 500MB |
| Database Storage | 100GB |
Attachment Limits
The size limit for attachments in the Oracle Utilities cloud services database is 25MB. Support is available for attachments larger than 25MB using Oracle Cloud Object Storage.
Batch Processing Limits
The table below lists SQL timeouts for batch processing for different types of thread pool workers.
| Thread Pool Worker | SQL Timeout |
|---|---|
| NOCACHE TPW | 15 minutes and 30 seconds* |
| DEFAULT TPW | 15 minutes and 30 seconds* |
Business Log Processing Limits
Business logs are maintained per customer tenancy and are segregated for Staging and Prod partitions. Business logs are captured for batch and user logs (online and integration) separately. The retention period for business user logs is up to 15 days of data (30 days for batch logs) with a limit of 7,000 messages per minute. If your logs generate more than 7,000 messages per minute, this limit will be proportionally smaller to reflect the volume of data.
Identity Domain Limits
As part of your cloud service, the Identity Domain subscription type is Oracle Apps Identity Domain. Please refer to Limits BY Service in the Oracle Cloud Infrastructure documentation for limits associated with this domain subscription type.
OCI Email Delivery Limitations
The following limitations apply to OCI email delivery subscriptions included with your cloud service:
- Daily limit of 100 emails / Partition (prod/non-prod)
- Sending rate of 10 emails per minute
- 2 MB maximum message size including base64 encoding and headers
- Maximum of 10 recipients per email (in the TO:, CC:, or BCC: fields)
Oracle REST Data Services Limits
The table below lists a number of pre-set limits related to use of Oracle REST Data Services (ORDS), including Database Actions (formerly known as SQL Developer Web):
| Process | Limit |
|---|---|
| Database Actions Online Query Timeout | 15 minutes |
| ORDS REST Query Timeout | 15 minutes |
| ORDS HTTP Timeout | 5 minutes (default) |
Web Service Limits
The table below lists a number of pre-set limits related to use of web services:
| Process | Default | Limit |
|---|---|---|
| Web Service Call | 2 minutes | 5 minutes* |
Note:
Customers and implementers should review any HTTP request that is timing out as this would suggest the underlying service has issues and consider asynchronous methods vs synchronous where appropriate.Note:
Using Inbound Web Services for data loading to your cloud service may have an impact on overall processing capacity and is not recommended.