ODF_IDEA_V2 is not reflecting attributes created on the Idea Object

Products

• Clarity PPM On Premise
• Clarity PPM SaaS

Issue/Introduction

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?

Environment

Version: 15.9.2

DB Vendor: Oracle

Resolution

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.