My Oracle Support Banner

Contract Workbench Administrator : Unable to See Complete List of Contracts Type in the Contract Guide List Of Values (Doc ID 763926.1)

Last updated on DECEMBER 05, 2019

Applies to:

Oracle Contracts - Version 11.5.10 to [Release 11.5]
Information in this document applies to any platform.


In Oracle Contracts 11i, the Contract Type list of values (LOV) is limiting the display of the LOV to 100 values.  A warning message displays Query has exceeded 100 rows, Potentially more rows exist, please restrict your query when the previous fields have been entered.

Steps To Reproduce:

  1. Go to Contract Workbench Administrator
  2. Go to Create Contracts
  3. Enter Values for Contract #, Contract name, and Organization
  4. Tab out of Organization field

The warning message is displayed.  Only the first 100 values from Contract type LOV are displayed.  As a result, you are unable to select Contract types other than the first 100.




To view full details, sign in with your My Oracle Support account.

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

In this Document

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.