S_LST_OF_VAL Table Query Has Static Values For WS_ID, WS_MAX_VER And WS_MIN_VER Instead Of Bind Variables
(Doc ID 2687123.1)
Last updated on AUGUST 27, 2024
Applies to:
Siebel CRM - Version 17.0 [IP2017] to 21.3 [Release V17]Information in this document applies to any platform.
Goal
The application when selecting data from S_LST_OF_VAL has the Workspace related columns WS_ID, WS_MAX_VER, WS_MIN_VER values directly hardcoded in the query instead of passing it as bind variables. As a result features like SQL Profiling cannot be performed since values are dynamically changing after each migration.
Solution
To view full details, sign in with your My Oracle Support account. |
|
Don't have a My Oracle Support account? Click to get started! |
In this Document
| Goal |
| Solution |
| References |