APEX

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

Mail still in Mail Queue without error's but not received in mailbox

Ananthu V BSep 14 2024 — edited Sep 14 2024

Hi All,

I am trying to set SMTP in our Apex Oracle 23.1 setup. However, after the configurations, the mail is still in the queue without errors and have not receive the mail in the inbox.

The current setup is between our ms365 SMTP setup with an app password.

I have shared the steps that I did:-

Downloaded the ms365 root certificate and placed in the wallet folder and uploaded in the oracle wallet.
```
  ![](https://objectstorage.us-phoenix-1.oraclecloud.com/p/8XchFSZkjz8qO4p8uxTZOqA0LbZbAcrp1MON3Ph8P79VRQLjAIsR8S0ieDkLokBl/n/axciphqpnohg/b/forums-prod-www/o/attachments/yFCknIIp-6984-FHKqmmxE)
```
1. Created the ACL rules with SYS@PDB and created the rules.
1. Added the smtp host, username, app password and wallet setup.

4. Triggered the mail from SQL and pushed it to the queue.

No error's in a queue or job, still the mail not sent to the inbox. Can anyone please help me to resolve the issue?

Added on Sep 14 2024

#apex-discussions, #apexemail, #email, #oracle-apex

18 comments

249 views

2 mentions