Odoo Help


This community is for beginners and experts willing to share their Odoo knowledge. It's not a forum to discuss ideas, but a knowledge base of questions and their answers.


ValueError: Expected singleton

on 6/23/16, 10:37 AM 967 views


This is my function: 

def _concat_nit(self):

# Executing only for Document Type 31 (NIT)
if self.doctype is 31: # <--------------- THIS IS LINE 147
# First check if entered value is valid
# Instead of showing "False" we put en empty string
if self.xidentification is False:
self.xidentification = ''
self.formatedNit = ''
# Formatting the NIT: xx.xxx.xxx-x
s = str(self.xidentification)[::-1]
newnit = '.'.join(s[i:i+3] for i in range(0, len(s), 3))
newnit = newnit[::-1]
nitList = [
# Calling the NIT Function which creates the Verification Code:
formatedNitList = []
for item in nitList:
if item is not '':
self.formatedNit = '-' .join(formatedNitList)
# Saving Verification digit in a proper field
self.dv = nitList[1]

But I get the following error: 

File "/home/travis/build/OCA/l10n-colombia/l10n_co_res_partner/models/l10n_co_res_partner.py", line 147, in _concat_nit
if self.doctype is 31:
File "/home/travis/odoo-9.0/openerp/fields.py", line 819, in __get__
File "/home/travis/odoo-9.0/openerp/models.py", line 5403, in ensure_one
raise ValueError("Expected singleton: %s" % self)

ValueError: Expected singleton: res.partner(3, 7, 17, 32, 22, 21, 6, 18, 16, 14, 19, 20, 13, 11, 29, 35, 28, 8, 23, 24, 34, 25, 9, 26, 27, 39, 38, 15, 33, 37, 43, 5, 4, 42, 10, 30, 31, 12, 36, 1, 40, 41)

I have no clue why I get this error? Actually the function works in the interface, but Travis is complaining: https://travis-ci.org/OCA/l10n-colombia/jobs/139356438#L645

Any Ideas on how to fix this issue? 



| 4 3 5
Hyderabad, India

On 6/24/16, 1:42 AM


here in _concat_init you are getting list of res.partner object and when you are trying to access doctype off it, its not able to perform that as it is "list of objects".

So what you can do is,

1) As suggested by Baiju,

2) loop through self and check for each record as:

    def _concat_nit(self):
         for record in self:
             if record.doctype is 31:
                 # Further code goes here, use record instead of self......

Hope this will help you...

This was it! Thank you :-) fixed the problem

on 6/24/16, 10:19 AM


| 5 4 8
Kochi, India
ODOO technical and functional

        I like learning new thing, especially technical thing. I am a quick learner, I can learn technical things very fast. I have good logical skill,  I have immense interest in programming.

e-mail id : baijuks@hotmail.com

On 6/23/16, 11:58 AM


Try giving @api.one decorator for the method.

     def _concat_nit(self):

This decorator loops automatically on Records of RecordSet for you. Self is redefined as current record:


try iterating with for loop

     for record in self:

        if record.doctype is 31: # <--------------- THIS IS LINE 147
             # First check if entered value is valid

Hopes this solves the problem.

On 6/23/16, 12:31 PM

Thanks for your answer. Yes, with api.one it works, BUT api.one is deprecated in Odoo9, so I don't want to use it. Any other ideas? 

Checking other resources I see that it might be an issue with a loop?

Your Answer

Please try to give a substantial answer. If you wanted to comment on the question or answer, just use the commenting tool. Please remember that you can always revise your answers - no need to answer the same question twice. Also, please don't forget to vote - it really helps to select the best questions and answers!

About This Community

This community is for professionals and enthusiasts of our products and services. Read Guidelines

Question tools

1 follower(s)


Asked: 6/23/16, 10:37 AM
Seen: 967 times
Last updated: 6/24/16, 10:19 AM