Multiple Queries On BC PS Case Approvers When Navigated From HLS Case For Same Case

(Doc ID 2404282.1)

Last updated on MAY 28, 2018

Applies to:

Siebel CRM - Version 16.10 [IP2016] and later
Information in this document applies to any platform.

Symptoms

ACTUAL BEHAVIOR
---------------
When perform basic operation on HLS Case like Drilldown, Update, Insert...etc, multiple SQLs are getting triggered on PS Case Approvers BC on table S_CASE_APPR for same Case Id

EXPECTED BEHAVIOR
-----------------------
Single SQL should trigger on PS Case Approvers BC upon perform basic operation on HLS Case

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Login to Siebel Application
2. Go to site map Case
3. Drilldown on Case
4. Navigates to Case>>Activity view
5. Multiple SQLs are triggered on table S_CASE_APPR for same Case Id

Changes

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