Restrict certain queries on BC/EBC/VBC : GetSearchExpr()

Recently someone posted requirement on it toolbox to capture and change the queries executed by user on certain Siebel business components.

Few consultant suggested use pre query event of business component to change the search spec using GetSearchExpr and SetSearchExpr, however it is not possible to achieve this without releasing srf.

Perhaps there was a solution which could be achieved without releasing srf.In such type of requirements we can use Siebel Run Time events and client side business services which are independent of srf release.

Siebel Tools and Client is not responding?

Have you done something innovative and Siebel Client have stopped responding? Even task manager is stuck?

Do not restart your machine, instead try these commands from command prompt to force kill the exe:

taskkill /IM siebel.exe /F
taskkill /IM siebdev.exe /F
taskkill /IM iexplore.exe /F
taskkill /IM taskmgr.exe /F

Force kill siebel.exe

Siebel Configuration Interview Questions

Siebel Configuration Interview Questions

Siebel Configuration is one of core areas of Siebel Customization, and it usually get overlooked in projects.  It is equally important for an Siebel Consultant to know the basic configuration items along with specialized skills like EAI, EIM etc.. 

Following are some questions that easily assess the Consultant's understanding over Siebel Configuration.

Question: How to make applet read only in Siebel?

Answer: To make applet permanently read only, one can use No Update, No Insert, No Delete, No Merge property on applet to true. Read more

Question : How to build validation in Action Business Component to ensure that Start date is always a future date?

Answer: Validation field and validation message can be used to enforce the date entered. To check the future data following Syntax can be used.

> Today()

 

Question: How to create validation for first name field in Contact BC to have at least 5 characters?

Answer: Length method can be used in validation field to ensure minimum number of characters are entered in the field.
Syntax :

Len([First Name]) > 5

 

Question : How does Primary Id field improves performance of an MVG field? 

Answer: By default every MVG field executes a separate query on database to fetch data from child BusComp. When primary id field is specified and use primary join flag is set, application does not execute sub-query and instead uses join to fetch the data.

Question : What are the implications if Primary ID field is not used in MVG?

 Answer: If Primary Id is not specified on an MVG then view will take a lot more time to load as for every record in list applet another subquery will be executed.

 

Question : Is it possible to deploy SRF on server if objects are not checked in repository?

Answer:Yes, for Business Service, BusComps, BusObjects and Applet changes, srf can be deployed on server without checking in the objects, however workflow needs all the BO and BC to be checked in before it is activated.

Question: How to disable new record creation for certain users of Siebel?

Answer: Applet's PreCanInvokeMethod Method can be used to disable new button by setting CanInvoke to false, this can be done conditionally by checking the position or responsibility of the current user.

Question: How to make field editable for certain group of users only?

Answer: Create field read only field user property for the field and use calculated field expression to check the responsibilities of user, return N if user has the responsibility to edit the field and Y if it doesn't

Calculated field expression:

IIF(InList("Edit Field",GetProfileAttrAsList("User Responsibilities"))='Y','N','Y')

This way user who don't have the responsibility will see the field readonly.

Question : How to access user preference in script?

Answer: User preferences in siebel are stored in special class base bc which gets its values from spf files stored in file system. Through script user preferences can be retreived by querying the User Preferences BC like :

var oBOUser = TheApplication().GetBusObject("User Preferences");
var oBCUser = oBOUser.GetBusComp("User Preferences");
with(oBCUser)
{
SetViewMode(AllView);
ActivateField(fieldName);
ClearToQuery();
ExecuteQuery();
if (FirstRecord())
{
sDefTempValue = GetFieldValue(fieldName);
}
}

 

Question : How to access system preference in escript?

Query System Preferences BC on Name and Value fields to get the value of system preference..

        var boSysPref = TheApplication().GetBusObject("System Preferences");
        var bcSysPref = boSysPref.GetBusComp("System Preferences");
         bcSysPref.ClearToQuery();
         bcSysPref.ActivateField("Value");
         bcSysPref.SetViewMode(AllView);
         bcSysPref.SetSearchSpec("Name", sName);
         bcSysPref.ExecuteQuery( ForwardOnly );
    
         if (bcSysPref.FirstRecord())
         {
            sValue = bcSysPref.GetFieldValue("Value");
         }return(sValue);

    

Question : How to set system preference in Siebel?

Answer: "Administration Application> System Preference" view can be used to set the value of system preference.

 

Question . What could be reason behind a Picklist field which is not showing the drop down icon?

Answer: There are only three reasons for picklist not showing drop down:
Picklist is not specified on BusComp field.
Picklist is not compiled or Picklist values are not created.
Control's Runtime property is not set to true on Applet

Question : Is it possible to make calculated field as editable?

Answer: Yes, by setting setting pick map on calculated field and field becomes editable, however it won't be able to save the value and will recalculate the value on refresh record.

Question : How can you get the value of parent field value in browser script?

Answer: Only fields displayed on UI are accessible in browser script, it is applicable for all the parent and child bus components.



Popular Interview Questions:

• How to fix a picklist field?

• What is the performace impacts of using applet toggles?

• What are different forms of applet toggles?

• What is the difference between Constraint pick map and Copy pick map in Siebel?

• What is the difference between Picklist and MVG?

• How to create a new static picklist in Siebel?

Not able to send child buscomp fields in Siebel F9 email functionality

Siebel Email F9 functionality is one of the favourites among the Siebel users. Being quick to setup, saves lot of user time, and ease of use makes it quick win.

However it lacks at certain aspects. One of them being not able to pre-populate data from child business component on the email template. On simple search it seems it should be possible to pull any field value, but actually it is not.

After spending some time on support web/metalink it is clear that it is not possible to use child buscomp in field substitution in F9 email functionality, as Siebel F9 email only support simple templates which can only iterate through primary bus comp and not the iteration(child) bus comp.

From Support web:
1) Use of 'Send Email' permits the use of a simple template.Advanced templates require an Outbound Communication Request.
2) Simple templates cannot contain Template Items.3) Template Items allow an iteration child business component, from which substitution fields may be selected.

Solution:

Close look at the event model shows that siebel execute FileSendMail method on the applet when F9 button is pressed.

So if Siebel script/runtime event can trap that event then and calculate the child bus comp fields, then this data can be fed to the email popup using some field on primary bc.

1. Add script on applet

On these lines I added some script on the applet pre invoke and set profile attribute.

2. Create new calculated field

And used this profile attribute to provide data in template, this helped to get the value of child business component and onto the email template.

Looking forward for comments.

Next in series: Pre-populate CC or BCC in Siebel F9 Functionality

Siebel Contact Center - Demo Video From Oracle