ATTACHMENT STORAGE Application Setting

Group.  GENERAL

Type.  Setting

Application.  PMS                      S&C

Description. Attachment Storage Option. Select one of two available options; BLOB or BFILE. BLOB file attachment storage will store attachments in the database and are subsequently not accessible outside of OPERA. BFILE file attachment storage will store attachments in a file on the database and are available from outside of OPERA.

Internal Name. ATTACHMENT_STORAGE

Property Determination. If a property were to choose BLOB, then the attachments are stored as BLOB and would require a BLOB schema to save the attachments into the database. The schema is specified with the General>Attachment Schema Name application setting and the setting value gets updated when the SMTP tool creates the BLOB schema.

If the property were to choose BFILE, then the attachments are stored as BFILE and would require an ORACLE directory to store the physical file. The directory name is specified with the General>Attachment Directory Name application setting.

Activation / Inactivation Rules.	When ATTACHMENT STORAGE is changed to BLOB, verify the existence of the ATTACHMENT SCHEMA NAME and the BLOB ATTACHMENT table.
Available Values.	BLOB or BFILE
Add On Licenses/Country Specifics.	<none>
Other Application Settings.	Available when the General>File Attachment application function is set to Y.

Affected Areas

Menus / Screens / Fields.	Utilities>Property Config>Change Attachment Storage Attachment Move User Activity Log
Reports & Report Forms.	<none>
Permissions.	<none>
Other Areas.	<none>