search cancel

ODF_IDEA_V2 is not reflecting attributes created on the Idea Object


Article ID: 229586


Updated On:


Clarity PPM On Premise Clarity PPM SaaS


We have 400+ custom attributes in the Idea object, and notice that not all attributes are available in the ODF_IDEA_V2 view. Why is this?


Version: 15.9.2

DB Vendor: Oracle


Oracle only allows 1000 columns per view. One attribute in clarity can result in more than one column in the ODF_IDEA_V2 view. Hence, when there are large number of attributes in an object, not all of them would be available in the V2 view.

It is recommended in the documentation, that only 100 custom attributes be created in any object. If requirement arises to create more attributes, they can be grouped under sub objects.