300+ [UPDATED] Siebel – CRM Interview Questions

1. What’s Siebel?

SIEBEL is the leading provider of Customer Relationship Management (CRM) software.

2. What Difference Between Fields And Single Value Fields?

Multi Value field has the child values from a child BC for the parent record configured through MVL. single value field will be either from the base table or joined table.

The Difference between Single Value Field (SVF) and Multi Value Field(MVF)
SVF- a field in BC which references a column in a table.
MVF- a field in parent BC which references a field in child BC.
Field-Identifies and defines a field in a business component. All fields making up a business component record contain entries from both Single Value Field and Multi Value Field object types.

3. What Is The Difference Between 1:1 And 1:m Extension Tables?

1:1 extension table is like an extension to the base table. if we do not have the required table space in the base table for craeting new extension columns, we will use the 1:1 extension table’s columns using an implicit join.

in contrast, 1:M extension tables are used for parent child relationship with the base table. where the 1:M extension has only related to the base table. for example, for a contact (S_CONTACT) there will be a number of specialities in the extension table(S_CONTACT_XM) with the parent child relationship.

4. What Is Complex Join? Difference With Foreign Key Primary Key Join?

Complex joins are joins which have following diffrences from a PK-FK joins

# Complex joins can have conditional mappings like >,<,>=,NOT,AND,etc apart from ‘=’ whereas the PK-FK joins are always ‘=’.
# PK-FK joins are always (1-N), whereas complex joins can have (1 – 0,1) and (0,1 – N) kind of relationships.

5. What Is Localisation?

Modify the object definitions in the local repository.

6. What Is Different Between Bounded And Unbounded Picklist?

We can enter free text incase of Unbounded Picklist. But, incase of Bounded Picklist, we can not enter freetext.

7. Dynamic Picklist Is Used To Update Join Fields? How?

Actually we cannot modify the join fields we cannot do any modifications and updations on that fields to do these things we create the dynamic picklist or pickapplet.dynamic picklist to modify (to enter new records )in the join fields.

8. What Is The Primary Difference Between Siebel 7.5.2 And 7.7 Versions ?

Are having lot of differences between siebel 7.7 and 7.5.2. the primary difference among them is ” Symbolic strings are available in Siebel 7.7 and not available in 7.5.2″. hence the future scope for upgradation like things are high in siebel 7.7.

Optimization techniques in EIM
1) Limit base tables and columns to be processed by using : only base Tables,ignore base Tables,only base Columns,ignore base Columns.
2) Always delete batches from EIM tables upon completion. Leaving old batches in the EIM table wastes space and can adversely affect performance. For other suggestions on working with batches.
3) Run independent EIM jobs in parallel. Two or more EIM processes can be started simultaneously by using the Siebel Server Manager.
4) Trace Flag Settings, using Synonyms, primary key only Parameters Limiting the Number of Records and Rows for Merge Processes.
like this many techniques are there which will optimize the EIM process.

9. How To Create Drilldown In Form Applet?

Usually Drilldowns will be in List Applets only. But, in Siebel 6 there are Drilldowns on Form applets also. But, these are not similar to those in List Applets. in order to go to the target view we need to right click on the applet, on the menu shown we can find the available Drilldowns with Title as “Go To XYZ View”.

10. 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.

11. What Is Constrained Picklist? Where You Will Drop The Constraints?

Constrainted picklist displayed value based on constraint 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.

12. 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.

13. 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.

14. 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.

15. 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.

16. How Is Siebel 7.x Architecture Different From Siebel 6.x?

In siebel 7.x it was defined as

1. Physical user interface
2. Logical user interface
3. Business layer
4. Data layer
5. Third party Rdms

The main difference is , In siebel 6.x Phycial interface was not achieved.In Physical Interface includes web templates, css sheets.

17. How Is Load Balancing Maintained In Siebel?

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

18. What Is Resonate?

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

19. 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.

20. Is It Required To Install Gateway Server Before Installing A Siebel Server?

Yes, Because one Gateway Server can have multiple Siebel Servers.

21. 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()));
}

22. 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.

23. 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.

24. How Do You Create Extension Table To An Interface Table In Siebel?

Extension tables are created only for base tables.I think we can not extend the interface table.

25. 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.

26. Can You Create An Extension Table With An Intersection Table?

We can not create an extension table with an intersection table.

27. 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.

28. 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.

29. What Is Seed Data In Siebel?

The data that siebel supplies as a part of siebel vanilla application is seed data.

30. 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.

31. 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.

32. 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.

Link is between the entities and MVL is between the records.

33. Describe The 3 Object Explorer (oe) Tabs?

Types: higher level object types displayed.
Details: expanded top level object type displays object definitions of that type.
Flat: displays all definitions of that type.

34. What Object Types Have A Sort Specification Property?

BCs,
Pick Lists,
Links.

35. What Are The Steps For Creating A Static Pick List?

Create a new static pick list. Add BC field that will be populated. Map the BC field to the pick list BC field. Specify which control or list column will invoke the pick list applet. Picklist will be empty until values are put in the S_LST_OF_VAL table.

36. What Are The Steps For Creating A Dynamic Pick List?

Create a Pick list using a BC representing the joined table. Associate the Pick list with a BC field. Map the BC fields to the Pick list BC fields. Create a Pick list applet. Specify which control or list column will invoke the Pick list applet.

37. What Are The Steps For Creating A Mvg?

Create a MVL in the parent BC. Add MVFs in the parent BC. Create a MVG applet to display child records. Add controls/list columns to the parent applet to display MVFs and invoke MVG applets. Add primary FK in the parent BC and on the MVL.

38. What Is A Primary Key?

A primary is a FK on the parent-side that points to one “primary” record on the child-side of a 1:M link. A primary FK creates a 1:1 link between the parent and the child.

39. How Do You Create A Primary On A Mvl?

Add a primary key field on the parent BC. Set the Primary Id Field and Use Primary Join properties on the MVL.

40. List Some Of The Calculated Field Limitations?

Cannot be used as sort criteria, stored in columns and read only. Validation criteria on calculated fields is ignored. If SQL is used and performs a calculation, the value will be applied after the data is in the BC, but before displaying in the applet.

41. Describe The Types Of Siebel Database Extensions?

Standard extension tables – Predefined tables which support 1:1 or M:1 relationship. Part of the existing physical database.Custom extension tables and custom extension columns – New 1:1 tables, New columns that are added to new and existing tables.

42. What Are The Steps For Using A Standard 1:1 Extension Table?

Add a joined field in the parent BC (based on the “main” table). The join is implied and created automatically at runtime. Add a control or list column to an applet.

43. What Are The Steps For Using A Standard 1:m Extension Table?

• Create BC to represent 1:M extension table
• Set Search Spec to equal Pre Default Value “TYPE” field
• Add fields to the new BC (ensure “NAME” and “TYPE”)
• Create a link from BC to New BC and add the New BC to BO
• Create applet to display data from new BC.

44. What Is Data-driven Access Control?

Controls the read-only nature of BC, BC record, or BC Field based on value of another BC Field.

BC Read Only Field:
     current record read only
Field Read Only Field:
    field specified by field name is read only
Parent Read Only Field:
  BC read only.

45. Name The 5 Main Building Blocks Of The Siebel Architecture?

File Server,
Gateway Server,
Enterprise Server,
Siebel Server,
Siebel Database Server.

46. Name The Four Levels Of Control We Have Over The Server?

Enterprise,
Server,
Component,
Task.

47. Explain The 5 Main Functions Of The Server Manger?

Controls your Enterprise,
Manages Siebel Servers,
Allows the configuration of the components,
Allow you to run tasks,
Collect statistics.

48. Name And Explain The Three Modes Of Component Operation?

Server Mode: run background operations for the server and runs forever, once started,
Task Mode: run specific task and exits upon completion,
Session Mode: created dynamically for client request. Runs as long as session is maintained then exits.

49. How Do You Invoke Wfs?

Run Time Events – specified at Start Step (Event Object, Event, Event Type), Scripting – Business Service, Workflow Policies.

50. What Are The Steps In Outbound Wf?

Start – EAI Siebel Adapter – EAI XML Converter – HTTP or MQ Series or File Transport – Write to file.

51. How Do You Handle Error Handling In Wfs?

Persistency, Exception points and write to file, Write a error handling workflow.

52. What Is Persistency? How Is It Useful?

To trouble shoot or debug the workflow in workflow process log by drilling down on, persistency level and frequency it affects the performance- stores the state information.

53. What Is State Model?

Provide a data driven method for extending workflow control based on the status SR Open – Cancelled, you define the state model.

54. What Transport You Used In The Wfs?

HTTP, MQ Series, EAI File Transport

55. When Do You Use Sub Process In Wf?

WF process is created at BO level, if we deal with multiple business objects.

56. What External Systems Did U Interact With And With What Middleware?

with Biz Talk (XML, MQ series) or See Beyond (uses ASP pages) or TIBCO (Siebel Connector) middlewares.

57. Explain Where Did You Use Wf In Your Last Project?

Claim Submission; to insert the data into Audit Table; write a business service Add Responsibilityadding a responsibility to the new person logging in. -Retrieve role ( find the user role) – Add responsibility (row id of the user and responsibility), user BC.

58. Did You Use Custom Bss In Wfs?

Yes, For changing Priorities.

59. Explain Where Did You Have To Create Bs?

Tools

60. How Do You Pass Inputs To Bs?

Through Input Arguments & Script.

61. What Language You Used To Write Bs?

eScript (or) Siebel VB

62. Did You Use M:m Relationship In Your Last Project ?

Yes, for Position & Responsibility, Account & OPTY

63. How Do You Pass Query Criteria To Bs From Bc In Bs?

Search String (VBC – input.searchstring)

64. Which Etl Tool You Used For Data Loading?

Informatica, Data Stage

65. Name The Databases You Have Worked On?

SQL, Oracle, DB2

66. Where You Involved In The Design Phase And What Did You Do?

Designed BCs, BOs, Applets, Views, Screens, etc

67. What Kind Of Data Source Do You Have In Your Project And How Did You
Connect To It?

ODBC; Change data source name in Tools & Assign it in the Data Base.

68. Which Component Schedules, Monitors, Configure Etl Routines?

DAC client.

69. How Can You Purge The Cache?

(a) Use cache manager
( b) setting the Cache Persistence Time in the Physical Table dialog box for a particular table
( c ) use event polling tables.

70. Can One Presentation Catalog Refer To Multiple Business Models?

No

71. Can Multiple Presentation Catalogs Refer To One Business Model?

Yes.

72. What Happens If You Create An Employee In Siebel Application And Forget To Create The Employee In The Database?

User Id not found

73. What Does An Opportunity, Account, Contact Do In Siebel?

They are Siebel business entities in which we have a business interest.

74. How Is The Opportunity Related To An Account?

Its Associated with an Account for generating Potential revenue.

75. How Is Tools Architecture Constructed In Siebel?

Explorer & List Editor

76. What Do You Mean By Virtual Business Comp. In Siebel?

To get external data from external database without storing it in Siebel Database.

77. How Does Your B/c And View Related?

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

78. What Is The New Layer In Siebel 7.x Version?

Web Layer

79. How Is Siebel 7.x Data Model Different From Siebel 6.0 Data Model?

Party data model in 7.x.

80. What Are The Different Layers In Siebel?

Data Storage layer, Business Layer & Data Presentation Layer.

81. What Is The Difference Between Mvg & Dynamic Picklist?

A new value could be added through an MVG where as Dynamic Pick Applet could only be used to pick a value from a pick applet which could be constrained to show relevant data. A value entered through an MVG will show up in a Dynamic Pick Applet if the Dynamic Pick Applet is based on that MVG.

82. What Is Tpm ?

It is something related to Siebel Trade promotion Management

                                                     OR

TPM = Total Productivity Management. Its a manufacturing term..

83. How We Will Create Drilldown In Form Applet……….please Explain?

Usually Drilldowns will be in List Applets only. But, in Siebel 6 there are Drilldowns on Form applets also. But, these are not similar to those in List Applets. in order to go to the target view we need to right click on the applet, on the menu shown we can find the available Drilldowns with Title as “Go To XYZ View”.

                                                  OR

It is possible through scripting either Siebel VB/ eScript.

84. How Can A Particular User Among Four Users With Same Responsibility
Can Have Access To Particular View And This View Should Not Be Visible To
Other Users?

yes by assigning the position and giving a unique, user id he can access the data.

                                                           OR

The new views which are to be restricted from the other 3 users can be grouped up in a separate responsibility and then the 1st user can be assigned that the newly created responsibility. This will save time and will ensure smooth operations as well.

85. I Have Created Hierarchical Picklist. In Parent All The Values Are
Displayed. When The Values Selected In The Parent Its Displays Proper
Value In The Child Picklist?

The search specification for the parent pick list should be “Parent Id is Null”.

86. What Is Siebm?

siebmtsh.exe is a process created when you bring up siebel servers, depending on the number of object managers that are enabled the number of siebmtsh.exe processes increases.tsh.exe

87. What Is Link Specification?

The field value passed as the default value to the child business component when the link spec is specified.

88. How Is Siebel 7.x Architecture Different From Siebel 6.x? How Is Siebel
7.x Architecture Different From Siebel 6.x?

In siebel 7.x it was defined as

1. Physical user interface
2. Logical user interface
3. Business layer
4. Data layer
5. Third party RDBMS

The main difference is , In siebel 6.x Physical interface was not achieved. In Physical Interface includes web templates, cuss sheets.

89. 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 particular object before going to store. in escripting, once we write script then we can do validation by check syntax option.

90. Siebel 7.7 How Do You Add Button Icon In An Applet? Like New,query,delete.i Want Activate Button Also?

You can add those buttons 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..

91. What Is Difference Between S_opty_x And S_opty_xm Tables?

s_opty is a base table 
s_opty_x is an extension table with 1:1 relationship
s_opty_xm is an extension table with 1:M relationship.

92. What Is Difference Between Join Specification And Join Definition?

“Join” object specifies the table name and “Join Specification” object specifies the Primary Key Foreign Key relationship.

93. What Is Force Active Property?

Force Active property for a field makes it accessible in scripting even if it is not in UI.

94. 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.

95. 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.

96. What Is Detail Applet And Association Applet?

Detail applet is nothing but Form Applet, Association applet is used to implement M:M relationship.

                                                                           OR

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.

97. What Is The Difference 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.

                                                           OR

Pick applet is used when there is 1:1 relationship and MVG is used when there is 1:M r/n.

98. 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.

99. What Is The Maximum Number Of Applets Can Be There In A View?

There can be eight applets at most.

100. What Is The Use Of The Indirect Multivalue Link And How Do You Configure
It?

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.

101. 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.

102. What Is Seibel Admin Mode View? How To Create One?

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

103. 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, and 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.

104. 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 foreign key of another table’s primary key in the 1:M extended table.

105. What Is Siebel Gateway?

Siebel Gateway is the name server which controls the Enterprise Server.

106. How Can You Do The Data Cleansing In Eim?

EIM Does not support data cleansing.

107. How Can You Resolve Foreign Key In Eim?

Populate all User key columns which will resolve foreign key. still u have doubt let me know.

108. 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.

109. Where Does The Primary Field Of An Mvg Stored?

Primary Id Field will be stored in the Parent BC.

110. 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.

111. Why Do You Need Primary In Mvg?

for a multivalue field there is a field called SSA Primary Field available in the parent BC. this field stores the primary child. which avoids querying on the child BC for displaying the value in the MVG. this is for performance improvision. this creates 1:1 Link.

112. When Do We Use Genbscript.exe?

it creates the class files for the JavaScript (browser scripts).

113. 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 compile those BS’s.

114. 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.

115. 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.

116. What Is Horizontal And Vertical In Siebel?

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

                                                                               OR

These are the types of applications. Example for Horizontal applications is transport. Here are examples for vertical applications are Eservice Call center application etc.

117. Why Do We Use Symbolic Strings In Siebel 77?

For up gradation and language conversions.

118. How Do You Specify A View To Be Displayed As Aggregate View In Siebel
7.7?

when add the View to the Screen you have a property called Type in which, you have to select “Aggregate View”.

119. 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-usesBCdefinedsortspecificationTrue –Overrides the BC sort and Uses theU1index False – Removes all sorting

120. What Does Business Component User Mode Indicate?

Business Component User Mode specifies the Visibility setting for the BC. Like “All”, “Personal”, “Manager”, “Organization.

121. 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.

122. 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.

123. How Do You Set Up Employees In Siebel?

Create the users first, then assign them some responsibility and position. then create the database login.

124. What Is The Difference Between Eim And Eai?

EIM : is used for importing or deleting the large data
EAI : is used to integrate the Applications.

125. 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.

126. When Do We Go For Bc Level User Properties?

when we need to set or reset the properties at runtime.

127. How Do You Recognize 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 Public, we can.

128. What Are The Different Types Of Columns?

Columns:

1. Data (Public),
2. Data (Private),
3. Denormalized,
4. Extension,
5. System

129. How Many Type Of Siebel Data Model Extensions Are There?

standard and custom extensions

130. What Does Position Represents In Siebel?

In siebel, Based on the position of the employee, the records will be displayed.

131. 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.