Env: OCI ADW
APEX: 23.1
I am trying to use the new (amazing) feature of Push Notification
Code:
apex_pwa.send_push_notification (
p_application_id => :APP_ID,
p_user_name => <USER>
p_title => 'Notification Title2',
p_body => 'Notification Body2' );
Code is working well.
However, all the notifications are queuing up with ORA-24247
I've done the security code in the PWA app
declare
l_principal varchar2(20) := 'APEX_230100'; -- Replace with current APEX user
l_hosts apex_t_varchar2 := apex_t_varchar2(
'*.push.apple.com',
'*.notify.windows.com',
'updates.push.services.mozilla.com',
'android.googleapis.com',
'fcm.googleapis.com' );
begin
for j in ( select column_value as hostname from table(l_hosts) ) loop
dbms_network_acl_admin.append_host_ace (
host => j.hostname,
lower_port => 443,
upper_port => 443,
ace => xs$ace_type(
privilege_list => xs$name_list('connect'),
principal_name => l_principal,
principal_type => xs_acl.ptype_db) );
dbms_network_acl_admin.append_host_ace (
host => j.hostname,
ace => xs$ace_type(
privilege_list => xs$name_list('resolve'),
principal_name => l_principal,
principal_type => xs_acl.ptype_db) );
dbms_network_acl_admin.append_host_ace (
host => j.hostname,
lower_port => 443,
upper_port => 443,
ace => xs$ace_type(
privilege_list => xs$name_list('http'),
principal_name => l_principal,
principal_type => xs_acl.ptype_db) );
end loop;
end;
But the issue still exists… I cannot figure out a way to solve it.

Any ideas about what I am doing wrong here?
Again, this is an ADW Free plan env.
Thanks,
Lior