Error "SBL-DAT-00500: There were more rows than could be returned. Please refine your query to bring back fewer rows" While Creating Or Selecting More Than 500 Records (Doc ID 2654473.1)

Last updated on MARCH 01, 2024

Applies to:

Siebel Media - Version 8.1 [21039] and later
Information in this document applies to any platform.

In the scenario where an Inbound interface creates more than 1,000 Assets, it fails exactly at 500 records with the following error:

The same error is seen in any process that would either create or select more than 500 records, such as Orders, Quotes, Agreements.

	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

Symptoms

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