In New User Experience when we open up the Financial Plan associated to a project the Department OBS column is Blank. if we access the same Cost Plan in Classic UI we don't see any issues and the department is populated correctly for the resource.
This creates a lot of confusion for PM's who are using the New User Experience thinking that the Department is not set-up properly for few resources.
This is related to the total number of Departments associated with the Entity. New User Experience uses an internal NSQL query to fetch and populate the Department OBS column on Cost Plan details. By default we have a governor limit of 50000 rows which any NSQL query can fetch. If your departments exceed the amount of 50000 we would see this issue in New User Experience.
1. Login to Clarity PPM Application server.
2. Navigate to $NIKU_HOME/config and edit governors.properties file.
3. Modify the value under row named "Maximum row limit for Objects and NSQL Portlets" from 50000 to the Max count of your departments.
<Please see attached file for image>
Note :- This setting applies to all the NSQL portlets and Object based Portlets in the system and will cause a performance impact to the system if increased in-appropriately.
More Information can be found at KB000009826.