Oracle R12 eBTax ‘Query has exceeded 200 rows. Potentially more rows exists, please restrict your query’

What should you do if you receive this error message whilst trying to update look  up codes?

‘Query has exceeded 200 rows. Potentially more rows exists, please restrict your query’

2015-01-13_14-13-02

To resolve this you need to update the profile value of

FND: View Object Max Fetch Size to equal 2000

Laura Stockley
Follow Us

Laura Stockley

Consultant at eBiz Answers Ltd
Laura graduated from University with a degree in Business Studies, and has been working as an Oracle eBTax consultant for several years now, with both R12 eBTax and Fusion (Oracle Cloud) Tax. Focussing primarily on the tax module and its components, Laura also works on the other financial modules and understands how they integrate with the tax engine. Laura has worked on projects with multiple clients covering all aspects of the tax module including AP, AR and GL, working on everything from design, configuration, testing to support. An excellent communicator, Laura enjoys interacting with end users and relishes the challenge of resolving their issues; making tax an enjoyable experience, always.
Laura Stockley
Follow Us

Latest posts by Laura Stockley (see all)