Navigating Back To The Dispatch Board After Drilldown On Dispatch Board Unplanned Activity Applet is slow (Doc ID 2191551.1)

Last updated on FEBRUARY 21, 2017

Applies to:

Siebel Field Service - Version 8.1.1.14.16 [IP2014] and later
Information in this document applies to any platform.

Symptoms

After running "any query" in the Unplanned Activities applet in Dispatch Board View, if you drilldown and go back using thread bar/back button, a query against Action BC is generated without Planned Dates condition. This returns thousands of records.

EventContext EvtCtxView 3 00000f1657631e60:0 2016-06-21 13:51:04 FS AxGanttChart View

.
...
.
T26.TARGET_OU_ADDR_ID = T4.ROW_ID (+) AND
((T26.APPT_REPT_REPL_CD IS NULL) AND
((T26.TEMPLATE_FLG != 'Y' AND T26.TEMPLATE_FLG != 'P' OR
T26.TEMPLATE_FLG IS NULL) AND (T26.OPTY_ID IS NULL OR T24.SECURE_FLG = 'N' OR
T6.OPTY_ID IS NOT NULL)) AND
(T26.PRIV_FLG = :3 OR T26.PRIV_FLG IS NULL OR T26.OWNER_PER_ID = :4))
ORDER BY
T26.OWNER_PER_ID, T26.TODO_PLAN_START_DT
.
ObjMgrSqlLog Detail 4 00000f1657631e60:0 2016-06-21 13:51:04 Bind variable 1: SFSObjMgr_enu,ssia811,22020118,SADMIN,00000f1657631e60:0,,Action,FS AxGanttChart View
.
ObjMgrSqlLog Detail 4 00000f1657631e60:0 2016-06-21 13:51:04 Bind variable 2: 0-5220
.
ObjMgrSqlLog Detail 4 00000f1657631e60:0 2016-06-21 13:51:04 Bind variable 3: N
.
ObjMgrSqlLog Detail 4 00000f1657631e60:0 2016-06-21 13:51:04 Bind variable 4: 0-1
.
ObjMgrSqlLog Debug 5 00000f1657631e60:0 2016-06-21 13:51:04 User search spec:
.
ObjMgrSqlLog Debug 5 00000f1657631e60:0 2016-06-21 13:51:04 Named search [Override Filter Search]: Override Type IS NULL
.
ObjMgrSqlLog Debug 5 00000f1657631e60:0 2016-06-21 13:51:04 Named search [System Search]: ((([Template Flag] <> 'Y' AND [Template Flag] <> 'P') OR [Template Flag] IS NULL)) AND ([Opportunity Id] IS NULL OR [Opportunity Secure Flag] = 'N' or [Secure Opty Id] IS NOT NULL)
.
ObjMgrSqlLog Debug 5 00000f1657631e60:0 2016-06-21 13:51:04 Named search [Private Filter Search]: [Private] = 'N' OR [Private] IS NULL OR [Primary Owner Id] = LoginId ()
.
ObjMgrSqlLog Debug 5 00000f1657631e60:0 2016-06-21 13:51:04 User sort spec: Primary Owner Id, Planned
.
=====================================
.
- note that above query does not have Planned dates in the WHERE condition

(TODO_PLAN ....)

- Then the following is generated as expected with the Planned dates:

....
.
((T27.SRV_REGN_ID = :3) AND
(T27.APPT_REPT_REPL_CD IS NULL) AND
((T27.TEMPLATE_FLG != 'Y' AND T27.TEMPLATE_FLG != 'P' OR
T27.TEMPLATE_FLG IS NULL) AND (T27.OPTY_ID IS NULL OR T25.SECURE_FLG = 'N' OR
T6.OPTY_ID IS NOT NULL)) AND
(T27.TODO_PLAN_START_DT < TO_DATE(:4,'MM/DD/YYYY HH24:MI:SS') AND
T27.TODO_PLAN_END_DT >= TO_DATE(:5,'MM/DD/YYYY HH24:MI:SS')) AND
(T27.EVT_STAT_CD != :6 AND T27.EVT_STAT_CD != :7 AND T27.EVT_STAT_CD !=
:8) AND
(T27.PRIV_FLG = :9 OR T27.PRIV_FLG IS NULL OR T27.OWNER_PER_ID = :10))
ORDER BY
T27.OWNER_PER_ID, T27.TODO_PLAN_START_DT

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