My Oracle Support Banner

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

To view full details, 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 a vibrant support community of peers and Oracle experts.