Error when accessing Cost Plan Detail ORA-01795

Products

• Clarity PPM SaaS
• Clarity PPM On Premise

Issue/Introduction

After upgrade, all their Cost plans - Detail pages were giving error message:
Internal Server Error. The server could not retrieve the document due to server-configuration or other technical problems. Contact your site administrator

In the logs the error was :
ERROR 2019-05-21 09:56:18,019 [http-nio-14001-exec-2] services.CostPlanDetailFlatListViewService (clarity:XXXXXXXXXXXXX:11037088__7F00D47A-E16B-492D-9E40-04F7C267F76C:revmgr.costplandetailList) Unable to load Cost Plan Detail list for com.ca.clarity.financial.common.utils.FinancialActionContext@cfe5127
com.niku.union.odf.exception.ODFException: Error loading filter view costplandetailFilter for object costplandetail
Caused by: com.niku.union.persistence.nsql.NSQLException: com.niku.union.persistence.PersistenceException:
SQL error code: 1795
Error message: [CA Clarity][Oracle JDBC Driver][Oracle]ORA-01795: maximum number of expressions in a list is 1000

Resolution

We reset the defaults on object Cost Plan Detail and this fixed the issue.
Go to Administration - Objects - Cost Plan Detail - Restore Defaults

Attention: This action will erase all custom view configuration and user views so proceed with caution (take screenshots of your config) prior to the reset to be able to use later.