Home » Archive

Articles in the Configuration Category

Configuration, Siebel SQLs & Database »

[29 Dec 2011 | 5 Comments | ]

In new versions of Siebel CRM application, Oracle has encoded the audit trail to store it in encoded format in Siebel, instead of Separate columns of New and Old values. Hence it is not possible to get those values by directly reading the S_AUDIT_ITEM table.
So, I have created a Oracle SQL Procedure which will help you decode the audit trail and store in a temporary table, just like it was earlier. Here, you would need to provide Table, Column for which you want to grab the audit trail. You can specify multiple …

Configuration »

[13 Apr 2011 | 5 Comments | ]

1. These are some of the least explored yet useful business services provided Out-of-box in siebel.
2. This business service is used to get the HTTP related information like session, cookie, server or client IP addresses and may more variables. The most common usage is to get the IP Address of Clinet User machine to log and track the users or to restrict a user to not to open multiple sessions.
 How to use it? 
1. The best way to simulate and use it , is , go to business service simulator in …

Configuration, Featured, Videos Tutorials »

[6 Mar 2011 | Comments Off | ]

You can add extension columns to existing base tables. Adding an extension column avoids additional joins to extension tables for storing custom attributes. You can add extension columns to any of the following table types:

Data tables
Intersection tables
Interface tables
Standard extension tables
Custom extension tables
Extension (Siebel)


Emails-SMS, Featured »

[22 Jan 2011 | 3 Comments | ]

You must be aware of  Outbound Communications Manager (OCM) business service which is mainly used for sending emails from Siebel Application.This is a out-of-box business service, which provides method like SendMessage or SendSmtpMessage , CreateRequest, SubmitRequest methods for sending email from Siebel Workflow Processes or Custom Business Services. But there is a very UNIQUE use of Outbound Communications Manager which provides two specialized methods which are HIDDEN and not visible in Siebel Tools -> Business Service object. These methods are ‘ExpandedText’ and ‘ExpandedSubject’.
Also you should also know what is Communications Template …

Configuration, Scripting, Tips & Tricks »

[4 Aug 2010 | Comments Off | ]

Power of Siebel eScripting or also called as ECMA Scripting
1. We some time faces issues to remove special characters in a Workflow Step, and look for a vanilla Workflow function to use, but cannot find the one.
2. We try for a custom business service to find and replace the special character. But some time that custom business service restrict you to only few character, but later you want to filter out some more chars, the you need to modify it. Also, you may have to do a while loop or for …

Configuration, Siebel Slide Shows »

[11 Jul 2010 | Comments Off | ]

For Full Screen of Slide, click on Bottom-Left corner – “full”.

Performance with Siebel application has always been a challenge. Siebel suggest lot many ways to improve performance with from database to application configuration in tools. Here is a pdf which talks about performance improvement using Siebel Configuration.

Hope you enjoy this slide, post your feed back below.

Configuration, Siebel Slide Shows »

[11 Jul 2010 | Comments Off | ]

For Full Screen of Slide, click on Bottom-Left corner – “Menu”.

Siebel Scripting – eScript

Hope you enjoy this slide, post your feed back below.

Configuration, EAI »

[13 Feb 2010 | Comments Off | ]

EBC is a External Business Component, which is created in Siebel database using the external table definition file i.e. DDL file.
Lets take an example to be more precise,
We will copy our existing Local DB or Sample DB which will act as External Database. And lets take S_LANG table which is to be shown in our database via an EBC. This is Language table stores the Language Code and Name like CHS Chinese, ENU English, JPY Japan.
How to Create External Data Source?
1. Go to your /tools/sample/utf8 directory and Copy your …

Configuration »

[4 Jan 2010 | Comments Off | ]

Follow the below steps to create a simple Task UI in your local Siebel application.
Create a Transient BC based on S_TU_LOG table (by default), from New Object – > Transient BC.This table holds data temporarily for the TASK session.Add fields in this BC and they will automatically get assigned to some temporary columns of the table – S_TU_LOG.These columns will be storing the temporary data which can be used during the time the task is running.The class of this BC will default to CSSBCTaskTransient
Create a Transient BC based on S_TU_LOG …

Configuration »

[4 Jan 2010 | Comments Off | ]

First go through this video to understand what is Task UI. Then we take up the task of how to create Task UI in Siebel application.

In order to provide user interaction, quick-short forms to fill information and save it intermediately that can be resumed later, Siebel has provided a means, that is Task UI.
Task UI has evolved from Smart Scripts and Workflow. It took nice features of both and evolved as a integrated setup which is called as Task UI.
Follow the Steps to Create Task UI ,>> Next Post >>

Quiz, Workflows »

[6 Oct 2009 | 8 Comments | ]

This quiz talks about workflow topics and provides a bit of explanation to the answers. Please post your valuable feedback and suggestion over this initiative in below comments section.

Workflow Policy
Workflow Monitor Agent
Business Services

So, what’s you are waiting for, get started to refresh your Workflow knowledge base.


Configuration, Featured, Quiz, User Properties »

[28 Aug 2009 | 9 Comments | ]

Try out the below questions on Siebel Configuration that will help you revise your siebel skills.

Views & Screens
Business Services
Tools & Client
And lot more

So, what are you waiting for, just go through the QUIZZ and post your questions and feedback on Commets and Contact Me pages.

Workflows »

[10 Jul 2009 | 6 Comments | ]

This is for Workflow Policy which has a duration specified -
1. When the workflow policy conditions are violated, a new row gets inserted into S_ESCL_REQ table.
2. Now, if DURATION is specified in Workflow Policy, the Workflow Monitor Agent inserts a new record into the S_ESCL_STATE table and removes the row from S_ESCL_REQ table.
3. Depending on the Sleep Time parameter, Workflow Monitor Agent wakes up and verifies the S_ESCL_STATE table to check whether the row had reached its expiration time in the END_TM column.
4. When the record completes its duration, Workflow …

Workflows »

[10 Jul 2009 | One Comment | ]

Below is a detailed answer to certain questions like –
– What happens when your workflow policy fires,
– how a record get inserted into S_ESCL_REQ ,
– how monitor agent processes the record ??????

Workflow Policy not having a duration specified -
1. When the workflow policy columns are violated, a new row gets inserted into S_ESCL_REQ table by database Triggers.
2. Workflow monitor agent verifies the record in S_ESCL_REQ table and compares if the violated record and matches the Policy Condition.
3. If the conditions are not met, then …

Configuration, Debugging Techniques, Tips & Tricks »

[23 Jun 2009 | 3 Comments | ]

When you goto Tools->Screen object, you cannot see ‘Bitmap Category’ field because it is HIDDEN in tools for a normal view. You need to enable it from Tools CFG.
Here are steps -
1. Open your Tools.cfg.
2. Search for “ClientConfigurationMode”, it might be there with value like
ClientConfigurationMode = Web
3. If you find it or did’t find it, just add/replace below value to the [Siebel] section of CFG. This is the first section of CFG.
ClientConfigurationMode = All
4. Relaunch your Tools. This will show certain hidden fields and Objects of Tools.
5. …