Extra SQL Statements Generated for Picklists in Open UI

(Doc ID 2333655.1)

Last updated on NOVEMBER 29, 2017

Applies to:

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

Goal

On :  15.18 [IP2015] version,

In Open UI the picklists are pre-fetched.

Extra SQL statements are fired in order to get the content of picklists before entering a view. This behavior did not occur with High Interactivity.

STEPS

1. Launch Open UI application.
2. Go to Accounts > Account List.
3. Drill down on Account.
4. Go to Account Affiliations (view: "Pharma Account Affiliations View").

Observe the following in the log:

ObjMgrSqlLog Detail 4 000000025a03116c:0 2017-11-08 11:18:35 SELECT statement with ID: 1C22A408

SELECT /*+ ALL_ROWS */
T1.CONFLICT_ID,
T1.LAST_UPD,
T1.CREATED,
T1.LAST_UPD_BY,
T1.CREATED_BY,
T1.MODIFICATION_NUM,
T1.ROW_ID,
T1.VAL,
:1
FROM
SIEBEL.S_LST_OF_VAL T1
WHERE
((T1.ORDER_BY > :2) AND
(T1.ACTIVE_FLG = :3 OR T1.ACTIVE_FLG IS NULL)) AND
(T1.TYPE = :4 AND T1.BU_ID IS NULL)
ORDER BY
T1.ORDER_BY

  

ObjMgrSqlLog Detail 4 000000025a03116c:0 2017-11-08 11:18:35 Bind variable 1: ,,,SADMIN,000000025a03116c:0,,PickList Generic,Pharma Account Affiliations View
ObjMgrSqlLog Detail 4 000000025a03116c:0 2017-11-08 11:18:35 Bind variable 2: 20
ObjMgrSqlLog Detail 4 000000025a03116c:0 2017-11-08 11:18:35 Bind variable 3: Y
ObjMgrSqlLog Detail 4 000000025a03116c:0 2017-11-08 11:18:35 Bind variable 4: PARTY_RELATIONSHIP_TYPE
ObjMgrSqlLog Debug 5 000000025a03116c:0 2017-11-08 11:18:35 User search spec: 'PARTY_RELATIONSHIP_TYPE' AND IS NULL
ObjMgrSqlLog Debug 5 000000025a03116c:0 2017-11-08 11:18:35 Named search [TransValCache Pick Search]: [Order By] > 20
ObjMgrSqlLog Debug 5 000000025a03116c:0 2017-11-08 11:18:35 Named search [Active Field Flag Search]: [Active Entry Flag Field] = 'Y' OR [Active Entry Flag Field] IS NULL
ObjMgrSqlLog Debug 5 000000025a03116c:0 2017-11-08 11:18:35 User sort spec: Order By
ObjMgrSqlLog Debug 5 000000025a03116c:0 2017-11-08 11:18:35 System sort spec:

ObjMgrSqlLog SqlTag 2 000000025a03116c:0 2017-11-08 11:18:35 Begin: Execute SqlObj 'PickList Generic' at 1c209578 with SqlTag=,,,SADMIN,000000025a03116c:0,,PickList Generic,Pharma Account Affiliations View

ObjMgrSqlCursorLog Execute 5 000000025a03116c:0 2017-11-08 11:18:35 Begin: ExecuteStmt for Sql Cursor at 1c22a408
SQLParseAndExecute Bind Vars 4 000000025a03116c:0 2017-11-08 11:18:35 1: ,,,SADMIN,000000025a03116c:0,,PickList Generic,Pharma Account Affiliations View
SQLParseAndExecute Bind Vars 4 000000025a03116c:0 2017-11-08 11:18:35 2: 20
SQLParseAndExecute Bind Vars 4 000000025a03116c:0 2017-11-08 11:18:35 3: Y
SQLParseAndExecute Bind Vars 4 000000025a03116c:0 2017-11-08 11:18:35 4: PARTY_RELATIONSHIP_TYPE
ObjMgrSqlCursorLog Execute 5 000000025a03116c:0 2017-11-08 11:18:35 End: ExecuteStmt for Sql Cursor at 1c22a408
Observe that the content for LOV type "PARTY_RELATIONSHIP_TYPE" is fetched via SQL statement

=====>  ObjMgrSqlLog Debug 5 000000025a03116c:0 2017-11-08 11:18:35 Named search [TransValCache Pick Search]: [Order By] > 20

Solution

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