Record Count Gives Incorrect Result And Leaves Applet Empty
Last updated on NOVEMBER 20, 2017
Applies to:Siebel CRM - Version 7.7.2 SIA  to 8.2.2 SIA [Release V7 to V8]
z*OBSOLETE: Microsoft Windows Server 2003
Product Release: V7 (Enterprise), V8 (Enterprise)
Version: 7.7.2  SIA and above
Database: Oracle 126.96.36.199
Application Server OS: Microsoft Windows 2003 Server
Database Server OS: Microsoft Windows 2003 Server
This document was previously published as Siebel SR 38-2467095627.
***Checked for relevance on 17-Jun-2014***
The following behaviour was observed in Siebel HTIM version 7.7.2 :
(1) Record Count is not displaying the correct value:
Log into 7.7.2 SIA HTIM Sample DB > Site Map > Opportunities > Opportunities List > All Opportunities across Organization.
1. When the user performs a record count on Opportunity, it states for example 1466 records.
2. When the user steps through all the records to the end there are only 1284 records.
This problem also occurs when there are less than 1000 records in the query. After scrolling through the list, the Record Count works, but if the user re-queries the applet, the Record Count displays the wrong amount of records again.
(2) After performing a Record Count the applet goes blank:
This behaviour is reproducible only against an Oracle Database. Once the opportunities list applet contains more than 100 records, after performing Record Count, the list applet will be blank.
Both issues have also been observed for the following Siebel objects:
Service Requests (in the Service Request List Applet, 'My Service Requests' and 'All Service Request view')
Accounts (in the Account Administration screen)
Sales Orders (in the 'All Sales Orders Across Organisations' view)
Activities (in the 'My Activities' and 'All Activities' views)
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
Million Knowledge Articles and hundreds of Community platforms