Skip to Main Content

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!

I am using apex 21.1 and my mails are getting stuck in the apex queue.

pauljohnyNov 20 2021

I am using oracle 18xe and apex 21.1
i Follow the following steps for configuring emailing in our system.
https://stackoverflow.com/questions/58329525/how-to-send-email-from-oracle-apex-using-mailgun
Now when i send the email the email gets stuck in the mail queue.
I am using mailgun as gateway provider and aws cloud as the cloud machine.
Not sure why is our email getting suck .Apex_mail_queue shows the stuck emails.. Can some one guide ..Apex_mail_log donot show any logs...
And this is how the network_acls privileges are ..
L> select host,lower_port,upper_port,acl from dba_network_acls
localhost 25 25 /sys/acls/apex.xml
172.31.18.117 80 80 /sys/acls/apex.xml

And this are the current acl privilegs
QL> /

/sys/acls/apex.xml 0000000080002814 APEX_210100 connect true false
20-NOV-21 04.57.52.111000 PM SYS

/sys/acls/apex.xml 0000000080002814 INS100 connect true false
SYS

SQL> L
1 select *
2* from dba_network_acl_privileges
SQL>
Me have posted this since trying to trouble shoot where the issue is .
Thanks and regards
Paul j

This post has been answered by msammour on Nov 23 2021
Jump to Answer
Comments
Post Details
Added on Nov 20 2021
18 comments
4,606 views