Oracle CRM ondemand and Hoover's integration

To Know More About Your Prospects Than Ever Before

Increase your sales team's productivity by leveraging our global database of more than 32 million public and private companies and 36 million executives. Access Hoover's offers the breadth you need for targeted prospecting and the depth required for insight and strategic intelligence.


Be a beta tester for Oracle CRM ondemand and Hoover's integration - Contact: crm@hoovers.com

For demo Refer: http://www.hoovers.com/crm/oracle/100000934-1.html

What are different types of Tables?

There are 4 types of tables in siebel

1) Base Table (Ex: s_contact s_user)

2) Extension table ( Ex: s_contact_x)

3) interface/EIM tables

4) Intersection Tables (Ex: s_org_bu)

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 Pubilc we can.

What are the differences between siebel 7.8 and 8.0?

1) Siebel 8.0 has introduced Task UI for task automations.
2) Siebel 8.0 has Object Level check out which was not possible before.
3) Business user properties have become drop down list in tools and hence no need to remember syntax for each

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

eight applets in Siebel6.
16 applets in Siebel7.7.

How do you import List of Values?

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

What are Pre defined Queries?

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

What is the difference between "PickList Generic" and "PickList Hierarchical" BC?

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

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

Pre Default Value will be defaulted when new record is created. Post Default Value will be defaulted if there is no value specified for the field. so, Pre Default Value will be stored in the Database.

Why do we use Symbolic Strings in Siebel 7.7?

Keepijng the strings from the view definition is called symbolic strings.

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

What is horizontal and vertical in siebel?

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

What is the function of SWSE on the Web Server?

SWSE is Siebel Web Server Extension. It accepts the siebel requests and pass it on to Gateway server where the server manager decides to which siebel server component should this request goto.

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

Yes provided if we have multiple enterprise servers for multiple database. No more than one database could be added to an enterprise server.

Which will be better if performance issue is considered. Pick Applet or Dynamic Picklist ?

both are one & same since DPL Contains the pick applet.

What is link?

It specifies the relationship between 2 BCs. The relationship can be 1:M or M:M.

What is join?

Join allows data from more than one table to be displayed on one applet. It is a relation between BC & another base table/joined table. It is used for 1:1 & M:1 relationship.

What is state model?

It provides a data driven method for extending workflow control based on the status of an object such as a service request or a product defect. A state model is the blue print of acceptable states & state transitions that the state machine enforces. The state machine then makes sure that these objects go thro' the desired process defined in the state model.

Why do we do index in Siebel DB?

It is a separate data structure that stores a data value for a column & a pointer to the corresponding row. They are used to retrive & sort data rapidly. It can be created by configurators to produce a custom index.

Difference between EIM & EAI?

EIM:

Larger volume of data
Batch processing
Data object layer only
For replication, interface table is used.

EAI:

Small volume of data
Real time processing
It uses all layers
For replication, it uses siebel adapters & connectors

What is the difference between get & checkout?

They are same except that get doesn't place locks. Initial get is required before compiling against the local repository.

How do you assign responsibilities to employees in Siebel?

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

How do you control visibility in Siebel?

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

How do you create extension table to an interface/intersection table in Siebel?

We can not.

How do you set up employees in Siebel?

The Employee is also a USER who must be assigned with a valid position. Goto user administration then employees - Fill all details.

How is load balancing maintained in Siebel?

It was maintained by the Gateway server using the third party software Resonate Central Dispatch. Now it is thro' siebel internal load balancing.

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

Siebel 6.0:

2 tier
Standard interactivity
Thro' Intranet access

Siebel 7.0

3 tier
High interactivity
Thro' Internet access

How is Siebel 7.x data model is different from Siebel 6.0?

S_PARTY is the base table and S_CONTACT, S_ORG_EXT, S_POSTN, S_USER are now extension tables.
Siebel 6.x was dedicated application.
Siebel 7.x onwards we can access Siebel application via web.

How is the opportunity related to an account?

M:1

How is tools architecture constructed in Siebel?

In siebel tools, you have 3 tabs.
Type - parent child relationship
Flat - all the siebel objects
Detail - all the records in object.

How will you edit the joined field values in join?

using pickapplet or dynamic picklist.

How will you improve your performance in views?

Use primaries for MVG in list applet.
Keep number of BCs used in view is small.
Aviod creating using large number of joins in BC.
Aviod retrieving large number fields.
Aviod specifying outer join.
Aviod force active & link specification True.
Aviod calculated fields

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

Yes, it is a single entry point.

What does an opportunity, account, contact do in Siebel?

Those are business entities & they have relationships.

Account & opportunity = 1:M
Account & contact = M:M
opportunity & contact = M:M

What does install.ksh and imprep.ksh files do?

Imprep.ksh : Importing siebel repository & populate the Repository tables during DB server install.
Install.ksh : DB schema created

What does position represents in Siebel?

Position determines which records can be accessed by which users(data level access). In contrast, Responsibility gives View Access (screen access).

What happens if you create an employee in Siebel application and not in DB?

Can't login since DB user id & password is needed.

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

Every base table having the extension table. 1:1 and 1:M extension table's are available. 1:1 extension and the base table are logically considered as a single table. Par_row_id will be the foriegn key.

What is constrained picklist? Where you will drop the constraints?

It filters values dynamically to display only records with one or more fields that match corresponding fields in the orginating BC record. It filters pick BC records for matches.

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.

What is position type field in position applet?

It is a picklist.

What is Resonate?

Resonate is 3rd party (load balance)software development tool, which is used for distibuting the cilent request to the least loaded siebel server.

What is seed data in Siebel?

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

What is Siebel file system?

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

What is s_party table?

S_PARTY Table is the Base Table for all the Party related tables. It can have the implied joins. The party related BC's have the S_PARTY as the base table.
S_ORG_EXT
S_CONTACT
S_USER
S_BU
and etc.

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

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

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

Total layers are four.
1. Physical UI Layer (New one)
2. Logical Layer
3. Business Object Layer
4. Data Object Layer.

What is the relationship between a view and a BO?

View refers to only one BO always & the BO is logical collection of BCs.

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. It is used to process the exceptions that may occur in the manner you specify in the exception handling.

What is external BC (EBC) in siebel?

The purpose of EBC is to view/delete/update/insert data available in external DB. It is always used to integrate with external applications. While creating EBC you import external table definition into siebel (it is in DB layer). it is based on external table & uses data source defined on BC & table to retrive data.

What is virtual BC in siebel? What is use?

The purpose of VBC is usually to view external data that we don't want to store (virtual) in siebel. It is not necessary to use only for integration purpose. It has no base table & uses business service to retrive the data.

Why is it not recommended to modify existing base tables in siebel?

It is not needed when you have extension tables already. If you do so, it will affect application performance & give problems during upgrade.