Incomplete Query In CR View Applicaiton
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.
On : 16.0 [IP2016] version, Configuration - General
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
PRODUCTION should have same number of bind variables
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.
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