Invalid Operation When Not Executed SBL-DAT-00471 Error Querying for Id Field in Audit Trail 'Audit Trail Item 2' Business Component (Doc ID 728852.1)

Last updated on NOVEMBER 05, 2014

Applies to:

Siebel Tools - Version 8.0 [20405] and later
Siebel Audit Trail - Version 8.0 [20405] and later
Information in this document applies to any platform.
""CHECKED FOR RELEVANCE ON 13 MAY 2013""
""CHECKED FOR RELEVANCE ON 05-Nov-2014""

Symptoms

It was reported that while attempting to query on Audit Trail Item 2 Business Component (BC) by using the below code, the error message "Invalid operation when not executed.(SBL-DAT-00471)" occurs.

var boAudit = TheApplication().GetBusObject("Audit Trail");
var bcAudit = boAudit.GetBusComp("Audit Trail Item 2");
with (bcAudit)
{
SetViewMode(AllView);
ClearToQuery();
SetSearchSpec("Id", AuditTrail_Rowid);
ExecuteQuery(ForwardBackward);
}

This error can also be reproduced by querying for the Id field in the user interface (UI) directly, with the following steps:


1) Site Map > Audit Trail > Audit Trail Items
2) On the Audit Trail Item List Applet 2, click Query button, on any field, enter [Id]='test_id'
3) The "Invalid operation when not executed.(SBL-DAT-00471)" error message occurs.

Querying on other fields does not generate this error, for example [Record Id]="test-id".

Changes

This scripting to query for Id worked prior to upgrade to version 8.0.0.x.

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