On the General Database Settings tab, define the following settings:
EMAIL_ACCOUNT
Email account within the company mail system. Email sender address of Smart Materials (for example, smat-db@ingr.com), needed for all email communication.
LOG_EMAIL_HANDLING
If LOG_EMAIL_HANDLING is set to Y, communication with the mail server is protocoled in a log file for debugging purpose. Errors will be written to the log file anyway. This feature is only available for mails sent to the quote desk.
LOG_FILE_DEST
This setting specifies the log file destination for online jobs and must point to the directory on the Oracle server where log files are stored. It must be accessible by the server processes through configuration as UTL_FILE_DIR directory in the instance initialization file.
To retrieve the value of UTL_FILE_DIR, execute the show parameter utl command in
SQL*Plus as SYS. You have the option to define this only here on a global basis, or
you can also specify this on a per-project basis with the parameter ZX_MAR_LOG.
If for a specific user environment, the parameter ZX_MAR_LOG is set, then LOG_FILE_DEST
from this screen will not be used.
SMTP_CLIENT
This is the alias name or IP address of the SMTP client (that is, the database server) that should be used for login to the SMTP server.
SMTP_HOST
This is the IP address (for example, 123.23.42.2) or alias name of the host (SMTP server) that will deliver outgoing emails.
SMTP_PASS
This setting sets the optional password of the system user account who connects to the SMTP_HOST in order to send emails. If no password is given, the email is sent out without transmitting the user/password. This is possible for SMTP servers that do not require authentication. If you try to deliver emails without a password to a protected server, you will receive a SecurityException: Access to default session denied error. If the user/password is unknown or incorrect, you will get an AuthenticationFailedException error.
SMTP_PORT
This setting is to set the number of the port to communicate with the SMTP_HOST. In most cases it is 25.
SMTP_USER
This is the system user account that connects to the SMTP_HOST in order to send emails. Only required if SMTP_PASS is set.