Upload Large Attachments to Object Storage

By default, an attachment is uploaded and stored in the database along with its entire content. Prior to this release, the process of uploading very large content like videos etc. was often limited by memory constraints. In addition, storing large content in the database is costly.

As of this release, the upload process has been enhanced to support an optional configurable threshold above which content is stored in Oracle Cloud Infrastructure Object Storage and a link to the file is kept on the attachment record.

To enable this functionality, define the object storage attachment location and threshold size in the General System Configuration feature configuration. In addition, you may also use the same feature configuration to set a maximum aggregate size for concurrent attachment uploads for performance reasons.

In cloud implementations, this configuration is required to upload large attachments due to stricter resource limits.

In on-premises implementations, this feature is an opt in. If such configuration is provided then large attachments are stored in Object Storage, else they are stored in the database subject to existing resource limitations if any.

The following are known limitations with storing content in Object Storage:

• The responsibility for data recovery of attachment content shifts to the customer as part of their Object Storage files management. 
• Custom logic if any that relies on attachment content to exist in the database will not work for attachments stored in Object Storage.

Supporting the upload of large attachments allow users to upload videos and similar large files needed to perform certain tasks.

Steps to Enable

To enable this feature, complete these steps:

1. Add the Attachment Location option to the General System Configuration feature configuration.
2. Set the Attachment Threshold Size option on the same feature configuration.
3. Optionally, set the Maximum Attachment Aggregate Size option on the same feature configuration.