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

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