Explore topic-wise InterviewSolutions in .

Data Storage LAYER, BUSINESS Layer & Data PRESENTATION Layer.

Data Storage layer, Business Layer & Data Presentation Layer.

PARTY DATA MODEL in 7.x.

Party data model in 7.x.

WEB LAYER

Web Layer

VIEW CONTAINS APPLETS which are RELATED to b/c. COLLECTION of b/cs is b/o.

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

To GET EXTERNAL data from external DATABASE without storing it in Siebel Database.

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

EXPLORER & LIST EDITOR

Explorer & List Editor

Its ASSOCIATED with an ACCOUNT for GENERATING POTENTIAL REVENUE.

Its Associated with an Account for generating Potential revenue.

They are SIEBEL BUSINESS ENTITIES in which we have a business INTEREST.

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

USER ID not FOUND

User Id not found

Yes.

Yes.

No

No

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

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

DAC CLIENT.

DAC client.

ODBC; Change data SOURCE NAME in Tools & Assign it in the Data Base.

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

DESIGNED BCs, BOS, APPLETS, Views, Screens, ETC

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

SQL, ORACLE, DB2

SQL, Oracle, DB2

INFORMATICA, DATA STAGE

Informatica, Data Stage

SEARCH STRING (VBC - input.searchstring)

Search String (VBC - input.searchstring)

YES, for POSITION & RESPONSIBILITY, ACCOUNT & OPTY

Yes, for Position & Responsibility, Account & OPTY

ESCRIPT (or) SIEBEL VB

eScript (or) Siebel VB

Through INPUT ARGUMENTS & SCRIPT.

Through Input Arguments & Script.

Tools

Tools

YES, For CHANGING PRIORITIES.

Yes, For changing Priorities.

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.

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.

with BIZ Talk (XML, MQ SERIES) or See BEYOND (uses ASP pages) or TIBCO (SIEBEL CONNECTOR) middlewares.

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

WF PROCESS is created at BO LEVEL, if we deal with multiple BUSINESS OBJECTS.

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

HTTP, MQ SERIES, EAI FILE TRANSPORT

HTTP, MQ Series, EAI File Transport

Provide a data DRIVEN method for EXTENDING workflow CONTROL BASED on the status SR Open - Cancelled, you define the state model.

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

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.

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.

PERSISTENCY, EXCEPTION POINTS and WRITE to file, Write a error HANDLING workflow.

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

Start – EAI Siebel Adapter – EAI XML CONVERTER – HTTP or MQ Series or File Transport - WRITE to file.

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

RUN Time Events - specified at Start STEP (Event Object, Event, Event TYPE), Scripting - BUSINESS SERVICE, Workflow Policies.

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

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.

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.

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.

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.

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.

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.

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.

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.

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

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

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.

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.

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.

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.

We can not CREATE an EXTENSION table with an INTERSECTION table.

We can not create an extension table with an intersection 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.

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.

EXTENSION TABLES are CREATED only for BASE tables.I think we can not extend the interface table.

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

During upgradation it will CAUSE PROBLEM if we extend base tables.More over if it is NECESSARY u can go for EXTENSION tables.

During upgradation it will cause problem if we extend base tables.More over if it is necessary u can go for extension tables.

VIEW references the business OBJECT. Every view is ASSOCIATED with a PARTICULAR business object.

View references the business object. Every view is associated with a particular business object.

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

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

YES, Because one Gateway SERVER can have MULTIPLE Siebel Servers.

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

Name server is the part of gateway server that DYNAMICALLY REGISTERS all SERVERS in ENTERPRISE, serves a connection BROKER across the enterprise.

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

Resonate is THIRD PARTY SOFTWARE development TOOL, which is used for distibuting the cilent request to the LEAST laden siebel server.

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

Load balancing is maitained by the Gateway server USING the THIRD party software Resonate CENTRAL DISPATCH.

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

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.

In siebel 7.x it was defined as

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