HOOT test "can handle command and disable mentions in AI composer" fails non-deterministically on runbot with the following error:

```
Cannot find a definition for model "hr.employee": could not get model from server environment (did you forget to use `defineModels()?`)
```

Somehow this test requires `hr.employee` model, which explained why it had `defineHrModels()`. This was replaced to enterprise livechat models, since new test need livechat and `hrModels` lacked livechat.

The way to `defineModels()` on modules with lots of dependency sucks: `hr` and `im_livechat` and `ai` have no explicit dependency among each other, but a module such as `test_discuss_full_enterprise` has to combine all of their behaviors and definitions. `defineModels()` is designed to extend a model by makin a subclass of a definition of same model in a dependent module, which is not practical here.

This commit doesn't solve the problem of defining livechat and hr models in the `test_discuss_full_enterprise` test suites, but for the quick and immediate fix it moves the problematic AI test in its own suite with `defineHrModels()`.

Fixes https://runbot.odoo.com/runbot/build/92414152

Forward-Port-Of: odoo/enterprise#98642

HOOT test "can handle command and disable mentions in AI composer" fails non-deterministically on runbot with the following error:

```
Cannot find a definition for model "hr.employee": could not get model from server environment (did you forget to use `defineModels()?`)
```

Somehow this test requires `hr.employee` model, which explained why it had `defineHrModels()`. This was replaced to enterprise livechat models, since new test need livechat and `hrModels` lacked livechat.

The way to `defineModels()` on modules with lots of dependency sucks: `hr` and `im_livechat` and `ai` have no explicit dependency among each other, but a module such as `test_discuss_full_enterprise` has to combine all of their behaviors and definitions. `defineModels()` is designed to extend a model by making a subclass of a definition of same model in a dependent module, which is not practical here.

This commit doesn't solve the problem of defining livechat and hr models in the `test_discuss_full_enterprise` test suites, but for the quick and immediate fix it moves the problematic AI test in its own suite with `defineHrModels()`.

Fixes https://runbot.odoo.com/runbot/build/92414152

If a res_partner_bank record shares an acc_number with other res_partner_bank records, even archived ones, the field duplicate_bank_partner_ids still includes partners from those archived records.

As a result, the contact page shows a banner indicating other partners use the same bank account, even though those res_partner_bank records have been archived.

Steps to reproduce the issue:

1. Create a new bank account which has the same bank account number as another bank account already associated to a partner
2. Assign this new bank account to another partner
3. Archive this new bank account
4. Go to the contact page of the partner (from step 1) which has a bank account with the same bank account number as the new bank account just created
5. A banner will pop up at the top of the contact saying that this partner uses the same bank account as the partner you set on the bank account in step 2

Solution:

Add a condition to the JOIN clause that checks “other.active = TRUE” to ensure that other res_partner_bank records to search for that have the same account number are active.

Also add a condition to the WHERE clause that checks “this.active = TRUE” to ensure that the current res_partner_bank record doing the search is active itself.

opw-4967083

Forward-Port-Of: odoo/odoo#232018
Forward-Port-Of: odoo/odoo#231585