Description of problem:

On Openshift on Openstack we are regularly testing OSP16.1 passed_phase2. Recently, new puddle RHOS-16.1-RHEL-8-20220917.n.0 was tagged and the overcloud deployment started to fail with below error:

TASK [octavia-overcloud-config : include_tasks] ********************************
Saturday 24 September 2022  03:28:05 +0000 (0:00:00.161)       0:01:26.704 **** 
fatal: [controller-0]: FAILED! => {\"reason\": \"couldn't resolve module/action 'openstack.cloud.security_group_rule'. This often indicates a misspelling, missing collection, or incorrect module path.\
\
The error appears to be in '/usr/share/ansible/roles/octavia-overcloud-config/tasks/network.yml': line 107, column 3, but may\
be elsewhere in the file depending on the exact syntax problem.\
\
The offending line appears to be:\
\
\
- name: create security group rule for log offloading\
  ^ here\
\"}

This error was introduced by this BZ: https://bugzilla.redhat.com/show_bug.cgi?id=2056892 


Version-Release number of selected component (if applicable): RHOS-16.1-RHEL-8-20220917.n.0


How reproducible: Always


Steps to Reproduce: Deploy overcloud with 16.1 passed_phase2 openstack puddle.

Actual results: Overcloud deployment failed.


Expected results: Successful installation.


Additional info: It is observed that package ansible-collections-openstack.noarch package is installed on OSP16.2 undercloud but it is not installed on OSP16.1 undercloud in the automation. Furthermore, the change introduced by the fix of https://bugzilla.redhat.com/show_bug.cgi?id=2056892 looks like the first usage of the openstack.cloud collection in 16.1 tripleo. playbooks.