R12: OIE: Unable To Delete The Credit Card SIC Mapping - Only 200 Rows Appear for Select Even Though More Exist (Doc ID 2133098.1)

Last updated on NOVEMBER 29, 2016

Applies to:

Oracle Internet Expenses - Version 12.1.3 and later
Information in this document applies to any platform.
SIC Credit Card Mapping
Profile 'FND: View Object Max Fetch'
Query has exceeded 200 rows. Potentially more rows exist, please restrict your query.

Goal

On : 12.1.3 version, Credit Card Requests

While attempting to modify existing Card Expense Mapping rules in the Internet Expenses Setup and Administration=>Expenses Setup: Credit Cards: Card Programs form under Card Expense Mapping there is no opportunity to query individual rule names. Instead the user must search through the values one screenshot (i.e. 10 records) at a time. Upon reaching the 200th record the following error occurs:

Warning:
Query has exceeded 200 rows. Potentially more rows exist, please restrict your query.

How can the additional rows be accessed for editing?
 

Solution

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