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

MOSC Banner

Is their a way to find out if the applet is blank (no records when user navigates) without doing Exe

edited Jun 15, 2016 10:39AM in Siebel Open UI, Tools, Scripting and EAI (MOSC) 16 commentsAnswered

Hi,

We have a requirement where we have to hide a button on Activities form and list applet when there are no records present in the applet. We have tried below things already but each one has its problems. Please suggest if their is any othera lternate way to find out blank applet?

a) custom function on precaninvoke, used execute query and count records - observed performance issues as this applet is accessed thousands of times in a day hence its coming as worst queries in AWR report (not because of cos but because of frequency)

b) similarly used this.Buscomp().FirstRecord and this.Buscomp().FirstSelected() methods to see if these return false however these methods return an exception and logs an error in object manager logs. Understand we can always put a try catch block and set the caninvoke to false with in catch block which will hide the button but error is still logged in Object manager. Given the fact that this applet is accessed thousands of time number of log files increase and hence we dont want to use this approach

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