EEX 9.2: Pages With Expense Type List Box Showing Warning - Maximum Number Of Records Found Matching Specified Key(s) (Doc ID 2220361.1)

Last updated on JANUARY 11, 2017

Applies to:

PeopleSoft Enterprise FIN Expenses - Version 9.2 to 9.2 [Release 9]
Information in this document applies to any platform.

Symptoms

Pages with Expense Type List box give Error message "Expense - Maximum number of records found matching specified key(s)" and not showing all the Expense Types in List Box/Drop Down if there are more than 300 Expense Type.

Steps:

The issue can be reproduced at will with the following steps:
1. Make sure you have more than 300 Expense Types under one setid/business unit and the same is available to employee to select
2. Navigate to Set Up Financials/Supply Chain > Product Related > Expenses > Management > Approval Setup > Risk Template, Add a new Risk Template

Warning:
Page shows the below warning message due to large no of Expense Type and Expense Type Drop Down shows only 300 Expense Types others not available to select.

 Maximum number of records found matching specified key(s) -- others not included in list. (4,2)
 When performing a Lookup, the database returned more rows than can  be accommodated in the list box.
 Use a Partial Key value or Advanced Search to limit the number of rows returned or specify more characters to further qualify the key value.

Issue is replicable for all those navigations where Expense Type is used as List box, below mentioned navigation identified so far:

 a) EX_RISK_TMPL (Set up Financials/Supply Chain > Product related > Expenses > Management > Approval Setup > Risk Template)
 b) EX_ROLE_EXCEPTION (Set up Financials/Supply Chain > Product related > Expenses > Management > Expense Role Exceptions);
 c) EX_TEMPLATE (Set up Financials/Supply Chain > Product related > Expenses > Management > Template);
 d) EX_CCET_MAP_TBL (Set up Financials/Supply Chain > Product related > Expenses > Mapping > Expense Type - Corporate Card);
 e) EX_PY_MAP_TBL (Set up Financials/Supply Chain > Product related > Expenses > Mapping > Expense Type - Payroll)
 f) EX_WIZARD_TBL (Set up Financials/Supply Chain > Product related > Expenses > Mapping > Expense Type - Wizard Type)
 g) EX_BMXPNTP_MAP_PNL (Set up Financials/Supply Chain > Product related > Expenses > Mapping > Expense Type Benchmark)

 

Changes

 

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms