PUBLIC SECTOR "HLS CASE" BC RETURNING MULTIPLE RECORDS IN SIEBEL ESCRIPTING.
(Doc ID 1629428.1)
Last updated on JULY 21, 2020
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).
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