Siebel Open UI, Tools, Scripting and EAI (MOSC)

MOSC Banner

Generating null query SQl while loading the view

Hi Gurus,

I analyzing one AOM log to improve performance issue while direct navigating to a detail view (paste the URL in the browser, note that the URL has the view name, applet name and the rowid, then hit enter), in the logs, I am seeing that there are 2 SQL generated for the applet BC. first SQL executed is doing a null query. another similar SQL was generated but this 2nd SQL is with the bind variable of the row id provided in the URL.

I want to understand if the first SQL that was generated is a Siebel Vanilla behaviour? Is it like a warm up call to the view before it actual loads the data?

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center