APEX

Description:
Hello Oracle Support,

We are experiencing an issue with APEX Mail on our Autonomous Database (ap-mumbai-1 region). Emails are successfully being queued into APEX_MAIL_QUEUE, but they are not being sent. The MAIL_SEND_COUNT remains 0 and no errors appear in MAIL_SEND_ERROR.

Steps Taken:

1. Configured SMTP parameters using **APEX_INSTANCE_ADMIN.SET_PARAMETER**:
   • SMTP_HOST_ADDRESS = **smtp.email.ap-mumbai-1.oci.oraclecloud.com**
   • SMTP_PORT = **587**
   • SMTP_TLS_ENABLED = Y
   • SMTP_USERNAME and SMTP_PASSWORD set with OCI Email Delivery credentials.
   • 
2. Verified sender domain is approved in OCI Email Delivery (vedant.farde@scott-sheldon.com).
3. Tested using:

BEGIN 
apex_mail.send( 
p_from => 'vedant.farde@scott-sheldon.com', 
p_to => 'vedantfarde@gmail.com', 
p_subj => 'APEX SMTP Test', 
p_body => 'If you see this, SMTP is working!' 
); 
apex_mail.push_queue; 
END; 
/  

1. → Mail remains stuck in APEX_MAIL_QUEUE.

2. Tried checking USER_SCHEDULER_JOB_RUN_DETAILS for mail jobs, but in Autonomous DB these views are not exposed.
   3. Also tried manual pushing of mails Apex_mail.push_queue → run without error → still not any email send.

   

Observed Behavior:

• Mail entries are created in APEX_MAIL_QUEUE.
• MAIL_SEND_COUNT = 0.
• No errors recorded in MAIL_SEND_ERROR.
• Mails never leave the queue.