bad query: b"\n            SELECT\n                ap.partner_id,\n                SUM(\n                    CASE\n                        WHEN ap.currency_id = 19\n                        THEN lc.amount\n                        ELSE lc.amount * COALESCE(\n                            (SELECT rate FROM res_currency_rate\n                             WHERE currency_id = 19\n                             AND name <= lc.payment_date\n                             AND company_id = lc.company_id\n                             ORDER BY name DESC LIMIT 1),\n                            1.0\n                        ) / COALESCE(\n                            (SELECT rate FROM res_currency_rate\n                             WHERE currency_id = ap.currency_id\n                             AND name <= lc.payment_date\n                             AND company_id = lc.company_id\n                             ORDER BY name DESC LIMIT 1),\n                            1.0\n                        )\n                    END\n                ) as total_amount\n            FROM l10n_latam_check lc\n            INNER JOIN account_payment ap on ap.id = lc.payment_id\n            INNER JOIN account_journal aj ON aj.id = lc.current_journal_id\n            INNER JOIN account_payment_method_line apml ON apml.journal_id = aj.id\n            INNER JOIN account_payment_method apm ON apm.id = apml.payment_method_id\n            WHERE ap.partner_id IN ()\n                AND lc.company_id = 8\n                AND apm.code = 'in_third_party_checks'\n                AND lc.payment_date > '2026-01-05'::date\n            GROUP BY ap.partner_id\n            "
ERROR: syntax error at or near ")"
LINE 30:             WHERE ap.partner_id IN ()
                                             ^

Exception during request handling.
Traceback (most recent call last):
  File "/data/build/adhoc-cicd-odoo-odoo/odoo/http.py", line 2576, in __call__
    response = request._serve_db()
               ^^^^^^^^^^^^^^^^^^^
  File "/data/build/adhoc-cicd-odoo-odoo/odoo/http.py", line 2103, in _serve_db
    return self._transactioning(
           ^^^^^^^^^^^^^^^^^^^^^
  File "/data/build/adhoc-cicd-odoo-odoo/odoo/http.py", line 2166, in _transactioning
    return service_model.retrying(func, env=self.env)
           ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
  File "/data/build/adhoc-cicd-odoo-odoo/odoo/service/model.py", line 156, in retrying
    result = func()
             ^^^^^^
  File "/data/build/adhoc-cicd-odoo-odoo/odoo/http.py", line 2133, in _serve_ir_http
    response = self.dispatcher.dispatch(rule.endpoint, args)
               ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
  File "/data/build/adhoc-cicd-odoo-odoo/odoo/http.py", line 2381, in dispatch
    result = self.request.registry['ir.http']._dispatch(endpoint)
             ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
  File "/data/build/adhoc-cicd-odoo-odoo/odoo/addons/base/models/ir_http.py", line 333, in _dispatch
    result = endpoint(**request.params)
             ^^^^^^^^^^^^^^^^^^^^^^^^^^
  File "/data/build/adhoc-cicd-odoo-odoo/odoo/http.py", line 754, in route_wrapper
    result = endpoint(self, *args, **params_ok)
             ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
  File "/data/build/adhoc-cicd-odoo-odoo/addons/web/controllers/dataset.py", line 36, in call_kw
    return call_kw(request.env[model], method, args, kwargs)
           ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
  File "/data/build/adhoc-cicd-odoo-odoo/odoo/api.py", line 535, in call_kw
    result = getattr(recs, name)(*args, **kwargs)
             ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
  File "/data/build/adhoc-cicd-odoo-odoo/addons/web/models/models.py", line 1015, in onchange
    if field_name not in done and snapshot0.has_changed(field_name)
                                  ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
  File "/data/build/adhoc-cicd-odoo-odoo/addons/web/models/models.py", line 1128, in has_changed
    return self[field_name] != self.record[field_name]
                               ~~~~~~~~~~~^^^^^^^^^^^^
  File "/data/build/adhoc-cicd-odoo-odoo/odoo/models.py", line 7078, in __getitem__
    return self._fields[key].__get__(self)
           ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
  File "/data/build/adhoc-cicd-odoo-odoo/odoo/fields.py", line 1311, in __get__
    self.compute_value(recs)
  File "/data/build/adhoc-cicd-odoo-odoo/odoo/fields.py", line 1493, in compute_value
    records._compute_field_value(self)
  File "/data/build/adhoc-cicd-odoo-odoo/addons/mail/models/mail_thread.py", line 442, in _compute_field_value
    return super()._compute_field_value(field)
           ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
  File "/data/build/adhoc-cicd-odoo-odoo/odoo/models.py", line 5297, in _compute_field_value
    fields.determine(field.compute, self)
  File "/data/build/adhoc-cicd-odoo-odoo/odoo/fields.py", line 110, in determine
    return needle(*args)
           ^^^^^^^^^^^^^
  File "/data/build/ingadhoc-account-payment/l10n_latam_check_ux/models/res_partner.py", line 17, in _credit_debit_get
    self.env.cr.execute(
  File "/data/build/adhoc-cicd-odoo-odoo/odoo/sql_db.py", line 357, in execute
    res = self._obj.execute(query, params)
          ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
psycopg2.errors.SyntaxError: syntax error at or near ")"
LINE 30:             WHERE ap.partner_id IN ()
                                             ^