PUBLIC SECTOR "HLS CASE" BC RETURNING MULTIPLE RECORDS IN SIEBEL ESCRIPTING.
Last updated on MARCH 02, 2017
Applies to:Siebel CRM - Version 8.2.2 SIA and later
Information in this document applies to any platform.
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).
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