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

MOSC Banner

Impact of removing vanilla search specification from Action business component

edited Aug 8, 2018 5:08AM in Siebel Open UI, Tools, Scripting and EAI (MOSC) 2 commentsAnswered

Hi Experts,

There is vanilla search specification on Action BC which is based on opportunity related data.

To be precise, want to remove below condition from search specification of Action business component:

([Opportunity Id] IS NULL OR [Opportunity Secure Flag] = 'N'OR [Secure Opty Id] IS NOT NULL)

We are not using opportunity related data in our project.

Live stats are as follows for above condition:

For Field: Opportunity Id

SQL> SELECT count(OPTY_ID) FROM siebel.S_EVT_ACT where OPTY_ID IS NOT NULL;

COUNT(OPTY_ID)

--------------

             2

For Field: Opportunity Secure Flag

SQL> SELECT count(act.ROW_ID) FROM siebel.S_EVT_ACT act, siebel.S_OPTY opty WHERE opty.ROW_ID = act.OPTY_ID;

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