Cost Plan Detail List throws an error if you have 1000+ charge codes and charge code is added to the filter

book

Article ID: 223549

calendar_today

Updated On:

Products

Clarity PPM On Premise

Issue/Introduction

Cost Plan Detail List throws an error if you have 1000+ charge codes and charge code is added to the filter

Cause

This is caused by an oracle limitation of having only 1000 entries in an IN clause.

Environment

Release : 15.9.1

Component : CLARITY FINANCIAL MANAGEMENT

Resolution

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.

Additional Information

Workaround :-

  1. Navigate to Administration -> Objects -> Cost Plan Detail -> Views -> Cost Plan Detail - Filter -> Fields.
  2. Change the Lookup Display type from "Pull-Down" to "Browse".
  3. You will prompted with a confirmation that all the saved filters will be erased once we modify this, click "Yes".

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.