Ansible callback not working for Foreman due to SSL Error

I have a problem with Ansible callback plugin for Foreman. It cannot connect to Foreman.
I’m running Ansible commands on the Foreman machine not a different one.
When I try to run an ansible playbook to get facts to Foreman to provision new machines it shows the tasks are ok, but it cannot connect to Foreman itself with the following error:

HTTPSConnectionPool(host=‘formanek.k219.local’, port=443): Max retries exceeded with url: /api/v2/reports (Caused by SSLError(SSLError(1, ‘[SSL: TLSV1_ALERT_UNKNOWN_CA] tlsv1 alert unknown ca (_ssl.c:2354)’),))

I changed Foreman SSL using foreman-installer uploading my own CA and certs and I also made sure to add my Root and Intermediate CAs to system truststore but unfortunately that didn’t help.

I’m using the latest Foreman 3.0 and Proxy on CentOS Stream 8 x86_64.
The same goes for Ansible and Remote Execution plugins.
I also installed theforeman ansible collection.

Kindly please help,
Best Regards,