To configure and manage email in Oracle Application Express, an Instance administrator must log in to Oracle Application Express Administration Services.
About Configuring Email
To enable Oracle Application Express to send email, an Instance administrator must configure email settings.
About Enabling Network Services
By default, the ability to interact with network services is disabled in Oracle Database 11g Release 1 or 2 or later. Therefore, if you are running Oracle Application Express with Oracle Database 11g Release 1 or 2 or later, you must use the new
DBMS_NETWORK_ACL_ADMIN package to grant connect privileges to any host for the
APEX_180200 database user. Failing to grant these privileges results in issues with:
Sending outbound mail in Oracle Application Express.
Using Web services in Oracle Application Express.
“Enabling Network Services in Oracle Database 11g or Later” for your installation scenario in Oracle Application Express Installation Guide:
"Configuring Email" in Oracle Application Express Administration Guide
About Configuring Email in a Full Development Environment
To configure Oracle Application Express to send mail in a full development environment your Instance administrator must log in to Oracle Application Express Administration Services, navigate to the Instance Settings page and configure Email attributes.
About Email Provisioning
You can configure Oracle Application Express to automatically email users their login credentials when a new workspace request has been approved. To accomplish this, you must complete the email configuration process and select the provisioning status, Request with Email Verification.
About the Mail Queue
Instance administrators can manage email sent from applications by monitoring email messages in the mail queue and mail log.
"Managing the Mail Queue" in Oracle Application Express Administration Guide
About the APEX_MAIL Package
You can send email from an Oracle Application Express application using the
APEX_MAIL package is built on top of the Oracle supplied
UTL_SMTP package. Because of this dependence, the
UTL_SMTP package must be installed and functioning to use APEX_MAIL.