User is trying to assign Role Availability for Investment Subobject in Clarity Process Flows. Attempting to configure object roles on a custom subobject of the Investment object, but the Manager role (and others) are not available for selection, especially when a similar activity for the Project subobject yields the object role results.
Clarity PPM
This behavior stems from a limitation in using the abstract Investment object as the parent.
A SQL trace shows that when running the query below in the context of a **Project subobject**, role values are successfully returned:
```sql
SELECT ID, NAME
FROM CMN_LOOKUPS_V
WHERE LOOKUP_TYPE = 'PRJ_PROFILES'
AND LANGUAGE_CODE = 'en'
AND IS_ACTIVE = 1;
```
These results include roles such as **Manager**, **Participants**, and **Staff**.
However, when the same query is run in the context of the **Investment subobject**, no results are returned.
This behavior is expected and relates to the design of the application going back to its early architecture (2003):
Recommendation