Cost Plan Detail List throws an error if you have 1000+ charge codes and charge code is added to the filter
This is caused by an oracle limitation of having only 1000 entries in an IN clause.
Release : 15.9.1
Component : CLARITY FINANCIAL MANAGEMENT
STEPS TO REPRODUCE:
1. Login to Clarity PPM.
2. Create more than 1000 charge codes.
3. Navigate to Administration -> Objects -> Cost Plan Detail -> views -> Cost Plan Detail - Filter.
4. Add the Charge Code column to the layout.
5. navigate to home -> projects -> Open a Project -> Financial Plans -> Open a Financial Plan.
Workaround :-
Note :- Change any lookup attribute which is expected to retrieve 1000+ records from Display type "Pull Down" to "browse" to avoid these issues in other filter views.