Staffing - Allocations by Investment / Resource - top grid does not populate
Steps to Reproduce:
1- Go to Staffing
2- Enter a filter, for example: Manager (Resource) = resource
top pane does not load results
An error is seen in the app-ca.log files
ERROR 2023-07-12 21:40:15,895 [http-nio-80-exec-3] union.persistence (clarity:admin:60931328__2C3F2354-9BFE-4065-8334-C18C4906E602:PPM_REST_API) Exception on odf-pmd.inv.select-list-rest-api-conditional.map statement null
org.postgresql.util.PSQLException: ERROR: invalid reference to FROM-clause entry for table "prteam"
Hint: There is an entry for table "prteam", but it cannot be referenced from this part of the query.
Expected Results: Resources/Investments load for Staffing
Actual Results: Resources/Investments do not load for Staffing
Workaround: none
Release : 16.1.2
This does not happen in all environments
This is being investigated at Broadcom under: DE70834