June 22, 2013

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:

June 21, 2013

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


June 20, 2013

Siebel Contact Center - Demo Video From Oracle


Oracle Siebel CRM Support Timelines

Are you worried about your existing Siebel CRM investment? or thinking of implementing Siebel to manage your customer touch points? then look no further.
Siebel has not lost his shine even after presence of many cloud based CRM solutions. Siebel still remains the market leader and supporting clients around the world to manage customer relationships, infact it proves to be best return on investment.
With recent release of Open UI Innovation Pack, Oracle has proved that Siebel CRM still is current and meaningful in days of modern web browsers and devices.

Following is the Screen grab from the Oracle Siebel Statement of Direction May 2012.

Siebel Support timelines for existing Siebel versions
This clearly shows the extended support is available for next six years which is comfortably more than IT planning program of organisations and indefinite Sustaining Support ensures safety of the investments.


Siebel Open UI Demo - Video

Here is one Siebel Open UI demonstration from ec4uintern