Unwanted SQLs Are Fired While Adding Product From AddToCart In Quote Catalog View (Doc ID 2219291.1)

Last updated on MAY 15, 2017

Applies to:

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

Symptoms

On : 16.8 [IP2016] version, Order Management

ACTUAL BEHAVIOR
---------------
Unwanted and wrong SQLs is getting fired with wrong row_ids upon click on "AddToCart" from Quote-Browse Catalog view. In SQL input to Quote Row Id is passed as Quote Item row_id which is incorrect which will not fetch any records at all

EXPECTED BEHAVIOR
-----------------------
Unwanted and wrong SQLs should not fire with wrong row_ids upon click on "AddToCart" from Quote-Browse Catalog view

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Login to Siebel application
2. Go to Quote browse catalog view
3. Add a product from "AddToCart" button
4. Product is added
5. From Logs after "Configurator Load" WF incorrect SQLs are fired
6. Example: In SQL input to Quote Row Id is passed as Quote Item row_id which is incorrect which will not fetch any records at all.

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