My Oracle Support Banner

Count SR's in Solutions (Doc ID 517515.1)

Last updated on JUNE 21, 2023

Applies to:

Siebel Tools - Version 7.5.2.11 SIA [15221] and later
z*OBSOLETE: Microsoft Windows Server 2003
Version: 7.7.2.6 [18372]

Database: Oracle 9.2.0.4

Application Server OS: Microsoft Windows 2003 Server SP1

Database Server OS: Sun Solaris 8




Symptoms


We want to count how many service request are linked with a certain Solution.
Therefor we thought using the "Count"-function.

I created in BC: Solution
1) MultiValue Link
Name: Service Request
Destination BC: Service Request
Destination Link: Solution/Service Request

2) Field: "Service Requests"
with MultiValue link: "Service Request" and Dest Field: "SR Number".

3) Then created a Field: "Count SR"
Calculated Value: "Count("Service Requests")"
TYPE = DTYPE_INTEGER

I can see the Count field on the list applet of Solution Administration, but there aren't any values (so no count is done).
Does the count work in 7.7.2.6 with MVG or how do I implement this requirement?

Cause

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
Cause
Solution
 Message 1

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