Column "fiscal_category_id" is of type integer but expression is of type record

[Carlos Almeida]

Para replicar:
1. Criar prospeto, inserir assunto, nome da empresa, nome do contato, país e estado
2. Converter para oportunidade (criando novo cliente)
3. Converter em cotação, seleccionando check box (opção) "Ganhamos!"

ERRO
------------------------------------------------------
OpenERP Server Error
Client Traceback (most recent call last):
  File "/home/carlosalmeida/openerp-7.0/openerp-web/addons/web/http.py", line 204, in dispatch
    response["result"] = method(self, **self.params)
  File "/home/carlosalmeida/openerp-7.0/openerp-web/addons/web/controllers/main.py", line 1134, in call_button
    action = self._call_kw(req, model, method, args, {})
  File "/home/carlosalmeida/openerp-7.0/openerp-web/addons/web/controllers/main.py", line 1122, in _call_kw
    return getattr(req.session.model(model), method)(*args, **kwargs)
  File "/home/carlosalmeida/openerp-7.0/openerp-web/addons/web/session.py", line 42, in proxy
    result = self.proxy.execute_kw(self.session._db, self.session._uid, self.session._password, self.model, method, args, kw)
  File "/home/carlosalmeida/openerp-7.0/openerp-web/addons/web/session.py", line 30, in proxy_method
    result = self.session.send(self.service_name, method, *args)
  File "/home/carlosalmeida/openerp-7.0/openerp-web/addons/web/session.py", line 103, in send
    raise xmlrpclib.Fault(openerp.tools.ustr(e), formatted_info)

Server Traceback (most recent call last):
  File "/home/carlosalmeida/openerp-7.0/openerp-web/addons/web/session.py", line 89, in send
    return openerp.netsvc.dispatch_rpc(service_name, method, args)
  File "/home/carlosalmeida/workspace/OpenERP 7.0/openerp-7.0/openerp/netsvc.py", line 292, in dispatch_rpc
    result = ExportService.getService(service_name).dispatch(method, params)
  File "/home/carlosalmeida/workspace/OpenERP 7.0/openerp-7.0/openerp/service/web_services.py", line 626, in dispatch
    res = fn(db, uid, *params)
  File "/home/carlosalmeida/workspace/OpenERP 7.0/openerp-7.0/openerp/osv/osv.py", line 188, in execute_kw
    return self.execute(db, uid, obj, method, *args, **kw or {})
  File "/home/carlosalmeida/workspace/OpenERP 7.0/openerp-7.0/openerp/osv/osv.py", line 131, in wrapper
    return f(self, dbname, *args, **kwargs)
  File "/home/carlosalmeida/workspace/OpenERP 7.0/openerp-7.0/openerp/osv/osv.py", line 197, in execute
    res = self.execute_cr(cr, uid, obj, method, *args, **kw)
  File "/home/carlosalmeida/workspace/OpenERP 7.0/openerp-7.0/openerp/osv/osv.py", line 185, in execute_cr
    return getattr(object, method)(cr, uid, *args, **kw)
  File "/home/carlosalmeida/openerp-7.0/addons/sale_crm/wizard/crm_make_sale.py", line 106, in makeOrder
    new_id = sale_obj.create(cr, uid, vals, context=context)
  File "/home/carlosalmeida/openerp-7.0/addons/sale_stock/sale_stock.py", line 75, in create
    order = super(sale_order, self).create(cr, uid, vals, context=context)
  File "/home/carlosalmeida/openerp-7.0/addons/sale/sale.py", line 336, in create
    return super(sale_order, self).create(cr, uid, vals, context=context)
  File "/home/carlosalmeida/openerp-7.0/addons/mail/mail_thread.py", line 242, in create
    thread_id = super(mail_thread, self).create(cr, uid, values, context=context)
  File "/home/carlosalmeida/workspace/OpenERP 7.0/openerp-7.0/openerp/osv/orm.py", line 4434, in create
    cr.execute('insert into "'+self._table+'" (id'+upd0+") values ("+str(id_new)+upd1+')', tuple(upd2))
  File "/home/carlosalmeida/workspace/OpenERP 7.0/openerp-7.0/openerp/sql_db.py", line 161, in wrapper
    return f(self, *args, **kwargs)
  File "/home/carlosalmeida/workspace/OpenERP 7.0/openerp-7.0/openerp/sql_db.py", line 226, in execute
    res = self._obj.execute(query, params)
ProgrammingError: column "fiscal_category_id" is of type integer but expression is of type record
LINE 1: ...Oportunidade: 1','direct','manual',NULL,'order',8,(1, 'Venda...
                                                             ^
HINT: You will need to rewrite or cast the expression.

[Carlos Almeida (cmsa)]

Convém fazer a resolução da forma como fiz, pois se só retirarmos o [0] ao criarmos a SO sem ser da oportunidade dá erro por faltar o [0].