Incomplete Query In CR View Applicaiton

(Doc ID 2328434.1)

Last updated on NOVEMBER 14, 2017

Applies to:

Siebel Advanced Search - Version 16.0 [IP2016] and later
Information in this document applies to any platform.

Symptoms

On : 16.0 [IP2016] version, Configuration - General

ACTUAL BEHAVIOR
---------------
Customer has an Custom view in which the users will be generating reports based on the input arguments.

In Production query is hanging and not fetching any results.

Compared the query fired between STAGE environment and PRODUCTION environment and in PRODUCTION the number of bind variables in the query is different from lower environment for the same functionality we are seeing the complete query is being fired.

Total bind variables in PROD query: 4
Total bind variables in lower environment query: 11

EXPECTED BEHAVIOR
-----------------------
PRODUCTION should have same number of bind variables

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Customer has a View where users will be generating reports based on the input arguments.

2. In Production Customer see the query is hanging and not fetching any results.

3. Customer compared the query fired between stage and PROD and could see that in PROD they are not seeing all the bind variables in the query where as in lower environment for the
same functionality they are seeing the complete query is being fired.

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