My Oracle Support Banner

PUBLIC SECTOR "HLS CASE" BC RETURNING MULTIPLE RECORDS IN SIEBEL ESCRIPTING. (Doc ID 1629428.1)

Last updated on MARCH 02, 2017

Applies to:

Siebel CRM - Version 8.2.2 SIA[22320] and later
Information in this document applies to any platform.

Symptoms

When using Public Sector "HLS Case" BC, and searching for a specific Id, the result set that is returned contains multiple rows in Siebel eScripting. If they search for that same Id in the UI on an applet that is based on that same BC, then they see only a single row returned.

This behavior is seen in Vanilla SRF, when using Sample DB data. Furthermore the problematic join is against S_CASE_PER, a join that is not exposed in the BC, and is thus built into the CSSBCHSCase Class.

The following script is used to see this behavior (returning two records when only one is expected, and only one in the UI).

 

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
References


This document is being delivered to you via Oracle Support's Rapid Visibility (RaV) process and therefore has not been subject to an independent technical review.
My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.