The trick I am going to tell you in this article might seem to you very simple and basic if you have been working on siebel for a long time but for a newbie it can be small time saving trick during his early days of dabbling with Siebel Development. I have come to know in last few days while talking to a friend, assuming that a simple thing is known to everybody is a mistake and there is nothing such as useless simple thing.

My experience has taught me that it is pretty common to ignore simple things but they usually are the one’s that can save you a lot of hassel if used in a proper way. During our intital time of Siebel development there is atleast 50 time we open Siebel Dedicated Client and Siebel tools while we are trying to explore Siebel to the best of our ablity. This simple trick can automate your login to the client and tools and save some time of entering username or password.

Right Click the shortcut through which you acess the Siebel Client or Siebel Tools and choose Properties from the context menu.
Scroll right to the end of Target Text Field Value enter the following text in the end.
/u sadmin /p sadmin /d sample

These text will automate your login to sample database. If you want to automate your login to Local Database enter the following code.

/u username /p pwd /d Local

replace username with your local username and pwd with your local database password

You can create copies of the shortcut that you use and can configure different shortcuts to login to different databases.

State Agricultural Bank starts to introduce systems of relationships with clients based on technology platform Oracle Siebel CRM.Work will be performed under two contracts. According to the first system should be established for individuals, for the second - for corporate clients.Agricultural Bank contractor to build CRM for individuals for 96 million was the company "Technoserv consulting." Other contenders - "Step" and "I-Teco" - were not allowed to participate due to lack of a number of documents.In accordance with terms of reference, work on the creation of CRM-system for individuals must be completed before April 30, 2016As a result, the processes will be automated marketing, processing of applications and sales of products sold in the contact center bank, and point of sale services for individuals.Contractor to establish a system for corporate clients is not chosen, the corresponding tender for 62,47 Mill. Agricultural Bank announced a January 30, 2015Performance time - up to 10 June 2015 During this period, the developer will need to create a system to introduce it into operation and trained to work with it to 100 employees of the bank.Following the results of the implementation of CRM-system bank expects to optimize the sales process and increase their volume, improve service by storing information about customers and the history of relations with them, as well as by optimizing business processes and subsequent analysis of the results.As follows from the tender documentation, project objectives, inter alia, include an increase in the customer base of the bank and the creation of a unified database of its corporate clients.Introduction of Oracle Siebel CRM in the Agricultural Bank is conducted in accordance with the target application architecture and IT infrastructure, which, as reported in the documents of the bank, at his request in late 2011 was developed by Accenture.Agricultural Bank was founded in 2000, 100% of its shares are owned by the state. The organization has 78 branches and 1,471 additional offices across the country. According to the thematic Interfax-100 ranking, at the end of 2014 the Agricultural Bank occupies among Russian banks in 8th place on the amount of assets that are close to 2,052 bln.

When attempting to login to Siebel Tools 8.1 client the following error message was displayed - 

 

Further the system would not allow user(s) to enter User ID / password.

Customer verified that there were no other Siebel Tools session(s) running by checking the processes via task manager.

CAUSE

The Siebel root directory containing client, tools, etc. was created as read-only and with unusual file permissions. The same was true for multiple users that installed Siebel 8.1.

Possibly the incorrect permissions prevented the temporary files from being created when the user attempted to login to Siebel Tools client, resulting in the error message - 

 

SOLUTION

Siebel root directory (containing client, tools, etc.) was updated to have the appropriate permissions such as Administrator. This resolved the problem and users were able to login to Siebel Tools client without any problems.

Support for IE8 with Siebel Standard and High Interactivity Clients as well as Tools and Tablet is subject to dependencies and restrictions.

All client machines must run JRE version 1.5 or higher.

IMPORTANT: The Data Execution Protection option (enabled by default in IE8) must be disabled. For more information on this please see Restriction #6 below and Document 1066053.1, "Siebel version 7 & 8 settings for Internet Explorer versions 6, 7 and 8".

IE8 is not supported with the Siebel Open UI client

Configuration 
The following configuration changes must be made on each Application Server. This is mandatory for all Siebel versions whenever IE8 is used regardless of version or patch level:

1. Go to SiteMap (shortcut: control+shift+A)
2. Go to Administration - Web Browser > Browsers > Browsers
3. Check whether Browser "IE 8.0" exists. If it doesn't, create a new Browser  called "IE 8.0" and add similar capabilities as those in "IE 7.0"
4. Create a Browser with the name "MSIE 8.0"
5. Add the following capabilites
   • User-Agent: Mozilla/4.0 (compatible; MSIE 8.0; Windows NT <version>)
        NT versions: 5.1 = WinXP; 5.1= Server 2003 or XP x64; 6.0 = Vista, 6.1=Win7, 6.2=Win8
   • Parent: IE 8.0
   • Accept: image/gif, image/x-xbitmap, image/jpeg, image/pjpeg, application/vnd.ms-powerpoint, application/vnd.ms-excel, application/msword, */*
   • JumpTab: True
6. Reload all Siebel Application servers 

Restrictions

1. Windows 64-bit versions 
   Although there are no native 64-bit Siebel clients the 32-bit version 8.x HI clients (Developer, Mobile/Remote and Siebel Tools) are supported on 64-bit Windows XP, Vista and Windows 7. The user must be a member of the Local Administrators group and the Oracle client installer must be run by a user with Local Administrator rights.
   
   Windows XP Pro (64-bit) includes a 32-bit version of IE (C:\Program Files (x86)\Internet Explorer\iexplore.exe) which is supported since it runs in native 32-bit mode.
   
   Vista (64-bit) includes a 32-bit version of IE which is not supported due to numerous problems with IE-x32 on Vista-x64 (see Microsoft's Knowledge Base Item 896457). 
   
   Windows 7 (64-bit) also includes a 32-bit IE executable which is supported. Please see MSKB article 896457 for further details.
    
2. Tabbed browsing
   Only one tab per IE8 instance may contain an active Siebel session. There are no other Siebel restrictions on additional tabs.
   
   IF an active Siebel session tab is closed without logging out, the user remains logged in when another Siebel session is opened. This is a long-standing feature of Siebel. To completely disconnect from Siebel either use the "Logout" menu option in Siebel or close the IE8 browser instance.
   
   Session-based information is also maintained if the Web Client is re-launched using the IE8 shortcut or the File -> New Window option from the IE menu bar.
   Note that from Siebel v8.1.1.11 FP, multi tabbing and File->New Window is prevented and  a proper error message is displayed that a session already exists.
   
   To launch a new IE session that will not share session information, use one of the following methods:
   • Select File -> 'New Session' from the IE menu bar
   or
   • Run the 'iexplore.exe -noframemerging" command (this flag can be added to the IE8 shortcut)
3. UAC on Vista and Windows 7 
   UAC on Vista and Windows 7 may be used with Protected Mode = OFF and the Security Level set to Medium-Low or lower. The use of UAC has not been fully tested with Siebel applications.
    
4. IE7 Compatibility Mode
   Compatibilty Mode is not supported, only the 'Standards Mode'. For intranet sites this is not the default mode; customers must either explicitly set browser configurations to recognize Siebel only in Standards Mode, or set Web servers to issue the custom 'EmulateIE8' HTML header tag for all Siebel connections.
   
   There are three ways to ensure standards mode rendering:
   • Uncheck the 'IE7 Compatibility mode' box on each browser on each client machine manually or through the Group Policy Editor (see http://blogs.msdn.com/ie/archive/2008/10/02/ie8-group-policy.aspx).
   • Uncheck the browser box 'Display intranet sites in Compatibility View' on each browser on each client manually or with the Group Policy tools to disable it.
   • Set each Web server to send the "IE=EMULATEIE8" custom HTML header for all pages sent from the Siebel application. Instructions for IIS may be found at http://msdn.microsoft.com/en-us/library/ms524327.aspx.IE7 Compatibility Mode is described at: http://blogs.msdn.com/ie/archive/2008/08/27/introducing-compatibility-view.aspx.
   
   A description of differences between IE8 Standards Mode and 'IE7 Compatibility Mode' may be found at http://blogs.msdn.com/ie/archive/2009/03/12/site-compatibility-and-ie8.aspx.
    
5. Unsupported IE8 New Features
   The following configurations of Siebel are not yet supported with IE8:
   • Containers
   • Accessibility
      
6. Other IE8 New Features
   A number of new features introduced in IE8 are expected to be supported over the coming year.  The following is a list of features not yet supported:
   • Enhanced security (downloads, XSS, DEP - buffer overflow prevention)
   • Tab-level crash recovery.
   
   The DEP feature (Data Execution Prevention) must be turned OFF when used with Siebel, as we have not yet included the specialized code required to fully implement this feature. This may be done by unchecking the relevant box on the individual client browsers, or by using the Group Policy tools, or by using the relevant Vista control panel. A description of how to turn off DEP with Vista may be found here: http://www.vistax64.com/tutorials/65790-dep-turn-off-programs.html. 
   
   DEP can be disabled in the following ways:
   
   • IE8 > Tools > Internet Options > Advanced tab
   • In a CMD window running "As Administrator":  bcdedit.exe /set {current} nx AlwaysOff
   • IE Group Policy administration tool

   In order to support DEP under Windows, a computer's processor must support hardware-enforced DEP. This can be determined by running: wmic OS Get DataExecutionPrevention_Available
   in a CMD window; "TRUE" means hardware support exists. The level of DEP running can be determined by running
       wmic OS Get DataExecutionPrevention_SupportPolicy
   This returns an integer from 0-3; the default value is "2" and only Windows system components and services have DEP applied. A value of "0" means DEP is always off and "1" means DEP is always on for all processes.

   Setting this value to "3" is a potential work-around. The policy in this case is that DEP is enabled for all processes but Administrators can manually create a list of specific applications which do not have DEP applied.

   Implementation of the DEP feature is dependent on a Microsoft compiler version not currently used for Siebel applications.

   The DEP feature only mitigates code injection vulnerabilities for which Siebel software already includes protection. The ENCODEDATA parameter prevents execution of any code inside Siebel data. This is the default setting for Siebel. More information can be found in Bookshelf: "Configuring Siebel Business Applications Version 8.1" (page 281 in rev A).

7. The attachment pop-up window file path field is read-only 
   Microsoft has modified the IE8 file upload control to be read-only in order to block attacks which rely on stealing keystrokes to trick the user into typing a local file path into the control. File names and paths cannot be pasted from the clipboard, either. The user must explicitly select a file for upload by using the File Browse dialog box; IE8 then submits only the file name, not the full path. TheInclude local directory path when uploading filessecurity setting is disabled by default for the Internet zone.

Question: What are possible reasons of values not showing in dropdown of static Picklist?

Answer: The possible reason which could result in Picklist values not showing are
1. PickMap is not defined for Field which is showing Picklist values
2. LOV Type and LOV Values are not defined
3. Runtime Flag on Applet level is not true.
4. You have not clicked on Clear Cache after adding the values and trying to see values in same session.
If any of the above mentioned reason is true then you will not see the values in the dropdown of field
Question:
When Service Request status is set to “Closed” then everything including all the child entities of Service Request should become read only but user should still be able to attachments.
OR
When SR status is set to “Close” all the child entities except “Service Request Attachments” should become read only.
Answer:
Service Request and all its child entities become “Read Only” as result of class based functionality of Service Request. So, we need to override the functionality and enable “Service Request Attachment” even after the status is changed to “Closed”. This can be achieved as following:
Define “Always Enable Child” User Property on Service Request BC will the following details:
Name: Always Enable Child: Service Request Attachment
Value: TRUE
Written on February 8, 2010 at 1:11 am by neel
Make record editable for some and read only for some?
Filed under Configuration 4 Comments
There are lot of variations of this question such as:
1. There are two type of users, sales user and risk user. The Differentiating factor between them is User Type in Employee table. How can we configure that for risk user the records are editable and for sales user it is not.
2. How can a view be read only for a particular user and editable for the other user?

But in short we need to answer how to make a view read for some users and editable for some users.
Answer:
Create two responsibilities named Sales_User and Risk_User. Assign the view to both responsibilities and for Risk_User responsibility make “Read Only View” flag as true.
Now add sales users to Sales_User Responsibility and Risk Users to Risk_User Responsibility. Now for Risk_User records will be read only and for Sales user records will be editable.
Question:
How to pupolate a field with the value of another field whenever a new record is created for the first time?
Answer:
Use Post Default Value property of the field using experssion to populate its value with another field value.
Example:
To populate value of field “Sub Status” with value in field “Status” I would use below given expression in Post Default value of “Sub Status” Field

Field: 'Status'
Written on February 18, 2009 at 11:06 pm by neel
What is difference between Hierarchical and Constraint Picklist?
Filed under Configuration 6 Comments
Purpose of both the Picklists is similar, to restrict or constraint the values of child Picklist based on the value of parent but we need to do different configuration to implement them.
The only reason I can think of using Constraint over Hierarchical Picklists is due to a limitation of Hierarchical Picklist showing all the values including child Picklist values.
Basic difference between Hierarchical and Constraint Picklist is as following:
Business Component:
Hierarchical Picklist (HPL): Business Component for HPL is Picklist Hierarchical
Constraint Picklist (CPL): Business Component for CPL is Picklist Generic
Values:
HPL: You will see all the values in Parent Picklist including Child Picklist Values
CPL: As both the parent and child fields have different Picklists associated there is no overlapping of values
LOV:
HPL: Same LOV is used for Parent as well as Child Picklist Field and Parent LIC field is used to establish a parent and child relationship
CPL: Different LOV is used for Parent and Child Fields.
Written on November 15, 2007 at 9:09 am by neel
Position and Responsibility relationship – Interview Question
Filed under Configuration View Comments
Here goes another one.
An important question (every question asked in an interview is important isn’t it ) involving quite a few important entities in Siebel such as Position and Responsibilities. This question can come in variety of ways I am just giving a single question, but other flavors might be exist
What kind of relationship exists between Position and Responsibilities?

It is a question that requires a subjective answer, and answer can vary from person to person. I will try to give answer to the above question(s) but before that I would like to give a disclaimer.
The views presented in this post are mine and only mine. No person dead or living has anything to do with it. Please use the answer in interview at your own risk and if somebody is offended by it or feels differently he is free to express his views by the way of comments in this post

Answer or Explanation
There is no direct relationship between Responsibility and Position.
The indirect relationship between Responsibility and Position is of Visibility. Both of them drive Visibility in Siebel.
• Responsibility restricts access to particular view so that user cannot see those views.
• Position restricts access to particular set of data.
So, as a result both are used to limit visibility of users of application.
After discussing with my friends and colleges about this question I am getting a feeling that I am putting my hand in a bee nest but I think this could end up as a new learning to me and for all.
So guys I beg you to tell me your views what do you think about this question so that this post can become the new answer for all of us.
Written on April 6, 2008 at 7:06 am by neel
SetFieldValue and Calculated Field – Interview Question
Filed under Configuration 12 Comments
Answer of this question I am sure is going to be a surprise for some of you.
The Question is as following.
Can we do a SetFieldValue on a Calculated Field?
Please answer the above poll before going afer the answer part.
Answer of the question is: YES
I know some of you will straight away say this is ridiculous and dismiss the answer as I would have done few days ago.
But the answer is not a straight YES. You can do a set field value provided you fulfil some conditions.
Conditions under which you can use SetFieldValue on a calculated field are as following.
• There should be a Pick Map defined on that calculated field.
• There should be a picklist defined on that calculated field
Then a SetFieldValue results in picking of the value which you are trying to set in case if the value doesn’t exist in that picklist then you will get an error.
I hope this post must have resulted in learning something new for you.

Written on November 14, 2007 at 8:35 am by neel
Search Specification on Applet and BC– Interview Question.
Filed under Configuration 12 Comments
This is a pretty popular and interesting question. I guess anybody who knows Siebel architecture (Layered Architecture not Server Architecture) properly should be able to answer it. But truth is that most of the people I have interviewed have given a wrong answer of this question. Even people have 2 years of experience have got it wrong.
The question is something like this.
I have a search spec on applet which says [Type] = “A” and I have Search Spec on BC which says [Type] =”B”. Now what records will be visible to me on UI?
Before looking at the answer of this question I would like you to have a thought on this and answer it to yourself and see if you can get it right. Having a guess is not sufficient you should also give the reason for your answer.
1. Records with Type A
2. Records with Type B
3. None

Answer to above question is
None
Explaination:
We all know about 3 layered architecture of Siebel.
Database is going to fetch all the records which will reach business layer. Here Search Spec of the BC will filter the records with Type B and only records with Type A will be allowed to reach next layer that is UI layer. Here the search spec of applet will come into picture and records with Type A are going to get filtered which means that number of records reaching to user will be ZILCH
In other words search spec on Applet and BC takes AND operator and the where clause in SQL is going to be Where type = ‘A’ and type = ‘B’ which will always return zero records hence no records on UI
Hope that helps
1.What does position and responsibilities mean in Siebel?
2. What is Siebel file system?

Siebel File System is a shared directory which is used to store the compressed files
used by Siebel application. (eg: test data) It is shared across all the Siebel Servers.

3. describe s_party concept? whats the purpose?

PARTY Tables: Accounts, Organizations, Internal Divisions, Contacts, Employees Positions, and Households.
S_PARTY Table is base table of the extension table of the above.
The data is brought into BC through implicit join....

4. What is drilldown &amp; how to do u create it?
5. do you prefer workflows or scripting?
6. what is picklist and what are different types?
8. what is bounded picklist?
9. where do u enter values for a picklist?
10. what is hierarchical picklist?

Ans: Hierachial Picklist is the one type of Picklist the values will depend on the parent value.
when we create pick list we give picklist hierachi as the propertyname.
Ex: If we seelect COuntryy as the INDIA so INDIA related states only displayed if we select Particular state then it going to display that state related cities only. we can get very gud example in service request just exploere it u can get gud idea on Hierarchial picklist.
12. what is a Business Component? Can u create a new BC?
13. What does registering a view mean?
14. how many applets can a view have?
15. is drill down defined in a view or in an applet?

How do you import List of Values?

Depends on any Hierarchies, but using EIM_LST_OF_VAL(for EIM load) import parents first then children, otherwise you will receive failure message.

What is the difference between EIM and EAI?

EIM : It is batch mode Integration. When data valume is large then we have to go to EIM

EAI : It is real time Integration. When data valume is small then we have to go to EAI

What is the difference between Join and Link?

Join:

(i)It defines M:1 relation between a field in BC to the Column in table.

(ii)Source Field is the Foreign key field in BC while Destination column is the Primary Key column in Table.

Link:

(i)It defines 1:M relation between a field in parent BC to the field in the child BC.

(ii)Source Field is the Primary Key field in Parent BC while Destination Field is the Foreign Key field in child BC.

How do you set up employees in Siebel?

The Employee is also a USER who must be assigned with a valid position. Since the Position maps to the Division which in turn maps to a Organistion the Data visibility is maintained through this position and the Responsibility of the user.

How do you assign responsibilities to employees in Siebel

In Administration Group &gt; Employee there is a field called Responsibility there add your new Responsibility, make as Primary and remove the old one.

What are Pre defined Queries?

Pre Defined queries are some thing which helps us to navigate directly to particular screens or views. it helps in accessing the screens or views in faster manners

What is an extension table and how is it related to base table?

Extension table may be 1:1 realation table to the base table or a 1:M relation to the base table.

1:1 extension table and the base table are logically considered as a single table.

Par_row_id will be the foriegn key.

What is the difference between "PickList Generic" and "PickList Hierarchical" Business components?

"PickList Generic" BC is used for Static Picklists. "PickList Hierarchical" is used for Hierarchical PickLists

what is the link specification
Link spec uses parent type default values &amp; gets the value for the child record

What does Business Component User Mode indicate

Business Component User Mode specifies the Visibility setting for the BC. Like "All", "Personal", "Manager", "Organisation".

What is All Mode Sort?

This property determines whether or not siebel will override the sort specification and if so determines the sort that will be applied to the BC for All or Manager's view. The values are TRUE, FALSE or NORMAL

NORMAL --uses BC defined sort specification
True --Overrides the BC osrt and Uses the U1 index
False - Removes all sorting.

When you have Pre Default Value and Post Default value for a Field, which one will be stored in the Database.

Pre Default Value will be defaulted when new record is created. Post Default Value will be defaulted if there is no value specified for the field. so, Pre Default Value will be stored in the Database. harsha: you can add quistions by clicking the hyperlink on the above bar "Ask Quistion".

How do you specify a view to be displayed as aggregate view in Siebel 7.7

when adding view to screen specify the type as aggregate view.But Before that you should create the parent category.then add this parent category to aggregate view.

or

Parent category for Aggregate view is not required. If there is a parent category for an aggregate view, then aggregate view will appears as a link in the view drop-down list in applet headers, or it will appears as a link in the link bar below screen tabs.

Why do we use Symbolic Strings in Siebel 7.7

In Siebel the text that is displayed on the screens and views are stored in the repository and compiled to an SRF file. This includes the names of every screen, views and fields. When you display a page the server uses the SRF file to determine which fields to show and what test (strings) are associated with each fied. This model of keepijng the strings from the view definition is called symbolic strings.

uses
Reduces the redundancy
Simplifies maintenance because only you have to maintain one string for a given Term
Reduces the localization costs, Time and inconsistences.

what is horizontal and vertical in siebel?

Siebel Hrozontal application is general to every industry. where as Vertical is specific to a industry. such as eAutomobile, eInsurance, eBanking etc.

What is the "Parent Category" property for a Screen View?

This Parent Category specifies the view heading for a bunch of views related. the views belongs to this Parent Category will be shown as View Tabs below the master applet.

What is the function of SWSE on the Web Server? what is it?

SWSE(Siebel Web Server Extension)'s function is to accept the siebel requests and pass it on to Gateway server where the server manager decides, to which siebel server component should this request go.

Is it possible to have multiple database servers for one gateway server.

YES, But it needs multiple enterprise servers, for multiple database. As not more than one database, could be added to an enterprise server, these inturn could be connected to a single Gateway Server

What is eapps.cfg file. and what is its significance.

Eapps.cfg file means swse.

This significance is which application should point to which object manager.

Pick Applet, Dynamic Picklist: which will be better if performance issue is considered.

Pick applet and dynamic picklist both are one
(Or)
DPL Contains the pick applet . So both are the one and same

Navya

Top
________________________________________
Re: Siebel General Interview Questions &amp; Answers
by Navya » Mon May 12, 2008 11:48 am
suppose i write a script on the browser side and get some output. Can this same output be tranferred to / called from the Server side script ? If YES, how and if NO, why not ?

We can interchange the output using the Business Servises. Send this output to a Business Service. and access the BS from a Server Script.

What is the spooling? what is the process to run the spopling?
According to my knowledge,
When ever we are doing some action like create a new record or update a new record in siebel clients siebel internally run some sql scripts on the database.
If there is any error occured in the transaction then using spool we can get the sql script to a file.
Then we determine why this happend.
Sppoling means spooling the queries generated internally by siebel to nalyse the performance issues.

What is seed data in Siebel?
Data which is loaded during Siebel installation is called Seed data.

What does install.ksh and imprep.ksh files do?
Imprep.ksh : This is a database unix shell script provided by siebel for importing all your sif files in siebel repository.It is automatically run while installing siebel and it prepares Repository file in tools.
Install.ksh : contains all manually applied installation files.

Is it required to install gateway server before installing a Siebel server?
Yes, Because one Gateway Server can have multiple Siebel Servers

How is load balancing maintained in Siebel?
Load balancing is maitained by the Gateway server using the third party software Resonate Central Dispatch.

What is Virtual BC?what is the use of vbc?
Virtual Business Component is used to display the data from another Legacy database table, in the Siebel screen.
It is a staging area used to display Non Siebel data(Data from other sources) in Siebel application without actually storing the data in Siebel Database.

What happens if you create an employee in Siebel application and forget to create
The employees would not be able to log in as you have to create a database login and password for the employee to login into the client application.

What does position represents in Siebel?
Position determines which records can be accessed by which users. This is in contrast to Responsibility, which gives View Access.

What is the difference between Master- detail view and MVG.
Following are the main advantages:-
1) MVG Makes effective use of the space.
2) Mutliple set of detail records can be viewed from a single vie

How do you configure a MVG.
To Configure MVG Both join and link are necessary.Expand BC Where u have the joined field. Go to multi value link create a new record give any name as it should not be null. In Destination BC property choose the BC where the joined field is originating (Child BC).In Destination link press F2 and pick the appropriate link.Go to field of parent BC create a field as ssa primary and give a join if BC has extensions like S_org_ext for account BC and give the column name (foreign key). Thengo to Multivalue link again and under primary ID field press F2 and select this ssa primary field. Go to Multivalue Field - create new record - give the same name of joined field but in different case just to differentiate( Ex: EMAIL for actual email field) under MVL property press F2 and select MVL name displayed. Under Field property press F2 and select 'email'.Open Wizard - select MVG applet - select child BC- Select all the fields along with SSA PRIMARY FIELD - select popup list as web template. Copy this MVG applet name and paste it in MVG applet property of EMAIL field in list - list column of parent list applet. (Ex: delete the old 'email' record, create new record and select EMAIL field. make changes in Edit web layout of parent list applet and compile. Add the necessary buttons in the MVG applet. IF configuring MVG for a M:M link u need to mentions association child applet to the MVG applet created. If that is 1:M link then a foreign key relationship exists.{Simple way to say: Create MVL(multivalue Link), mention primary field ID- Create MVF(multivalue field) - Replce the joined SVF(single value field) in parent applet list list column with the MVF. Create MVF applet paste the applet in MVG applet property. Compile.create new record in MVF give foreignkey name and under field give ID for 1:M link. For M:M link paste Association child applet associate applet property of MVG applet .

How many type of siebel Data model extensions are there?
standard and custom extensions

What are different types of Tables?
There are 4 types of tables in siebel
1) Base Table (Ex: s_contact, s_user)
2) Extension table ( Ex: s_contact_x)
3) EIM tables
4) Intersection Tables (Ex: s_org_bu)
In general tables are of 4 types 1. Data Table 2. Repository Table 3. Interface Table 4. Warehouse Table Based on Relationship, 1. Base Table 2. Extension Table 3. Intersection table

What are the different types of Columns.
Columns: 1.Data (Public), 2.Data (Private), 3.Denormalized, 4.Extension, 5.System
How do you recognise that a particular table (Base table ) can be extended?
If the table property is Private, then we can not extend the table. If it is Pubilc, we can.

What is implied Join. Where do we find it ?
Join between two Tables. Join Object defines The Relationship Between
a Bc and atable.Join allows Bc to get Column from table rather then basetable.
In Mvg Applet we can find the join, It uses Forign key to get the Row.

When do we go for BC level user properties
When we need to set or reset the properties at runtime.

How do you import List of Values?
Depends on any Hierarchies, but using EIM_LST_OF_VAL(for EIM load) import parents first then children, otherwise you will receive failure message.

What is the difference between EIM and EAI?
EIM : It is batch mode Integration. When data valume is large then we have to go to EIM
EAI : It is real time Integration. When data valume is small then we have to go to EAI
Navya

Top
________________________________________
Re: Siebel General Interview Questions &amp; Answers
by Navya » Mon May 12, 2008 12:42 pm
When do we go for Dynamic PickList and for Pick Applet?

We go for Dynamic Picklists When we want to update joins( as normally joins are not updatable). We go for a pick applet when we choose a dynamic picklist. Pickapplets help you het the whole list applet of the Bc whose field is joined to the parent. Where as in static picklist you can only choose from predefined values but cant update with any other values.

What is Client Business Service?
We can see the Business Services Client also. These are called Client Business Services we can see them in Business Service Administration Screens. We can write the script for the BS in the client itself. After writing the BS there is no need to to compile those BS's.

When do you use Property Sets in Siebel.

Property Sets are the Hierarchical structures of Variable Names and Values. These Property Sets can be used in Workflow processes Parameters or for any input or output Parameters in scripting.

Ex: var input = TheApplication().NewPropertySet();

var output = TheApplication().NewPropertySet();

after this we can store sets of Variables and their values.

When do you use "CanInvoke(False/True)" method in scripting.

We use it before invoking a method in PreCanInvoke Event and verify a condiation. Based on the result, we can make the method Invoke =True/False. It is just like validating a condition before invoking the method.

If a view has Admin Mode Property = True, then what will happen to User Properties we write on them.?

If a view has adminmode property true then The administrator see all the views---------mani

When do we use genbscript.exe?

Genbscript stands for generate browser script. genbscript is used to generate browser scripts from command line interface.

Why do you need Primary in MVG?

A Primary creates a M:1 realtionship b/w the Parent and the Child record.

Thus it increases the performance by allowing a single query using the SQL join to display both the Parent and the Child records in parent Applet.

Without primaries, each MVG needs a separate query to display a child record in the parent Applet. With Primary, using a single query,you will be able to diaply both the parent and the child records.

What is foreign key table in Siebel?

Foreign key table is the property for a column in the table. it specifies for a column from which table this reference has been came.

What is the use of LDAP user ?

It is used as a third party authentication for an end user which can be modified to have a single sign on to multiple application apart from Siebel.

What is the difference between Links and Multi Value links?

Link is used for Master Detail View of two BCs. where as MVL is used to view the child records using MVG. MVL uses Link to get the records from the child BC.

How to create virtual business component?

Virtual Business component is used to it pass the external data for the business component.

Where does the Primary Field of an MVG stored?

Primary Id Field will be stored in the Parent BC.

What is the use of Item Identifier.

nope.. its an ID of control tag in the applet.. but for the tab sequence its HTML sequence Property

Note: its as per 7.7 version.

How can you resolve Foreign Key in EIM?

Populate all User key columns which will resolve foreign key.

What is Siebel Gateway?

Siebel Gateway is the nameserver which controls the Enterprise Server.

What is the purpose of 1:M extended table?

1. we can use it in parent child relationship where the child entity is lonely related to the parent table.

2. or we can make it as a intersection table by adding the foriegn key of another table's primary key in the 1:M extended table.

What is Siebel Admin Mode View? How to Create this?

Admin Mode property set to TRUE in View object definition.

Admin Mode view overrides the property of Business component. This view allow the user to do update,insert,delete etc. which may not be available in other view of same BC. Because admin mode view overrides the No update, No insert ,No delete BC property. used for administration purpose

What is Sibel Admin Mode View? How to create one?

Amdin Mode View is nothing but, it has Admin Mode Property set to true. It will override all the visibilty rules.

How do you import LOV's?

You can export LOVs using Application Deployment Manager.
Navya

Top
________________________________________
Re: Siebel General Interview Questions &amp; Answers
by Navya » Mon May 12, 2008 1:13 pm
What is the process of the UpGradation?

Upgradation is used when we extend the database by adding colomns n tables,to make avalable these extended dbs to other mobile users we have to prepare upgaradation kit.Then only all can get newly extended tables n colomns in their local dbs.

its possible to give the conditions in Field Read only Field property.
Ex:if condition city = chennai . its only allowed to enter the field otherwise not entered the value.

We can give expression on the Value side of a user property. Plz check the syntax once again.

Syntax should be:

If([Field]="value","Result")

or

Iff([Field]="value","result if condition meets","result if condition not met")

What is static picklist?

Static picklist is like a drop down in common application. in Siebel perspective we can say it fetches value fron S_LST_OF_VAL . You can create a static picklist in Siebel tool with a "type value". In application you can put values (which you want to display as dropdown items) in List of Value . It can be bounded or not. If bounded then you can add value to the field contains static picklist other than the values available in dropdown. But if it is not bounded then one can add value other than drop down items available.

What is IF table in EIM?

IF Stands for Interface Tables .Prior to Siebel 6, interface tables used to be suffixed with the ‘_IF’ suffixEx : S_CONTACT_IFFrom Siebel 6 onwards, the interface tables are named with the prefix ‘EIM_’Ex: EIM_CONTACT

suppose i write a script on the browser side and get some output. Can this same output be tranferred to / called from the Server side script ? If YES, how and if NO, why not ?

We can interchange the output using the Business Servises. Send this output to a Business Service. and access the BS from a Server Script.

How do you control visibility in Siebel?

visibility will be controlled by Position and Responsibility in Siebel. Position dictates the Data level visibility and the Responsibility dictates the view level visibility.

What is the difference between an organization and division in Siebel?

Organizations can be used to control data visibility, Divisions cannot.Divisions can be used to set Default Currencies.

How do you set up employees in Siebel?

The Employee is also a USER who must be assigned with a valid position. Since the Position maps to the Division which in turn maps to a Organistion the Data visibility is maintained through this position and the Responsibility of the user.

What happens if you create an employee in Siebel application and forget to create?

The employees would not be able to log in as you have to create a database login and password for the employee to login into the client application.

the employee in the database?

The employee details will be stored in contact (his personal information), employee (his position, organisation) and user (his user ID, pasword and other details) entities.

Why do you need to create employees at the database in Siebel?

To enable the employee to connect to the database using the Application and have database access, the user corresponding to that employee should be created in the Database

What is position type field in position applet?

Position type field is a picklist in position applet

What does an opportunity, account contact do in Siebel?

In siebel, opportunity account and contact are the business entities. and these entities have relationships for example one account has many opportunity etc., the relationships are one to one or one to many, many to many. These business entities are very essential to configure siebel application.

How is the opportunity related to an account?

oppotunity to account M:1 and account to opportunity 1:M

How is tools architecture constructed in in Siebel?

In siebel tools
Type gives parent child relationship
and Flat displays all the siebel objects
and Detail gives all the records in object.

What is the new layer in Siebel 7.x version?

Physical User Interface Layer

What do you mean by virtual business comp. in Siebel?

A BC which is not Based on any Siebel Base Tables and which get data data from other external sysytems instead of getting data from underlying siebel Base table

How does your b/c and view related?

View contains applets which are related to b/c. Collection of b/cs is b/o.
Navya

Top
________________________________________
Re: Siebel General Interview Questions &amp; Answers
by Navya » Mon May 12, 2008 1:19 pm
How do you display the no. of records in a picklist(combo box/drop down) not the records in the pickapplet, in just 3 rows and not 5 rows(which is the default)?

Set the HTML no of rows to 3

What is the use of the indirect multivalue link and how do you configure it?
use of indirect MVL.
consider there are 3 bus comps. in that say there is no relation ship between the 1st and 2nd bus comp and there is relation ship between 2nd and 3 rd bus comp. but some fields are necessary from the 2nd bus comp. it will be fetched through the relationship from 1st and 3rd bus comp. this is called indirect MVL.

Whats the difference between siebel 7.5 and 7.8? if we upgarde the application to 7.8 from 7.5 what are the areas we need to give importance from QA(Testing) point of view?

Various Areas are --&gt;
1. Workflows to be activated
2. All server components ( including repeating component)
3. All Interfaces
4. Third party software integration ( Humming Bird, ChartWork Server, IBM-LDAP, Actuate etc)
5. Actuate reports
6. Copy/Reprice Quote Functionality
7. Assignment Manager
These are the major area I believe.

What is the maximum number of applets can be there in a view
There can be eight applets at most in Siebel6.
There can be 16 applets at most in Siebel7.7.
How to call external webpage from siebel application
This can be done through scripting..
For an example:
In preinvoke method for a button click,
window.open(URLNAME)
will open a webpage for a given url in URLNAME variable

What is applet toggle how many types are there?
Applet toggle identifies one or more alternate applets to use in displaying the data of a business component.They are 2 types static and dynamic

What is thedifference between MVG applet And a pick Applet?
MVG is nothing but to display the child records for the parent table ,and for pick applet to update join fields
Pick applet is used when there is 1:1 relationship and MVG is used when there is 1:M r/n.

What is Detail Applet and Association Applet?
Detail applet word is used in the context, when there is a Master Detail relation. in this case there will be one master and many child records. so, we usually show these child records in list applet and not in form applet.

How to run Genbscript.exe?
The syntax for running genbscript is:

When you run genbscript.exe, all browser scripts in the repository are generated. They are placed in a directory that you specify using the destination directory parameter (dest_dir). The genbscript.exe utility is located in:

siebsrv_root/bin or client_root/bin
genbscript config_file dest_dir [language]
For example:
genbscript c:sea15022client inenuuagent.cfg c:sea15022clientpublicenu enu

Difference between LOV and Picklist??
LOV is to store the values for the picklist in the application admin and where as picklist is used to select the value from the list of values

What value will get stored in the database when a field has both predefault value and post default value.
Answer is Predefault Value.
Explanation:When user clicks the new record button,predefault value will get populated in that field,post default value will get stored only when user does'nt type any value in the field and saves the record.Since already value has been populated by predefault property,it will get stored in the database.

What is Symbolic URL in Siebel.
Symbolic URL allow you to configure Portal Agents in several ways. You use Symbolic URL Arguments for two purposes, to define data to be sent to an external host and to submit commands to SWE that affect the behavior of Portal Agents.

What is forceactive property?
Force Active property for a field makes it accessable in scripting even if it is not in UI.

What difference between join specification and join definition?
"Join" object specifies the table name and "Join Specification" object specifies the Primaty Key Foriegn Key relationship.

1 what is difference between eai and emi?
1. EAI deals with exchanging data among the different Enterprise Applications. It is devided into two parts.
a. Batch Integration:(EIM) Data will be sent another system on a bulk basis. This is done periodically.
b. Realtime Integration: Data will be sent to other system whenever there is a change in data of one system. Data is immediately sent. The amount of transfered data is less.

2 where does xml comes into picture in eai
2. XML come in to the picture when a Legacy system has to send data to another Legacy system. And the format of both systems data is different. XML is W3C standard tool. which has to be followed by all to generalize the message sending formats. That is why XML is being used between heterogeneous applications.

3 what are third party eai tools
Third Party EAI Tools.
a. IBM MQ Sieries
b. TIBCO
c. XML
d. MSMQ
e. Seebeyond

What is difference between s_opty_x and s_opty_xm tables.
s_opty is a base table for which
s_opty_x is an extension table with 1:1 relationship
s_opty_xm is an extension table with 1:M relationship

How do you add Button Icon in a Applet?
Like New,Query,Delete.I want Activate Button also .
You can add those bittons by creating controls under that applet
and specifying a method name under that.
you can get a Dropdown box for method Name and select from that.

How will you do validations in escripts and in configuration?
In Tools select the object definition,right click and select validate. this is used to check the correctness of values of a perticular object before going to store.
in escripting, once we write script then we can do validation by check syntax option.

What is detailed category in configuration,and its use?
In an application, we see a page tab let say Account. Below that we have let say My/My Teams/All Accounts. Each has a form applet showing account name, address etc. Related to this we have several tabs like account address, account profile…clicking on which show us accounts detail in that specific area.
So the Account is Aggregate category. My /my teams/all is Aggregate View…These tabs which will show details of Account is Detail Category. So any child object of a aggregate category showing details of an entity is Aggregate category.

What is detailed category and what is its use in configuration.
Detailed Category and Aggregate Category are the two different sets. You can add a view to a screen under Detailed Category or an Aggregate Category. For Example:
If I am creating two Views as detailes views. First I need to create a Detailed Category. Then I have to create two Detailed Views, for which the "Category" property must be specified with the created Detailed Category name. This is same for Aggregate Views also.
Navya

Top
________________________________________
Re: Siebel General Interview Questions &amp; Answers
by Navya » Mon May 12, 2008 1:28 pm
What is constrainted picklist? Where you will drop the constraints?

Constrainted picklist displayed value based on contaraint used.

Add field to constraint in pickmap of a field where picklist has configured in BC and set constraint option of added field to true.

How will you edit the joined fields values in join?

Using picklists and MVGs. MVGs require join field and link as prerequisites unlike picklists where just a join is enough.

How will you improve your performance in views?

The basic factors for performance decrease in views will be. more number of applets. which led to many links. and more joined fields in a single applet. MVG's which do not have the primaries set.

What is Virtual BC? what is the use of vbc?

Virtual Business Component is used to display the data from another Legacy database table, in the Siebel screen.

What is Siebel file system?

It is a shared directory that stores compressed files used by Siebel applications. Examples: Product literature, sales tools, presentations
Read/write access is controlled by the File System Manager component on Siebel Server.

How is Siebel 7.x architecture different from Siebel 6.x?

In siebel 7.x it was defined as 1.Physical user interface2.Logical user interface3.Business layer4.Data layer5.Third party RdmsThe main difference is , In siebel 6.x Phycial interface was not achieved.In Physical Interface includes web templates, css sheets

How is load balancing maintained in Siebel?

Load balancing is maitained by the Gateway server using the third party software Resonate Central Dispatch.

What is Resonate?

Resonate is third party software development tool, which is used for distibuting the cilent request to the least laden siebel server.

What is nameserver? What does it do?

Name server is the part of gateway server that dynamically registers all servers in enterprise, serves a connection broker across the enterprise.

Is it required to install gateway server before installing a Siebel server?

Yes, Because one Gateway Server can have multiple Siebel Servers

What is the use of catch in escript?

The catch clause is used to handle the exception. To raise an exception, use the throw statement.
When you want to trap potential errors generated by a block of code, place that code in a try
statement, and follow the try statement with a catch statement. The catch statement is used to
process the exceptions that may occur in the manner you specify in the exception_handling_block.
The following example demonstrates the general form of the try statement with the catch clause. In
this example, the script continues executing after the error message is displayed:
try
{
do_something;
}
catch( e )
{
TheApplication().RaiseErrorText(Clib.rsprintf(
"Something bad happened: %s
",e.toString()));
}
Navya

Top
________________________________________
Re: Siebel General Interview Questions &amp; Answers
by Navya » Mon May 12, 2008 1:34 pm
What is the relationship between a view and a b/o?
View references the business object. Every view is associated with a particular business object.

Why is it not recommended to modify existing base tables?
During upgradation it will cause problem if we extend base tables.More over if it is necessary u can go for extension tables

How do you create extension table to an interface table in Siebel?[/color]
Extension tables are created only for base tables.I think we can not extend the interface table.

What is an extension table and how is it related to base table?[/color]
Extension table may be 1:1 realation table to the base table or a 1:M relation to the base table.
1:1 extension table and the base table are logically considered as a single table.
Par_row_id will be the foriegn key.

Can you create an extension table with an intersection table?[/color]
We can not create an extension table with an intersection table

How do you create intersection table?
In Tools select new object wizard in that select Table enter the name of the table starting with CX_ and select the project and specify the type of table i.e. an intersection table for the two existing tables
Then it will ask the first Parent Table and foreign key column name for the first parent table in the same way fill the second parent table and FK column.

How is Siebel 7.x data model is different from Siebel 6.0 data model?
S_PARTY is the base tables and S_CONTACT,S_ORG_EXT,S_POSTN, S_USER are now extension tables. Siebel 6.x was dedicated application while from Siebel 7.x onwards we can access Siebel application via web.

What is seed data in Siebel?
The data that siebel supplies as a part of siebel vanilla application is seed data.

What is s_party table?
S_PARTY Table is the Base Table for all the Party related tables.
S_ORG_EXT
S_CONTACT
S_USER
S_BU
and etc.
the party tables can have the implied joins. the party related BC's have the S_PARTY as the base table. so, any of these tables are extension tables.

What does install.ksh and imprep.ksh files do?
Imprep.ksh : This is a database unix shell script provided by siebel for importing all your sif files in siebel repository.It is automatically run while installing siebel and it prepares Repository file in tools.
Install.ksh : contains all manually applied installation files.
Navya

Top
________________________________________
Re: Siebel General Interview Questions &amp; Answers
by Rahul » Sun Mar 01, 2009 3:51 pm
Hi
What is the Relation Between Position and Responsibility?
Are they Similar if so plz let me know How?
If they are not similar what is the differance between them?
ow these two are useful in an organization to control visibility?

Thanks
Rahul
Navya wrote:What is the relationship between a view and a b/o?
View references the business object. Every view is associated with a particular business object.

Why is it not recommended to modify existing base tables?
During upgradation it will cause problem if we extend base tables.More over if it is necessary u can go for extension tables

How do you create extension table to an interface table in Siebel?[/color]
Extension tables are created only for base tables.I think we can not extend the interface table.

What is an extension table and how is it related to base table?[/color]
Extension table may be 1:1 realation table to the base table or a 1:M relation to the base table.
1:1 extension table and the base table are logically considered as a single table.
Par_row_id will be the foriegn key.

Can you create an extension table with an intersection table?[/color]
We can not create an extension table with an intersection table

How do you create intersection table?
In Tools select new object wizard in that select Table enter the name of the table starting with CX_ and select the project and specify the type of table i.e. an intersection table for the two existing tables
Then it will ask the first Parent Table and foreign key column name for the first parent table in the same way fill the second parent table and FK column.

How is Siebel 7.x data model is different from Siebel 6.0 data model?
S_PARTY is the base tables and S_CONTACT,S_ORG_EXT,S_POSTN, S_USER are now extension tables. Siebel 6.x was dedicated application while from Siebel 7.x onwards we can access Siebel application via web.

What is seed data in Siebel?
The data that siebel supplies as a part of siebel vanilla application is seed data.

What is s_party table?
S_PARTY Table is the Base Table for all the Party related tables.
S_ORG_EXT
S_CONTACT
S_USER
S_BU
and etc.
the party tables can have the implied joins. the party related BC's have the S_PARTY as the base table. so, any of these tables are extension tables.

What does install.ksh and imprep.ksh files do?
Imprep.ksh : This is a database unix shell script provided by siebel for importing all your sif files in siebel repository.It is automatically run while installing siebel and it prepares Repository file in tools.
Install.ksh : contains all manually applied installation files.
Rahul

Posts: 1
Joined: Sun Mar 01, 2009 3:40 pm
Top
________________________________________
Re: Siebel General Interview Questions &amp; Answers
by sathi » Wed Mar 11, 2009 4:11 am
position and responsibility are related to organisation.responsibilty is tagged to position.one position can have many responsibilities and one responsibilty can be tagged to many positions.
sathi

Top
________________________________________
Re: Siebel General Interview Questions &amp; Answers
by sathi » Wed Mar 11, 2009 4:27 am
Navya wrote:How do you import List of Values?

Depends on any Hierarchies, but using EIM_LST_OF_VAL(for EIM load) import parents first then children, otherwise you will receive failure message.

What is the difference between EIM and EAI?

EIM : It is batch mode Integration. When data valume is large then we have to go to EIM

EAI : It is real time Integration. When data valume is small then we have to go to EAI

What is the difference between Join and Link?
sathi wrote:join is between a table and a B.C where as link is between a B.C and B.C

Join:

(i)It defines M:1 relation between a field in BC to the Column in table.

(ii)Source Field is the Foreign key field in BC while Destination column is the Primary Key column in Table.

Link:

(i)It defines 1:M relation between a field in parent BC to the field in the child BC.

(ii)Source Field is the Primary Key field in Parent BC while Destination Field is the Foreign Key field in child BC.

How do you set up employees in Siebel?

The Employee is also a USER who must be assigned with a valid position. Since the Position maps to the Division which in turn maps to a Organistion the Data visibility is maintained through this position and the Responsibility of the user.

How do you assign responsibilities to employees in Siebel

In Administration Group &gt; Employee there is a field called Responsibility there add your new Responsibility, make as Primary and remove the old one.

What are Pre defined Queries?

Pre Defined queries are some thing which helps us to navigate directly to particular screens or views. it helps in accessing the screens or views in faster manners

What is an extension table and how is it related to base table?
sathi wrote:the most common columns which we see on opening that particular view come from base table and the others from extension tables
Extension table may be 1:1 realation table to the base table or a 1:M relation to the base table.

1:1 extension table and the base table are logically considered as a single table.

Par_row_id will be the foriegn key.

What is the difference between "PickList Generic" and "PickList Hierarchical" Business components?

"PickList Generic" BC is used for Static Picklists. "PickList Hierarchical" is used for Hierarchical PickLists

what is the link specification
Link spec uses parent type default values &amp; gets the value for the child record

What does Business Component User Mode indicate

Business Component User Mode specifies the Visibility setting for the BC. Like "All", "Personal", "Manager", "Organisation".

What is All Mode Sort?

This property determines whether or not siebel will override the sort specification and if so determines the sort that will be applied to the BC for All or Manager's view. The values are TRUE, FALSE or NORMAL

NORMAL --uses BC defined sort specification
True --Overrides the BC osrt and Uses the U1 index
False - Removes all sorting.

When you have Pre Default Value and Post Default value for a Field, which one will be stored in the Database.

Pre Default Value will be defaulted when new record is created. Post Default Value will be defaulted if there is no value specified for the field. so, Pre Default Value will be stored in the Database. harsha: you can add quistions by clicking the hyperlink on the above bar "Ask Quistion".

How do you specify a view to be displayed as aggregate view in Siebel 7.7

when adding view to screen specify the type as aggregate view.But Before that you should create the parent category.then add this parent category to aggregate view.

or

Parent category for Aggregate view is not required. If there is a parent category for an aggregate view, then aggregate view will appears as a link in the view drop-down list in applet headers, or it will appears as a link in the link bar below screen tabs.

Why do we use Symbolic Strings in Siebel 7.7

In Siebel the text that is displayed on the screens and views are stored in the repository and compiled to an SRF file. This includes the names of every screen, views and fields. When you display a page the server uses the SRF file to determine which fields to show and what test (strings) are associated with each fied. This model of keepijng the strings from the view definition is called symbolic strings.

uses
Reduces the redundancy
Simplifies maintenance because only you have to maintain one string for a given Term
Reduces the localization costs, Time and inconsistences.

what is horizontal and vertical in siebel?

Siebel Hrozontal application is general to every industry. where as Vertical is specific to a industry. such as eAutomobile, eInsurance, eBanking etc.

What is the "Parent Category" property for a Screen View?

This Parent Category specifies the view heading for a bunch of views related. the views belongs to this Parent Category will be shown as View Tabs below the master applet.

What is the function of SWSE on the Web Server? what is it?

SWSE(Siebel Web Server Extension)'s function is to accept the siebel requests and pass it on to Gateway server where the server manager decides, to which siebel server component should this request go.

Is it possible to have multiple database servers for one gateway server.

YES, But it needs multiple enterprise servers, for multiple database. As not more than one database, could be added to an enterprise server, these inturn could be connected to a single Gateway Server

What is eapps.cfg file. and what is its significance.

Eapps.cfg file means swse.

This significance is which application should point to which object manager.

Pick Applet, Dynamic Picklist: which will be better if performance issue is considered.

Pick applet and dynamic picklist both are one
(Or)
DPL Contains the pick applet . So both are the one and same

Oracle has released an advisory, Siebel Quick Fixes for version 8.1.1.10 and 8.2.2.3 that customers must apply to address functionality issues.

Mandatory Siebel Quick Fixes for Version 8.1.1.10

Mandatory Siebel Quick Fixes for Version 8.2.2.3

When invoking an Oracle Stored Procedure, if it is invoked using VB Script, the output parameter works as expected. If invoked using eScript, the output parameter does not get updated.Create a Stored Procedure.Set up a test to execute each of the scripts. The VB script returns the value, the eScript does not.