What is Siebel EAI, and what are its key components? 

Siebel EAI (Enterprise Application Integration) is a set of tools, technologies, and methodologies provided by Siebel Systems for integrating the Siebel application with other external systems. It allows seamless data exchange and communication between Siebel CRM and other applications. The key components of Siebel EAI include integration objects, business services, adapters, workflows, and EAI object manager. 

Explain the various integration methods available in Siebel EAI. 

Siebel EAI supports multiple integration methods such as Web Services, EAI Adapters, File-based Integration, Messaging, and Database Integration. These methods enable integrating Siebel CRM with other systems using different protocols and standards. 

How does Siebel EAI handle data transformation and mapping? 

Siebel EAI provides various tools and techniques for data transformation and mapping. The EAI Siebel Adapter and the EAI XML Converter are commonly used for transforming and mapping data between different formats, such as XML, XSD, and Siebel Integration Object formats. These tools allow developers to define mappings and perform data transformations according to the specific integration requirements. 

 What are the different types of adapters provided by Siebel EAI, and how are they used? 

Siebel EAI offers several adapters, including the EAI HTTP Adapter, EAI JMS Adapter, EAI MSMQ Adapter, EAI MQSeries Adapter, and EAI File Adapter. These adapters are used to integrate Siebel CRM with external systems through different communication protocols and messaging systems. They provide the means to send and receive data, invoke web services, and interact with various technologies. 

Can you describe the publish-subscribe mechanism in Siebel EAI? 

The publish-subscribe mechanism in Siebel EAI enables real-time event-based communication between Siebel components and external systems. It involves publishing events or messages by a publisher component and subscribing to those events by one or more subscriber components. When an event occurs, the publisher notifies the subscribers, allowing them to take necessary actions or update data accordingly. 

What is the purpose of the EAI Object Manager in Siebel EAI? 

The EAI Object Manager in Siebel EAI is a component responsible for handling inbound and outbound integration requests. It manages the execution of workflows, business services, and adapters required for integrating Siebel CRM with external systems. It acts as an interface between Siebel components and the external world, handling data exchange and processing. 

How does Siebel EAI handle real-time and batch integrations? 

Siebel EAI supports both real-time and batch integrations. Real-time integrations are typically handled using web services, messaging, or direct database integration methods, allowing immediate data exchange between systems. Batch integrations involve processing data in large volumes at scheduled intervals using file-based integration or EIM (Enterprise Integration Manager) techniques. 

What are some common challenges faced during Siebel EAI implementations, and how would you overcome them? 

Common challenges in Siebel EAI implementations include data transformation complexities, performance bottlenecks, error handling, and version compatibility issues. To overcome these challenges, it is crucial to thoroughly understand the integration requirements, design robust data transformation logic, optimize performance through caching and tuning, implement comprehensive error handling mechanisms, and ensure compatibility between Siebel versions and external systems. 

Can you explain the concept of data validation and error handling in Siebel EAI? 

Data validation in Siebel EAI involves ensuring the accuracy, completeness, and integrity of the data exchanged between Siebel CRM and external systems. This can be achieved through pre-defined validation rules, business service methods, or scripting techniques

Read More »

IBM Siebel EAI Interview Questions collected from interviews.

• What is the main difference between HTTP integration and web services?
• If web service has to send data to the Virtual Business Component– how can it be done?
• When you import a WSDL file in tools.u create a proxy BS.What happens if there is a change in the namespace in the WSDL. How would you change that in Siebel?
• Explain in detail the Siebel Integration architecture?
• What are the Siebel EAI value Maps ?
• Explain the difference between Siebel repository and SRF file ?
• Is it possible to Deploy and Activate the workflow Directly to the Application?
• Can you tell me what are the different Integration Component Keys?
• What arguments do we pass for upsert method in EAI Siebel Adapter?
• What is query page method In Siebel? How would retrieve another set of records using query page method? How will you set this up?
• How will you implement security in Web Services?
• Explain Web Service Architecture or how the input/output message comes/goes to/from siebel(soap messages converted into property sets)
• Can you tell me what are the user properties for proxy BS?
• What happens when we click on the Synchronous Button for an IO in Siebel?
• What are Integration Objects, and why they are needed? Why cant we integrate without having IOs?
• How will you find relationships between different integration components?
• What are the parameters we have to give for inbound http?
• Explain the differences between VBC and EBC?
• What are the various business service methods for VBC?
• What are the various Integration component user properties?
• How will you decide whether you have to use VBC or EBC?
• What do you mean by SOAP?
• Explain what is the difference between Name, Externam Name and xml tag in IC fields?
• What does synchronize method do in EAI Siebel Adapter?
• Differentiate between VBC and normal BC?
• Explain with a small example what do you mean by WSDL?
• How do you achieve "Web Service Security?What are Security mechanisms available in Siebel?
• Can we have a workflow Process as Web Service in Siebel ?If not Why ?
• How do you Deploy a Web Service in Siebel?and how do you share the Web Service details with external Application?
• How do you access External Data from Siebel?
• Explain how do you integrate with Siebel?
• Explain the Basic Needs for any basic integration scenario?
• Difference between EAI XML converted and XML Hierarchy converter?
• How is the address specified in Inbound Webservice?
• Can you tell me how JMS is different from RPC?
• Differentiate between Integration Objects and Integration Object Instances?
• What is the difference between EAI Dispatch Service and Workflow?
• How to publish an ASI as Siebel Inbound Web Service?
• Can you tell me how do you create an inbound Web Service?
• If the Object Manager is down will the Web Service work? What component must be up and running in order to successfully implement inbound Web Service?
• Explain what are the advantages of JMS?
• How do you create an External IO in Siebel?
• Why do we need Datamaps ?and what are the basic needs to have a Datamap?
• What are the IO user Properties? Can you explain with examples?
• What is an Inbound Web service and Outbound Web Service?
• How do you implement Inbound Web services and Outbound Web Service?
• What are the various transports supported by Siebel Applications for publishing web services?
• How do you create an outbound web service?
• How does inbound HTTP request work?
• What is the basic difference between Publish Subscribe model and P2P model?
• What are the methods available in EAI Siebel Adapter?
• How is the response send from Siebel end to the third party application using web services?
• Explain what are dispatcher services in Siebel?
• What is the difference between runtime Events and workflow policies?
• Why are Database Triggers and why we need them?
• Why do we need the Siebel Workflow Monitor Agent?
• Explain what is the difference between Workflow Process Manager and Monitor Agent ?
• What is the difference between topic and queue?
• How do you debug a Siebel workflow in a live environment ?
• What do you mean by Siebel Process Property and where do we use them?
• What are the various integration Techniques available in Siebel?
• While creating integration Objects – are the calculated fields created?

Read More »

Delloitte Siebel Interview Question and Answers.

What is implied Join. Where do we find it?
The join between a base table and its 1:1 extension table is called implicit. The name of implicit join is same name as the extension table. For example, S_PARTY and all its extension table S_ORG_EXT, S_CONTACT, S_POSTN, S_BU etc. Similarly implicit join exists between a base table and its Inter Section table as well. Example S_OPTY and S_OPTY_CON

How do you recognize that a particular table (Base table) can be extended?
If the table type property is other than Extension, it can be extended.

What is an extension table and how is it related to base table?
Table of type extension are additional tables with implicit 1:1 relationships to its parent base table, the table it logically extends. They provide additional columns that you can use to store data.

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

What is All Mode Sort?

What does Business Component View Mode indicate?
It defines allowable access control mechanisms that can be applied to the business component in any view

What is the view mode of following bcs?
Account – Position (You assign position to the sales team), Organization
Opportunity – Position, Organization
Contact – Position, Organization, Person
Service Request – Person (Single Owner) here you assign LOGIN to SR, Organization
Action – Person (Multiple Owners)

What is the difference between "PickList Generic" and "PickList Hierarchical" Business components?
Both BCs are based on S_LST_OF_VAL table. PickList Hierachical has more field than PickList Generic and it is used for creating hierarchical picklist.

What is the base table of Account, Contact bc?
S_PARTY

What is S_PARTY table?
This is the base table for all party business components.

List different party type?
Party Type Business Component
Organization Account (S_ORG_EXT), Organization (S_BU), Division (S_ORG_EXT)
Person Contact (S_CONTACT), Employee (S_EMP_PER), User (S_USER)
Position Position (S_POSTN)
Household Household (S_ORG_GROUP)
User List User List (S_USERLIST)
Access Group Access Group (S_PARTY_GROUP)

Explain the difference between an organization and division in Siebel?
Account - [Internal Org Flag] = 'N', data gets populated in S_PARTY and S_ORG_EXT tables
Division - [Internal Org Flag] = 'Y', data gets populated in S_PARTY and S_ORG_EXT tables
Organization - - [Internal Org Flag] = 'Y' and [Organization Flag] = 'Y', data gets populated in S_PARTY, S_ORG_EXT, S_BU tables
All Organizations are division, but the reverse is not true.

What is the intersection table of party entities?
S_PARTY_PER

How do you create extension table to an interface table in Siebel?
Using wizard

What is the relationship between a view and a b/o?
M: 1

How does bc and applet related?
1: M

How is the opportunity related to an account?
M: 1

What does an opportunity, account contact do in Siebel?

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

How do you control visibility in Siebel?

Visibility control can be done at 2 levels.
1> View visibility – this is done by responsibilities
2> Data Visibility – this is done by positions

How to specify owners for a business component?
By using BusComp View Mode. This is a child object of Business Component.

Siebel Interview Question	Siebel Certifications
Siebel Admin Tutorials	Siebel Troubleshooting
Siebel Best Practices	Siebel Tutorials

Read More »

Siebel Workflow Questions and Answers.

How to fetch a mvf value in workflow
Type- Expression
Value-[Organization]
Business Component- Service Request
Here Organization is a multi value field in Service Request business component.

How to Lookup a value stored in a process property in a Workflow
Use workflow Utilities Business Service.


Output Arguments:
Property Name: LkUpValue
Type:Output Argument
Output Argument : LookupValue(’TYPE_VALUE’,[&ProcessPropName])
If the value is found in the LOV, it will be stored in the LkUpValue process property.


Search Specification used in the Workflow
Filter Business Component : Service Request
Type : Expression
Search Specification: ”[SR Category]=’”+[&SR Category]+”’ AND [SR Type]=’”+[&SR Type]+”’”Expression Business Component : Service Request

How to Update a mvf using Siebel Operation Step:
All fields are available for update and insert except fields based on multi-value groups and calculated fields. If you want to update a field based on a multi-value group, you can define a business component for the field and link the business component to the object using Siebel Tools. An example is an update to an Account Team. Account Team is based on a multi-value group, so it cannot be updated by selecting the Account business component. However, you can create a business

Design a Workflow Processes
Working with Siebel Operation Steps component called “Account Team” and then associate it with the Account business object using Siebel Tools. You could then select Account Team as the business component to update with the Siebel Operation step.

The object ID for the process is automatically passed to Siebel Operation steps.
Because this automatic passing occurs, you do not need to enter a search specification value unless you are updating child records. For example, if you have a process based on the service request object and you want to update the service request, you do not need to enter a search specification. However, if you want to update activities for the service request, you may want to enter a search specification to query the specific activity that you want to update. Otherwise, the
update step updates all activities for the service request.

When performing a query operation for child records, the Siebel Operation Object
ID process property field will return the row ID if one record matches, a “*” if multiple records match, and Null/no value if no records match.The insert/update operation updates the Siebel Operation Object ID process property field of the record’s row ID.

NOTE: The Workflow Policy programs and Siebel Operation steps use different object layers to update data. For example, you may have a Workflow Policy that calls a Workflow Policy Program to update a Service Request Record. This method goes through the Data Layer in which State Model does not apply.Conversely, if you have a Workflow Policy that calls a Workflow Process Action and in the Workflow Process, you have defined a Siebel Operation step to update a Service Request Record, this method goes through the Object Layer in which the State Model does apply.

Siebel Interview Question	Siebel Certifications
Siebel Admin Tutorials	Siebel Troubleshooting
Siebel Best Practices	Siebel Tutorials

Read More »

Siebel Realtime Interview Question Answers.

What do you mean by spooling?
Spooling is the process of extracting sql queries that gets fired in the database. This can be achieved in 2 ways.
1> In siebel.exe, right click – Properties, add this /s “PATH i.e C:\\log”
2> Create a environment variable with properties. Variable - SIEBEL_LOG_EVENTS, Value - 5

Suppose I write a script on the browser side and get some output. Can this same output be transferred to / called from the Server side script? If YES, how and if NO, why not?
Yes, we can call server script from browser script, but the reverse is not true.

What is force active property of field?
When Force Active is TRUE, the field is queried each time the business component is instantiated, even when the field is not exposed on the user interface. The data value is always retrieved from the database. It indicates the db engine to include this column in the select statement.

What is Link Specification property of field?
TRUE = Specifies that the field's value in parent bc is passed as a default value to a field in the child business component.

What is Long List property of Picklist?
It specifies whether the Siebel application should attempt to position the cursor on the current value in a long list of values. When you specify Long List = TRUE for a picklist list, the Siebel application does not keep focus on the current record

What is detailed category and what is its use in configuration.

How will you do validations in configuration?
By using the Validation property of field

How do you add Button Icon in an Applet? Like New, Query, Delete. I want Activate Button also.

What is difference between S_OPTY_X and S_OPTY_XM tables?
S_OPTY_X is the 1:1 extension table of S_OPTY where as S_OPTY_XM is the 1: M extension table.

What difference between join specification and join definition?
Join specification is the child object of Join definition. In join specification, we populate the source filed (FK field to the JOIN table and Destination Column, PK of the JOIN table.

What is the difference between LOV and Picklist?
We create LOV in the Application and associate the LOV with the picklist using value property.

What is Symbolic URL in Siebel?
It is used to call external webpage from siebel application.

How to run genbscript.exe?
this is used to generate browser script.
\"c:\\program files\\siebel\\7.8\\web client\\bin\\genbscript.exe\" c:\\progra~1\\siebel\\7.8\\webcli~1\\bin\\enu\\siebel.cfg \"c:\\program files\\siebel\\7.8\\web client\\public\\enu\" enu pause

What is Shuttle Applet?
Shuttle Applet is a combination of MVG Applet and Association Applet. The binding happens at the run time. It is used to M:M relationship. In a Shuttle Applet, the lhs applet is Association Applet and rhs applet is the MVG applet.

What is the difference between MVG applet and a pick Applet?
We associate MVG applet with an mvf control (control based on mvf) and Pick Applet with a picklist control (control based on picklist field). Type for MVG Applet is MVG and pick applet is Pick List.

What is applet toggle how many types are there?
It identifies one or more alternate applets to use in displaying the data of a business component. Toggle is of 2 types i.e. Static and Dynamic toggles. If the Auto Toggle Field and Auto Toggle Value is specified, it is Dynamic Toggle else Static Toggle. Static toggle can be based on different BCs but Dynamic toggle is always based on same BCs.

Business Scenario – When Activity Type is Inactive, I want to show a List Applet with 10 fields, else I want to display a List Applet with 5 fields. How do you achieve it?
Ans – By using Dynamic Toggle.

Read More »

Siebel interview questions asked in Accenture

Dear Readers. We have listed more than 40 questions collected from Siebel Interviews in Accenture. Please feel free to use the comment section for the answers so that it helps the others.

1. If a created view cannot be seen in the application, what can be the possible reasons for it?
2. Explain what are the basic entities in Siebel?
3. Explain with a diagram the basic Application Architecture of Siebel 8.1 ?
4. What are the different ways to save a record in Siebel?
5. Why there are joins to s_party extensions?
6. You want to change the fonts in your Siebel Application. From where you can do that?
7. EIM status is partially imported. What does this mean?
8. In a view\’s web layout, you cannot choose a specific applet. Why?
9. What are the businesses external to your company?
10. What is the best practice to populate default values during EIM data load?
11. What is a visibility rule in Siebel? How will it be controlled from the Application level.
12. What is the difference between High Interactivity client and Standard Interactivity  client?
13. You have added a new column to list applet but you cant see it in the application. Can you tell the reason why?
14. You want to use "attrib_40" column in S_OPTY_X. How you can be sure that it is not used?
15. For a required field, there does not exist legacy data. What we should do?
16. Can you tell me in which files the ”SWE” tag is included?
17. What are the candidates for assignment? Explain the Assignment Manager in brief. 
18. What is customer data. Where is it stored?
19. Where the enterprise profile file is located? In which environment?
20. You created a new view but you cannot see it. What can be the reasons?
21. Should SQL be applied to EIM tables?
22. What is database authentication. How it is performed. Explain?
23. Where the information is stored for the contacts?
24. You created a task but cannot see it when you login to the application. What can be the possible issues?
25. How can a user see contacts screen before accounts screen?
26. Explain the State model in Siebel.
27. What are the score candidates? Explain how score candidates help in Assignment.
28. What are the required architectural components for a Siebel deployment to run properly?
29. What is master data? Where is master data stored and how it helps in the data model in Siebel.
30. Which authentication method(s) support user self management?
31. You created a workflow policy but you cannot see any record in S_ESCL_REQ table. What can be the issue.
32. How can be visibility defined for business components?
33. We added a new field to a view and want it to be always a positive number and not null..
34. What is the base table for contacts in Siebel? How it is related to the party table? 
35. What is the Application Behavior While Creating a List Applet ?
36. Which environments I can use to export and activate a workflow?
37. You deploy a user list, then added more users. What happens if you restore enterprise?
38. How can you query an MVG Field in Siebel?
39. We want to show a new field in a view, describe the configuration strategy..
40. What are the sets of parameters that may be used by multiple components?
41. Can you tell us which objects should be created after task creation?

Read More »

Siebel CRM Interview Question and Answers asked in top companies in India and abroad.

How do you configure a MVG?
Create link between parent and child bc
Create an mvl in parent bc referring the above link
Create mvf in parent bc using the above mvl
Create an mvg applet based on child bc
Add the mvg applet to the applet control and set the run time property to true.

How do you configure a dynamic picklist?
Create a picklist based on pick bc
Associate the picklist with the parent bc field.
Specify the pick map. In case of dynamic picklist you have to do Id pick map as well.
Create a pick applet based on pick bc.
Add the pick applet to the applet control and set the run time property to true.

How do you configure a static picklist?
Create a picklist based on Picklist Generic bc (Static picklist draws data from S_LST_OF_VAL table), specify Type as Type and Type Value as LOV created in the Application
Associate the picklist with the parent bc field.
Specify the pick maps.
Set the run time property of the Control to true.

Why do you need Primary Id field in MVL?
Primary Id field in the master business component holds the row ID values pointing to primary records in the detail business component. In this way we make 1:M relationship 1:1. It helps in improving the performance. Let’s say in list applet there are 10 records and in each record we have 2 mvg. If don’t specify primary, 21 queries get fired (1+2*10 = 21, 1 query to fetch parent records, 2 inner queries to fetch mvg records/parent record (total 2*10 = 20)). If we specify primary id fields only 1 query gets fired.

When you have Pre Default Value and Post Default value for a Field, which one will be stored in the Database?
Pre Default
Pre Default – value of the field when you create new record. Event – BusComp_NewRecord ()
Post Default - If the field value is null before saving the record then post default will get fired. Event – BusComp_PreWriteRecord ()

How do you set up employees in Siebel?

What are different types of Tables?
Data, Interface, Repository

What are Pre defined Queries?
These are stored queries enable users to perform queries

How do you assign responsibilities to employees in Siebel?
Navigate to Administration – Users àEmployees, query for the employee and assign responsibilities

What is the difference between Join and Link?
Join is a relationship between bc and table. The relation is 1:1 or M: 1. Account in Opportunity, Account in Service Request
Link is a relationship between 2 bcs. The relation is 1:M or M:M. Business Address in Account, Activities in Account

Read More »

How to call external webpage from siebel application?
Using symbolic url

What is the maximum number of applets can be there in a view?
N number

What is the use of the indirect multivalue link and how do you configure it?
Usually the parent bc of link on which the mvl is based on and the parent bc of the mvl are same. If there are not same, then it is an indirect mvl. For example, consider Business Address mvl in Opportunity bc.
1> Business Address mvl is based on Account/Business Address. The parent bc of Account/Business Address link is Account.
2> Parent bc of Business Address mvl is Opportunity.
3> So this is an indirect mvl. This is useful if want to restrict child data based on some field value. In this example, in Opportunity we are displaying only those addresses which are associated with the Opportunity’s Account. The restriction is done by using Source Field property of mvl. Here the source field is Joined Account Id.

What is the purpose of 1: M extension table?
This is used to create master detail view (parent child relation).

Business Scenario: A contact can have multiple hobbies. I want to display contact and its hobbies in a new view. How do you configure this?
1st we need to identify a table on which we will create the new bc (Hobby). Here parent bc is Contact (S_CONTACT) and child bc is Hobby and relationship is 1: M. So we will use 1: M extension table of S_CONTACT, i.e. S_CONTATCT_XM.
1> Create a bc Hobby on S_CONTACT_XM table. Pre default the Type field in the bc to Hobby (value that correspond to bc name). Put the search spec on the bc Type = ‘Hobby’.
2> Create a new applet based on Hobby bc.
3> Create a link between Contact and Hobby bc. Source Field = Id, Destination Field = Parent Id
4> Put the new bc in the Contact bo.
5> Create a new view based on Contact bo.
6> Administer the view. (Create view in the application and add view to user’s responsibility)

What is the use of Item Identifier?
Used by the Siebel Web Engine to associate a control with a particular position within a web template. It is a property of Applet Web Template Item and View Web Template Item.

What is the difference between Links and Multi Value links?
Link is a parent object. Link is used for parent – child (master – detail) view. MVL is a child object of Business Component. We create mvl based on link. MVL is used in MVG Applet. This is used to display child details on the parent applet using mvg applet.

What is foreign key table in Siebel?
It is a property of Column. It specifies the table to which this column is a foreign key. Leave NULL in extension column.

When do we go for Dynamic PickList and for Pick Applet?
If we want to display data from a different BC (table other than base table), then we use dynamic picklist. The pick applet is always based on pick bc (child bc). For example, showing Account details in Opportunity, Activity, Service Request etc.

What is the difference between siebel sales and call center applications?
Both are employee applications, sales are used for selling products, call center is used for catering services to the customers

How can you make one applet editable in one view and read-only in other view?
By using Applet Mode property of View Web Template Item

What is drilldown? Explain different type of drilldowns?
Drilldowns allow users to click a hyperlink in a field and be taken to another view that displays more information about the field. Drilldowns are used primarily in list applets. Drilldowns can be either static or dynamic. A static drilldown always takes the user to the same view. A dynamic drilldown takes the user to different views, depending on certain conditions, such as the value of a field.

How to configure a drilldown?
1 go to applet, create a new drilldown object, specify Name, Hyperlink Field, View and Sequence. This is for drilldown in same BO.
2 If you are drilling down to a different BO, then you have to specify Source Field (FK Field), Destination Field (Id) and Business Component.
3 For Dynamic Drilldown, we have to create Dynamic Drilldown Destination object in the lowest sequence Drilldown Object.

Can you configure drilldown on Form Applet?
No, Drilldown behavior is not supported on MVG applets, pick applets, or association applets as well.

What is the visibility applet type for following views?
My Accounts View – Sales Rep – User sees all records where his/her position is a part of sales team (Primary and Non- Primary)
My Team’s Accounts View – Manager – User sees all records where his/her position or its sub-ordinate’s position is primary on the sales team. Only Primary Record, sub-ordinate can be direct or indirect as well
All Accounts View – Organization - User sees all records where his/her Organization is a part of Account Organization (Primary and Non- Primary)
All Accounts across My Organization – Sub Organization - User sees all records where his/her Organization or its sub-ordinate’s Organization is primary on the Account Organization. Only Primary Record, sub-ordinate Organization can be direct or indirect as well
All Accounts across All Organizations – All – All record with a valid owner, union of above
This rule applies to Opportunity and Contact also.

What do you see in My Activities View and My Service Requests View?
My Activities View – Records where user LOGIN is present in Employee field
My Service Requests View – Records where user LOGIN is present in Owner field

How web client access Siebel data?
When web client types the url in the web browser, it will go to the web server. In web server we have virtual directory that contains entry for all Siebel applications. It searches the request in the virtual directory. If it finds it, it recognizes it as a Siebel request and passes it to SWSE. SWSE reads eaaps file. Eapps.cfg file has information like which protocol to use, gateway address, enterprise name and object manager. With these details, it establishes connection with the gateway server. Gateway server reads siebna.dat file and passes siebel server address to SWSE. Then SWSE connects to the Siebel server. SWE runs as a service of AOM. It constructs the html pages using SWT filed. Data manager generates SQL statement in response to AOM request and populates html pages. Then Siebel server passes the html pages to web server and web server passes it to the web browser.

Explain different kind of client?
Web Client – Requires no installation
Mobile Web Client – Requires installation, uses local cfg, srf and database
Dedicated Client – requires installation, uses local cfg, srf but server database

Read More »

Can it be used for State Models?
Yes. Check ADM Bookshelf to confirm. Supported data types are listed in appendix.

Can we deploy the objects, based on the changed flag or beween some date ranges?
Data/objects need to be filtered during the data/ojects export, before the deployment session. You can apply filters to data/objects based on different criteria. Refer to ADM Bookshelf.

Do we need to have ADM OM Management Agent in all target Siebel server?
Yes, if you want to use 8.x ADM through Management Server and Management Agent.

For the multi target deployment, shall we enter Target Enterprise username, password, etc connection parameters in the Target Profile?
You need to run Management Agent Config Wizard to register target Enterprises. The entries will be recorded automatically in ent_profile.xml. Refer to both Installation Guide and ADM Guide.

Is it possible to use other EAI methods beside upsert and sync?
Until 8.1.1, we only support upsert and sync methods.

What are the key points one need to take care while working on orchestration?
Please review Chapter 7 “Guidelines for Deploying Siebel ADM” in ADM Bookshelf which has some best practices of ADM deployment using Management Server.

How do we get to know if it is a successful or a failed deployment? By looking at the log files?
Refer to Chapter 8: Siebel ADM Logging Capabilities and Troubleshooting in ADM 8.x Bookshelf.

Can we have ADM load for Customized Businees Components ?
You need to create custom data type and register it to ADM registry.

Whats the Limitation of ADM in terms of number of records it can export in a single shot ?
ADM export is subject to the limitation of EAI file export.

It can't be used for Admin-State Models as far as I know. Can anybody confirm that ?
Check ADM Bookshelf to confirm. Supported data types are listed in appendix.

How about managing bulk data loads?
ADM is designed to manage small volume of delta configuration changes. For bulk data loads, use EIM or native database utilities. Also refer to Chapter 7 “Guidelines for Deploying Siebel ADM in ADM Bookshelf”.

How to configure the Management Server?
Refer to 8.x Installation Guide. Tech Support also has a simplified write-up about Management Server setup. Contact them to get details.

Creation of package should be completed in the source environment, but the command line interface is available in the Management Server side? In the Source Enterprise should we have the Management Server?
Correct. No, you don’t need install Management Server at your source Enterprise, although some people choose co-installing both source Enterprise and Management Server in one box.

Can we have one Management Sever for multiple target Enterprise Servers ?
Yes, but you need to register all Enterprise servers into the same Management Server and genearate separate ent_profile for each target Enterprise. During the deployment, you need to manually plug in the correct ent_profile so Management Server can deploy to the right target. The recommended way is to install multiple Management Servers, one per each target Enterprise. Refer to slide 25, 26 and 27 in ADM Presentation.

Can one package used by multiple instances of Management Server pointing to different target environments ?
Suggest you run Packager utility from different instance of Management Server to generate multiple packages. Since the data source is the same, the content of mulitple packages should be the same.

Can we manage multiple deployments?
The short answer is yes. The following sections in ADM Bookshelf may help:
- About the Siebel Management Agents and Siebel ADM
- Parallel deployment and load balancing
- Choosing to Use a Staged or Full Deployment

What about Management server on UNIX? Is there any plan to enhance the product so that it can be installed on the Linux box ?
Management Server is supported on Microsoft Windows only. There is no short-term plan to make it work on Unix box. Note that Management Agent is supported on all supported OS platforms, including Linux.

Read More »

I have collected some Siebel ADM Question Answers asked in top companies like IBM, Accenture and TCS

Q1 Is ADM functionality available to all Siebel applications? or does require a saperate license?
A1– Yes, ADM supports all Siebel applications. It’s part of Siebel CRM Enterprise package. No extra license is needed.

Q2 Does it support only http?
A2 – In 7.7 and 7.8, ADM supports HTTP online deployment, file export/import and command-line deployment. In 8.x, a new deployment method is added to support deployment through Siebel Management Server. All supported methods are documented in ADM Bookshelf.

Q3. Can we use ADM for dev2prod process?
A3 – Dev2prod is used to migrate full repository. ADM is used to migrate small delta changes of configuration. They are complimentary one another. Refer to Chapter 7 “Guidelines for Deploying Siebel ADM”.

Q4. Where do we supply the username of the target env? There is only prompt for the password for the target env. Please Explain
A4 – When you kick off the online deployment session through ADM UI, user will be prompted for the password of target environment.

Q5: Is it mandatory to have EAI Object manager available on Target System while running the ADM through command line interface?
A5 – In 7.7 and 7.8, EAI Object Manager is required for ADM online deployment. Server Manager is used for command-line deployment. In 8.x where Management Server is used, ADM server components including ADM Object Manager need to be up and running for ADM deployment.

Q6. How do we modify existing package for new changes?
A6 – We do not recommend modifying existing package once it is created. If a change is needed, re-export the chanded data and files from source environment, then run Packager utility to create a new package. Make sure to validate the packager before deployment.

Q7. What happens if there is error in executing a package? Will it rollback the complete package?
A7 – Yes. Package deployment is all or nothing, either complete or rollback as an entire entity.

Q8. Can you please provide the data types that ADM cannot be used ?
A8 – We only provide a list of data types that are supported out of the box. Refer to ADM Bookshelf. In general users can register their own data types as custom data types to Management Server. But in rare cases like product configuration model, due to the complexity of data structure, it might be challenging to construct certain custom data types properly.

Q9. Can we add our own data types? Is it complex? I have heard that we can modify ADM registry file. How is adding custom data-types in 'ADM registry' supported? Is there any document providing information about content objects and modifying them to use custom data types ?
A9 – Yes, you can add your own data types. It involves multiple steps including creating Content Object and Integration Object, then registering it into ADM registery. Detailed steps are documented in ADM Bookshelf. Note that customers are reponsible for testing out custom data types to make sure they are created properly.

Q10. Are there any exceptions to restore option (objects where it cannot be applied)?
A10 - The restore task is subject to various limitations and must be performed while a valid ADM deployment session is active and before the deployment session is acknowledged. If you perform a restore after data has been modified post deployment and before acknowledgment, the modified data is lost.

Q11. Which utility is faster for repository migration - Database Server Configuration or Application Deployment Manager ?
A11 – Refer #Q3. It depends on your usage scenario. Refer to Chapter 7 Guidelines for Deploying Siebel ADM.

Q12. Data such as Create, Created By, Updated, Updated By.., will this information gets update in target ?
A12 – Yes.

Q13. Can ADM be used to migrate products? E.g. a new product is being launched. It is set up and tested in Test environement. Now, I want to deploy this product in Production environment.
A13 – Per “ADM Supported Data Types” in 8.x ADM Bookshelf, the following data types are supported: Product Catalog, Product Feature, Product Line, Products.

Q14. What is the role of source_configuration flag?
A14 - There is no such a flag called “source_configuration”. The closest one is “Session Configurable” flag -- check this field if further configurations are required when accessing this project as a deployment session. If this value is unchecked, the project field, Export to File, is read-only, as are the project data type fields, Active and Deployment Filter.

Q15. DEV2PROD should be used where extensive repository changes have been made. DEV2PROD runs outside ADM control. Is this correct ?
A15 - Correct. Refer to Chapter 7 Guidelines for Deploying Siebel ADM. Also refer to #3.

Q16. Can we create a package without Management Server?
A16 – Pacakage is generated outside of Management Server. You can run Packager utility which is a stand-alone utility to create a package. Note you need to install MS in order to get Packager utility installed.

Q17. File export and import - how to get log files for import job?
A17 – After a deployment session completes or fails, ADM creates a log file in the deployment session record. The log files provide details on any failures, as well as source and target environment information.

To access ADM migration log files

1 From the application-level menu, choose Navigation > Site Map > Application Deployment
Manager screen.
2 From the link bar, click Deployment Sessions.
3 In the Deployment Sessions list, click the deployment session record of interest.
4 In the Log field, click on the log file number.
5 Review log file details in the Log view.

Q18. When we migrate State models, it migrates the Positions and Users associated to them. List of users in Source and target envs are not same. How to migrate State Models without users?
A18 – This is a special scenario. Please log a service request to Tech Support.

Read More »

Siebel Interview Questions asked in HP India.Some questions are related to Workflow

1. What is work flow process in Siebel.
2. What are WF policy groups and policies.
3. How do you create a WF policy group.
4. How do you invoke your WF through WF policies
5. What kind of operations can you perform through WF policy groups
6. How many local data base do you initialize
7. What is routing model
8. How do you extract the database from server.
9. After initializing the local data base can a developer can work on tools.
10. What is assignment manager and what are the comparison objects in it.
11. For running a WF process through WF policies what are the components need to be running .
12. What are the two tables used in the workflow policies.
13. How do you run workflow-monitoring agent.
14. What is the escalation request table?
15. What does the action request table do?
16. What are the parameters do you pass while running a workflow -monitoring agent.
17. What kind of configuration have you done in this project.
18. What is dynamic drill down.
19. What is your current business requirement.
20. How do you configure dynamic drill down.
21. What are the types of invoking the work flow.
22. How do you invoke workflows through the runtime events?

Read More »

Latest Siebel Interview Questions and Answers collected from Real Time Interview in top companies like CTS, IBM , HP Delloite

1. If we have Dynamic Picklist as Bounded, Can we add record?

Yes ..But incase of static picklist it is not possible..

2. In an Applet create a custom button and enable it.

a. Create a control “Test” on the Applet with Method Invoked property as “TESTMETHOD”.
b. Add the following script in the WebApplet_PreCanInvokeMethod event(Right click on apple & edit serverscript)

function WebApplet_PreCanInvokeMethod (MethodName, &CanInvoke)
{
if((MethodName == "TESTMETHOD")
{
CanInvoke = "TRUE";
return(CancelOperation);
}
return (ContinueOperation);
}

3. How to invoke a Business Service on click of a buton?

a. Create a control “Test” on the Applet with Method Invoked property as “TESTMETHOD”.
b. Add the following script in the WebApplet_PreCanInvokeMethod event

function WebApplet_PreCanInvokeMethod (MethodName, &CanInvoke)
{
if((MethodName == "TESTMETHOD”)
{
CanInvoke = "TRUE";
return(CancelOperation);
}
return (ContinueOperation);
}

c. Add the following user property in the Applet
Name - Named Method: TESTMETHOD
Value - 'INVOKESVC', 'Service Name', 'MethodName'

4. Is it possible to access more than one Database at a single siebel application?
Yes

5. If Gateway Server is not present cant we do Load Balancing?
No

6. What is a calculated field?
Calculated field derives it’s value from other fields..It can not be stored in the database therefore column property is blank..
Restriction on calculated field:---
* It can not be stored in the database
* It is Read-only..
* Sorting is not supported but querying is supported..


7. I have a view with form applet on the top and list applet at the bottom. There is "score" field in the list applet. How to display the totals of score in form applet?
Create an mvf in the parent BC based on score field. Then create a calculated field with calculated value Sum (mvf)

8. I want to display no of activities associated with an Account? How do you configure this?
a. Create an mvl in Account bc based on Account/Action link
b. Create a calculated field with calculated value Count(“mvl”).
c. Display the calculated field on the Account applet.

9. Now I want to count no of Activities of an Account with Priority = 1-ASAP

Type Field and Type Value property of the mvl can be used to put search spec on the child bc. Here Type Field = Priority and Type Value = 1-ASAP. Then do the Count(“mvl”).

10. In the list applet field we have 10 records but i have to display only 2 records in list applet, what is the process should i follow?
Set HTML No of Rows Applet property to 2.

Read More »

What is the difference between EIM and EAI?
EIM is the process of loading data into Siebel base table. EAI is the exchange of data between Siebel and external systems

What are user properties?
User properties are inbuilt scripts used to configure specialized behavior. This can be added as children to an applet, business component, business service, control, field, or list column

Give examples of commonly used BC level user properties?
On Field Update Set, On Field Update Invoke, BC Read Only Field, Parent Read Only Field, Field Read Only Field, Named Method.

How can you make a field conditionally required? By using Required (Field level) user property.
Create a calculated field ‘CALC’ that will have value Y if the conditions are met else N.
Create a Required user property. Name – Required, Value – CALC

What are the different types of Columns?
Data, Extension, System

How many type of siebel Data model extensions are there?
1:1, 1: M

What is the difference between Master- Detail view and MVG?
In master – detail view, we show master record in the top form applet and child records in the bottom list applet. Here the child data are fetched by the link between master and child bcs. In case of mvg, we embed child information in the master record itself. The user needs to invoke the mvg to see child details. Here the child data are fetched by mvl created in master bc.

What does position represents in Siebel?
It is a party bc. It drives the data visibility.

What happens if you create an employee in Siebel application and forget to create database login?
He will not be able to login into the application.

What is Virtual BC? What is the use of vbc?
When there is a requirement to display data from external system without storing the data in Siebel, we use VBC. VBC is not mapped to any table. It is based on CSSBCVExtern class. The data in VBC gets populated by business service. We create a bc user property to tie VBC with BS. Name – Service Name, Value – BS

What is constrained picklist? Where you will drop the constraints?
If the picklist value is based on a field, it is called constrained picklist. We do the constraining in the pickmap.

What is name server? What does it do?
Gateway server

How do you set up employees in Siebel?

What is Siebel Admin Mode View? How to Create this?
We can make an Admin View by setting Admin Mode Flag property of the view = true. In admin view, you can see all records
(Records without owner as well). User property does not work in Admin View.

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

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

Why do we use Symbolic Strings in Siebel 77?
It encapsulates a piece of text that can appear anywhere on the Siebel user interface. Any Siebel Object that has a translatable string property (such as the caption of a Control object) can obtain a desired string display value by establishing a reference to the appropriate Symbolic String object through its ”String Reference” property (for example, ”Caption – String Reference”). The actual string content for a Symbolic String is stored in one or more child Symbolic String Locale objects, each of which represents the value of the string in a different language. For example, the Symbolic String named ’SBL_ACCOUNTS-0910145428-0HN’ might have two Symbolic String Locale children, one containing the display value for English (’Account’) and one for German (’Kunde’).

Read More »

1 Siebel Implementation in a Big Organization Requires
Ans - Single Gateway Server, Multiple Siebel Server ,Multiple Database Server, Web Server

2 How do you Inspect Installation of SWSE
Ans - Inspect the Virtual Directory from IIS

3 Which are Not Valid Task For setting up mobile Client
Ans - Initializing Server Database

4 What are not the Methods to configure Siebel Application
Ans - Modify Siebel.exe & Directly Write Sql

5 An Update Conflict occurs While Synchronizing with Server and the Data provided by the mobile Client is updated
Ans - Client Wins

6 which is not a valid Pre Installation Task
Ans - Creating the Siebel Database Owner

7 What is the Component Group for WorkFlow that should be Enabled
Ans - Workflow Management

8 True About Views & Data Access Control
Ans - They are Independent of Each other

9 How do you assign users to responsibility
Ans -Application Administration > Responsibilities
User Administration > Employees

10 Set Organization Flag to make a Organization a Division (True or False)
Ans - False ( Caution - we only Set organization flag to set a division as Organization)

11 Name Displayed in Show Drop Down & View Bar
Ans - Screen > Screen View >View Bar text

12 Viewing Parent Child Object defining in Tools
Ans - Use Types Tab

13 Properties for creating a 1 to many Link
Ans - Parent Business Component, Child business Component, Source Field, Destination Field

14 Suffix of Foreign Key
Ans - _ID

15 workFlow Step to Map to another WorkFlow Process
Ans - Sub Process

16 Monitoring a customer Action
Ans - Action Set

17 When does a mobile Client Initialize
When local Dbf Not Found & When a uaf is found in docking user while Synchronizing

18 Which Tag specify the formatting and layout
HTML tag

19 Propagating Database Changes
Check Project into Server
Apply DB Changes to Server
Compile and Test on Server
Reextract Developers and have them get all Projects

20 Static PickList
Can be Bounded or unbounded
Copies Selected value into destination Field

21 What Does BusComp View Mode Definition Specify
Ans - Specifies business Component is subject to Access Control

22 Access Control Mechanism is based by setting which of the following view properties
Ans - Visibility Applet
Visibility Applet Type

22 True about eBusiness Enterprise
Ans -
An Integrated Product Suite
Built on common architecture

23 What type of Application is Siebel call Center
Ans - Employee Application

24 How do you change the interchange the order Contacts and Accounts Screen Tabs
Ans - Application > Page Tab and interchange Sequence for Account and Contact

25 When do you Create a New Business Component
Ans - When you have created a New Extension Table
When you want to Display as a parent applet and child applet in Same view and Data to be populated in both applet is from the same table

26 What is Applet Class for Form Applet
Ans – CSSFrame

Read More »

Accenture Siebel Interview Questions and Answers.

1.  Getattribute("Me.Country") = "USA"
Ans - Checks if the users country is USA

2.  ROW_ID of Table A is 111
ROW_ID of Table B is 2222
In Table B Foreign key of Table A is Stored .What is the Value
ANS - 111

3.  What is the logical Extension table of S_ORG_EXT
ANS- S_BU

4.  What is relation between Service Request and Action
ANS- 1: M

5.    When Web Server Recognizes SWE Tag it passes Control to
ANS - SWSE
(Siebel Server was not given in the options .So Selected SWSE)

6.  Which cannot be done by WorkFlow Simulator
ANS - It cannot have the user Interact Step and wait for user Action

7.   What is Logical Database Structure represented
ANS - DATA Object Definition

8.   DatObject Layer Contains
ANS - Tables & Columns

9.   A Collection of related lists and forms represents functional business Area
ANS - VIEW

10.   What Does a SWE Do after a Template is Created
ANS - Passes Page to Browser Via Web Server & SWSE

11.   Which is not True Regarding Catalogs and Categories
ANS - Catalog is a Node and There are Sub Catalogs in Catalogs

12.  German opportunity assigned to German Sales Rep
ANS - Compare Object to Person

13.  SWE Replaces Siebel tags with Repository Data

14.   Collection of BC
ANS - BO

15.   Which is not a valid task while Installing DB
ANS - Running Database scripts to create DB Schema

16.   What is Authentication?
ANS - Validates the User & Controlled Inside and outside of Siebel

17.  When a Siebel Server is moved from one server to other how is cfg updated in mobile Client
Ans - Automatically updated when Client Synchronizes for the first time

18.  How do u see the Clients last Synchronization Session
Ans - Siebel Remote Administration > Client Status

19.  How do you register a Mobile Client
Ans - Siebel Remote Administration > Mobile Client

20.  Where is Application Object Definitions stored
Ans - SRF

21.   Which Applet Displays Singe Record
Form

22.   What does %printer% in EIM task do
Ans - Delete all records that includes Printer

23.   Relation between two tables is referred?
Ans - Foreign Key

24.   Show Drop Down
Ans - Subset of Data

25.   How can a activity be automatically assigned to a sales rep once it is created
Ans - Interactive Assignment

26.   Who can Delete, Merge & Forecast
Ans - Primary

27.   What is the advantage of primary ID field in an MVG
ANS - Uses a single query to get the parent Record and primary in the child record

28.   What is false about compare objects
Ans- Double Click to compare & Creates a comparison report

29.  How did you See online help for full list of Keyboard Shortcuts
Ans - Help > Contents > Index and Click on K Hyperlink

30.  Whats is true about Sorting
Ans - It is in ascending order by default

31.  What does Transaction router do
Ans - It moves data from Txn_Proc Directory to Docking/user/outbox

32.  Where is the changes of rows in Server Stored
Ans- S_DOCK_TXN_LOG

33.  What does Checkin Do
UnLocks on Server & Unlocks in Client
Replaces old versions of Object definitions with New Versions

34.   Represents a current or potential Client, a business partner is a competitor
Ans - Account

35.  Siebel Mid Market Edition
Ans - Designed for companies less than 100 users

Read More »

Siebel Interview Questions and Answers based on Real Time Scenarios

How to send an email using siebel application other than using F9 functional Key?
Using Out Bound Communication Manager BS

Suppose there is a search spec on BC, and Applet both. Explain the execution of this scenario.
BC and Applet search specs get appended (ANDED). 1st based on BC search spec, records will be fetched from the db and available at applet level. Then the applet search spec will be applied on this data set and sub set of this will be visible in UI.

Ex:-- Let’s say in account BC the search spec is [Status] =’Active’ and on applet the search spec is [Country]=’USA’. So when will go to account screen will see records where [Status]=Active and [Country]=’USA’

Suppose there is different search spec on List and Form Applet in List View. What will happen when I navigate to that view?
The form applet search spec will be retained because form applet gets loaded later.

Explain when we use the following scenarios: Base table having extension columns Extension table having extension columns which one do you prefer? Explain
To fetch data from the extension table needs an extra join. So if the field is readily accessed in UI, it is better to extend the base table. If it is seldom used, extend the extension table.

What is the use of catch in script?
If you want to do some operation after the exception has occurred, it can be done in Catch block.

Can you create an extension table with an intersection table?
Yes(1:1 is possible but 1:M is not possible)

How will you edit the joined fields’ values in join?
By associating a picklist in the joined field

What is seed data in Siebel?
Initial set of user and admin data examples, responsibilities, SADMIN account.

What is repository data?
Object definitions that specify the application look, behavior

what does install.ksh and imprep.ksh files do?
Install.ksh – It populates seed data. Imprep.ksh – It populates repository data.

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

What is Siebel file system?
It is a shared directory used to store compressed files, attachments.

Siebel Interview Question	Siebel Certifications
Siebel Admin Tutorials	Siebel Troubleshooting
Siebel Best Practices	Siebel Tutorials

Read More »

Siebel General Question Answers on Functionalities, Architecture

1.What is an Account ?
Ans :-
• Are businesses external to your company
• Represent a current or potential client, a business partner or a competitor

2.What is a Contact ?
Ans :-
• Are people with whom you do business
• Have the following characteristics
- A name
- A Job Title
- An email Address and phone number

3.What is an Opportunity ?
Ans:-
• Are potential revenue-generating events
• Have the following characteristics
- A possible association with an account
- An identified potential revenue
- A Probability of Completion
- A Close Date

4.What is an Asset ?
Ans:-
• Are Instances of Purchased Products.
• Have the following Characteristics.
- An Asset Number.

- A Product and Part Number
- A Status Level

5.What are Orders ?
Ans:-
• Are Products or services purchased by your customers
• Have the following characteristics:
- An Order Number
- A Status and Priority
- An Associated Account

6.What are Service Requests ?
Ans:-
• Are Requests from customers for information or assistance with a problem related to
Products or Services Purchased from Your Company
• Have the following Characteristics:
- A Status
- A Severity Level
- A Priority Level

7.What is Siebel CRM Enterprise Application ?
Ans:- An installed solution that provides an integrated product suite with functionality
tailored to more than 20 specific industries

8.What is Siebel CRM Professional Edition Application ?
Ans:-
• An installed solution designed for companies with fewer than 100 users
- Provides a family of multichannel sales, customer service, and marketing
applications


9. What is Siebel CRM on Demand Application ?
Ans:-
• A hosted solution that provides core functionality to casual users, business partners,
and remote divisions
- Available on a per-user basis through a monthly subscription

10. What is horizontal and vertical in Siebel?
Ans:-Siebel Horizontal application is general to every industry , where as Vertical is specific to
a industry. such as eAutomobile, eInsurance, eBanking etc.

11.What are the advantages of Multi-phased Approach ?
Ans:-
• Allows for manageable Project Size and Scope
• Helps Achieve Implementation Benefits Sooner
• Applies Knowledge and Experience from earlier Phases

12.What is Siebel eRoad Methodology ?
Ans:-
• Siebel eRoad Methodology consists of 6 Implementation Project Stages:-
- Define Stage
- Discover Stage
- Design Stage
- Configure Stage
- Validate Stage
- Deploy Stage

13.What are Employee Applications ?
Ans:-
• Employee applications
- Are used by internal employees
- Examples include:
- Siebel Call Center
- Siebel Sales

14.What are customer and partner applications ?
Ans:-
• Customer and partner applications
- Are used by customers and partners
- Examples include:
- Siebel Customer Order Management
- Siebel Partner Relationship Management (PRM)

15.What is High Interactivity ?
Ans:- High Interactivity:
• Available for employee applications , supporting highly interactive enterprise users.

16. What is Standard Interactivity ?
Ans:- Standard Interactivity:
• Available for customer applications
• Behaves like traditional web applications , requiring frequent page refreshes.

17. What is the difference between High Interactivity and Standard Interactivity?
Ans:- The following features are supported only by high interactivity.
• Client-side scripting
- With access to Siebel objects on the client side.
• Interactive controls
- Calculator, calendar date / time selector.
• Keyboard shortcuts
- For frequently used commands

18.What is Query Assistant ?
Ans:- Provides a simplified way for users to execute queries from anywhere in the Siebel
application.
- Users do not need to be familiar with query syntax.
- Users can query on any field associated with the originating screen.

19.What value types can the properties of object definitions have ?
Ans:-
• User defined names
• Numerical values
• Boolean values
• Siebel defined constants
• References to names of other object definitions

20.What are the two properties not indicated within the properties window in Tools ?
Ans:- Changed and Project

21.Which tab on the object explorer removes all hierarchy and displays object types in a single
list ?
Ans:- Flat Tab

22.What feature in Siebel Tools would you use to locate object definitions regardless of object
type or position in hierarchy ?
Ans:- Search Repository

23. What is the difference between object type and object definition ?
Ans:-
• An object type is a named structure from which object definitions of a given type can be
created.
- Example :- An ‘applet’ is an object type and ‘opportunity list applet’ is an object
definition.
• An object type has pre-defined set of properties.
- Object definitions created with a particular object type has values for each of
their properties

24. What are the two means of editing object definitions?
Ans:-
• Object List Editor
• Properties Window

25.What is the template called that you used to create an actual object definition ?
Ans:- Object Type

26.How do you compare two projects ?
Ans:- Project Diff

27.What are the three window panes associated with Project ‘Diff’ ?
Ans:-
• Project Differences
• Object Differences
• Attribute Differences

28.What are the different types of projects ?
Ans:-
• User-created projects
• Siebel supplied projects

29.What is the maximum number of Projects an Object definition can belong to ?
Ans:- One and only One.

30.How can you find out what has changed on your local copy of a project compared to the
server version ?
Ans:- Run Project Difference

Read More »

Siebel Realtime Interview Question Answers, Siebel Interview for Realtime problem and solutions

High Interactivity Framework Problem.

We faced this problem quite often in Siebel 7.7.
Problem:
When clicking on Pick Applet in Siebel 7.7 application the application IE instance used to crash and we had to reopen the application. It happened only in case we were working with Pick Applet.

Reason:
This error was due to High Interactivity Framework files getting corrupt.
Siebel can operate with two types of framework

• Standard Interactivity
• High Interactivity.

The difference between both the frameworks is how Siebel Client communicates with Server. In case of standard interactivity the changes you make to record are not committed automatically to the database and use has to explicitly save the record and in High interactivity even if you step of the record or screen the changes are committed automatically.
Solution:
Solution of this problem is to go and remove the High Interactivity framework files and open the application again. When you open your application Siebel downloads fresh interactivity file from server.
These are steps you can follow to remove and reinstall the interactivity files
Goto Internet Explorer –> Tools Menu –> Internet Options
Click on Settings Button

Click on View Objects Button

Locate High Interactivity Files

Siebel CRM – How To Call a Workflow Asynchronously?

This Article is about Siebel CRM 7.X Workflows and Runtime Events. It tells you how can we use them to our advantange.
We all want the response time of our Application to be as fast as it can and we do everything that we can to achieve that. Reduce the response time without actually reducing any functionality. Siebel can execute workflows in two ways.

• Synchronous
• Asynchronous

Synchronous Execution : When workflows are executed Synchronously then user gets the control back only when the workflow has finished it execution.
Asynchronous Execution: When workflows are executed Asynchronously then user gets back the control immediately and the workflow is submitted to workflow process manager (WPM) as a job to be executed.

WPM then executes the job later.
Often we have a functionality where large amount of processing needs to be done on an object which user is not going to use access right now. I can explain it with an example.
When user clicks copy button on a opportunity or quote we want certain custom entities to be copied over but which user will not access at that time but later.
So, we can reduce our response time by just copying the quote or opportunity synchronously and placing the code of copying of custom entities in workflow and executing that workflow asynchronously.
There are two way to execute a workflow asynchronously

• Workflow Policy
• Runtime Event and Business Service (BS) Combination

Workflow Policy is pretty traditional method of executing a workflow process.
You create a policy. Enter the conditions Specify the workflow to be executed Generate Triggers
Disadvantages of using Workflow Policy

1. Slow Execution
2. Difficult to setup
3. Not Reliable and Error Prone

Read More »

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.

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


What will happen if I provide value in both Pre-Default and Post-Default properties?
We will assume the following values have been given for Pre-Default and Post-Default properties of Status Field
Pre-Default Value:  “In Process”
Post-Default Value:  “Complete”
Following are the scenarios which can take place:
User creates a New Record and saves the record without changing value of status field:
Pre-Default value (In Process) will be assigned to Status field.
User creates a New Record and changes the value of Status field to “Planning”
Pre-Default value is going to take effect as soon as user creates a new record but Post-Default value will not take effect. [Corrected as pointed by Gururaj]
User creates a New Record and changes the value of Status field to blank
Post Default Value (“Complete”) will take effect
User copies an existing record where value of status field is “Planning”
Neither Post-Default nor Pre-Default will take effect
User copies an existing record where value of status field is blank
Pre-Default (“In-Process”) Value will take effect
User copies an existing record  and makes the value of the field as blank
Post-Default Value (“Complete”) will take effect
User changes the value of existing record to blank and saves the record.
Neither Post-Default nor Pre-Default will take effect as these values only takes when the record is initially created and saved.

Siebel Workflow Step – Missing Query Operation
Problem:
Had to create a workflow and the first step in the workflow was Query Operation on Opportunity BC. Drag the Siebel Operation Step into designer and then started entering Values for this step which were as following
Type: Siebel Operation
Business Component: Opportunity
Operation: Query
Query was missing in the Operation field dropdown and only Insert and Update were available.

Enter Query manually in the field it accepted the value but started giving error
“Error loading Step Definition: Query Operation not found”
(Not exact error message)
Solution:

Drop down is a pick list in Siebel and picklist gets its values from List of Values. Queried with Insert in the Display Value in List of Values view and there was a LOV Type called “WF_SIEBEL_OPER_TYPE_CD” which had Insert and Update as active and “Query” was inactive.
After making “Query” record Active and restarting tools user should be able to execute my workflow successfully.

Note: Even if you provide LIC of this LOV in small case then also you will get the error. For this LOV Display value has to be in Camel Case and LIC in caps

Read More »

Advanced Siebel Interview Question Answers,Siebel Realtime Interview Question Answers 

What is the primary purpose of using surrogate key?
Will those be used in fact tables? If not then what is the purpose in using it?
Answer:Surrogate key is used for indexing purpose i.e. as a primary key for a table.
Reason of using Surrogate Key over Primary Key:
Primary Key may take more or less memory i.e. it may contain characters but Surrogate Key contains only number. So comparison of numbers is easy when comparing with characters. Yes, Surrogate Key will be used in fact tables to establish a relationship between dimensions. Surrogate keys are implemented by using the Sequence generator.

What is difference between Incremental Compile and Full Compile?
Incremental Compile: When we select a single object (BC, Applet etc), several objects (Multiple BC, Applets, BO etc), single project or several projects to compile in an existing SRF file that is known as Incremental Compile.
Full Compile: When you compile all the projects in a SRF file that is known as Full Compile.
: Difference:
SRF File: We do an Incremental compile on an existing SRF file and Full Compile results in creation of a New SRF file.
SRF Size: SRF size is more when we do an Incremental Compile as compared to Full Compile. For example if a Full Compile results in a 28 MB SRF file then an Incremental compile on that file can increase it’s size up to 32 MB

How to update a field when another field is updated?
Scripting

• On Field Update Set n user property. (This is the answer interviewer is looking for though)

Explanation:
Scripting:
You can write script on SetFieldValue event of buscomp to update the target field. But the problem with this solution is if user UNDO the record then your script won’t revert back the changes that it has done.
One more solution can be to check in SetFieldValue event if that field is being updated through global flag and then on WriteEvent of buscomp execute your script only if that flag is set to true. But again you will have to set global flag to false may be Delete event (this is fired when user undo the record).
These solutions by scripting are really cumbersome. So we generally use On Field Update set n User property for this kind of requirement.
On Field Update Set n:
As the name suggests that this user property is used to set value of another field when a particular field is updated. In this user property n is the incremental number which is 1 more than the number used in the last On Field Update Set user property.
Value:
The value of the On Field Update Set user property consists of three quoted parameters separated by a comma and a space which is as following “FieldToCheck”, “FieldToSet”, “[Value]“
Example:
You want to set TargetField with SourceField value whenever SourceField is updated. So you will specify it like this.
Property: On Field Update Set 1
Value : “SourceField”, “TargetField”, “[SourceField]”
You can also make use of expression in the Value that you specify.
Example:
“SourceField”, “TargetField”, “[SourceField] + [AnotherField]”

Read More »