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?
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.