Error and Performance Issue on creating Account: "This operation is not allowed when there are no records displayed.Please execute a query that returns at least one record or add a new record.(SBL-DAT-00215)" (Doc ID 1500355.1)

Last updated on MARCH 02, 2017

Applies to:

Siebel Tools - Version 8.1.1.7 [21238] and later
Information in this document applies to any platform.
""CHECKED FOR RELEVANCE ON 26-MAY-2014""
””Checked for Relevance on 21-DEC-2015””

Symptoms

On : 8.1.1.7 [21238] version, Configuration - General

Issue description:
1. Customer is facing issue while creating a Account record.
2. The below error is thrown when write record is triggered:

 "This operation is not allowed when there are no records displayed.
Please execute a query that returns at least one record or add a new record.(SBL-DAT-00215)"

3. Issue even exists if the scripting is removed from Account BC.

4.If we query the created account we could see that the account gets created but the error is shown.

5. The important thing is they have different env, like Development Env, ST Env and SIT Env.
All the env have same SRFs, but this issue is coming only in ST Env.

6. They are able to create Account without any error in Development Env, the issue is occurring in ST Env and then we have SIT env where again the accounts are getting created properly.


ERROR
-----------------------
 "This operation is not allowed when there are no records displayed.
Please execute a query that returns at least one record or add a new record.(SBL-DAT-00215)"


STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Click on Accounts Screen
2. All Account List View
3.Create a new record by click on New button.
4. Below error would come to users.

"This operation is not allowed when there are no records displayed.
Please execute a query that returns at least one record or add a new record.(SBL-DAT-00215)"

BUSINESS IMPACT
-----------------------
The issue has the following business impact:
Due to this issue, users cannot create a new record.

Cause

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