ORA-01795: Maximum Number of Expressions in a List is 1000 (Doc ID 2803777.1)

Last updated on JULY 23, 2023

Applies to:

Symptoms

When attempting to inform a partial category in the search criteria in the Asset Inquiry form, the following error occurs.

 ORA-01795: maximum number of expressions in a list is 1000"

The issue can be reproduced at will with the following steps:

1. Navigate to Inquiry Assets

2. Inform partial category name in category field

3. Click in the search

Cause

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