The data that siebel supplies as a part of siebel vanilla application is seed data.
SIEBEL is the leading provider of Customer Relationship Management (CRM) software.
Multi Value field has the child values from a child BC for the parent record configured through MVL. single value field will be either from the base table or joined table.
The Difference between Single Value Field (SVF) and Multi Value Field(MVF)
SVF- a field in BC which references a column in a table.
MVF- a field in parent BC which references a field in child BC.
Field-Identifies and defines a field in a business component. All fields making up a business component record contain entries from both Single Value Field and Multi Value Field object types.
Create a Pick list using a BC representing the joined table. Associate the Pick list with a BC field. Map the BC fields to the Pick list BC fields. Create a Pick list applet. Specify which control or list column will invoke the Pick list applet.
Add a joined field in the parent BC (based on the “main” table). The join is implied and created automatically at runtime. Add a control or list column to an applet.
MVG is nothing but to display the child records for the parent table ,and for pick applet to update join fields.
Pick applet is used when there is 1:1 relationship and MVG is used when there is 1:M r/n.
Siebel Horizontal application is general to every industry. where as Vertical is specific to a industry. such as eAutomobile, eInsurance, eBanking etc.
These are the types of applications. Example for Horizontal applications is transport. Here are examples for vertical applications are Eservice Call center application etc.
consider there are 3 bus comps. in that say there is no relation ship between the 1st and 2nd bus comp and there is relation ship between 2nd and 3 rd bus comp. but some fields are necessary from the 2nd bus comp. it will be fetched through the relationship from 1st and 3rd bus comp. this is called indirect MVL.
Applet toggle identifies one or more alternate applets to use in displaying the data of a business component. They are 2 types static and dynamic.
Siebel Gateway is the name server which controls the Enterprise Server.
eScript (or) Siebel VB
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.
@we can use it in parent child relationship where the child entity is lonely related to the parent table.
@or we can make it as a intersection table by adding the foreign key of another table's primary key in the 1:M extended table.
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.
S_PARTY Table is the Base Table for all the Party related tables.
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.
User Id not found
For up gradation and language conversions.
Persistency, Exception points and write to file, Write a error handling workflow.
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:
catch( e )
"Something bad happened: %s
This property determines whether or not siebel will override the sort specification and if so determines the sort that will be applied to the BC for All or Manager's view. The values are TRUE, FALSE or NORMAL NORMAL-usesBCdefinedsortspecificationTrue --Overrides the BC sort and Uses theU1index False - Removes all sorting
Designed BCs, BOs, Applets, Views, Screens, etc
Virtual Business Component is used to display the data from another Legacy database table, in the Siebel screen.
The search specification for the parent pick list should be "Parent Id is Null".
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.
The employees would not be able to log in as you have to create a database login and password for the employee to login into the client application.
In siebel 7.x it was defined as
The main difference is , In siebel 6.x Physical interface was not achieved. In Physical Interface includes web templates, cuss sheets.
Detailed Category and Aggregate Category are the two different sets. You can add a view to a screen under Detailed Category or an Aggregate Category. For Example: If I am creating two Views as detailes views. First I need to create a Detailed Category. Then I have to create two Detailed Views, for which the "Category" property must be specified with the created Detailed Category name. This is same for Aggregate Views also.
SQL, Oracle, DB2
There can be eight applets at most.
"Join" object specifies the table name and "Join Specification" object specifies the Primary Key Foreign Key relationship.
1:1 extension table is like an extension to the base table. if we do not have the required table space in the base table for craeting new extension columns, we will use the 1:1 extension table's columns using an implicit join.
in contrast, 1:M extension tables are used for parent child relationship with the base table. where the 1:M extension has only related to the base table. for example, for a contact (S_CONTACT) there will be a number of specialities in the extension table(S_CONTACT_XM) with the parent child relationship.
s_opty is a base table
s_opty_x is an extension table with 1:1 relationship
s_opty_xm is an extension table with 1:M relationship.
To get external data from external database without storing it in Siebel Database.
Types: higher level object types displayed.
Details: expanded top level object type displays object definitions of that type.
Flat: displays all definitions of that type.
We can enter free text incase of Unbounded Picklist. But, incase of Bounded Picklist, we can not enter freetext.
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.
Informatica, Data Stage
Force Active property for a field makes it accessible in scripting even if it is not in UI.
Create a MVL in the parent BC. Add MVFs in the parent BC. Create a MVG applet to display child records. Add controls/list columns to the parent applet to display MVFs and invoke MVG applets. Add primary FK in the parent BC and on the MVL.
Usually Drilldowns will be in List Applets only. But, in Siebel 6 there are Drilldowns on Form applets also. But, these are not similar to those in List Applets. in order to go to the target view we need to right click on the applet, on the menu shown we can find the available Drilldowns with Title as "Go To XYZ View".
It is possible through scripting either Siebel VB/ eScript.
Run Time Events - specified at Start Step (Event Object, Event, Event Type), Scripting - Business Service, Workflow Policies.
Modify the object definitions in the local repository.
Create the users first, then assign them some responsibility and position. then create the database login.
Controls your Enterprise,
Manages Siebel Servers,
Allows the configuration of the components,
Allow you to run tasks,
Load balancing is maitained by the Gateway server using the third party software Resonate Central Dispatch.
foreign key table is the property for a column in the table. it specifies for a column from which table this reference has been came.