Siebel Development

Siebel: Unable to reduce the height of the labels after certain limit in a form applet.

2011-11-16T17:48:00.001+05:30

Delete Siebel Preference File(.spf) in web client bin folder. Allow you to reduce the height. A new .spf file will be created again.
e.g. "SADMIN&Siebel Call Center.spf"

Siebel : Calculate 18 years age Flag including leap years

2011-11-06T14:28:00.003+05:30

Ways to calculate 18 years age Flag including leap years:

1. Create Calculated Field of todays date in YYYYMMDD Format:
e.g: Formatted Today Date : ToChar(Today(),'YYYY') + ToChar(Today(),'MM') + ToChar(Today(), 'DD')
       Field Type: DTYPE_NUMBER

2. Create another Calculated Field Birth date in YYYYMMDD Format:
e.g: Formatted Birth Date : ToChar([Birth Date], 'YYYY') + ToChar([Birth Date], 'MM') + ToChar([Birth Date], 'DD')
       Field Type: DTYPE_NUMBER

3. Set the Calculated Age Under 18 Flag as mentioned below:
        Age Under 18 Flg : IIf(([Formatted Today Date] - [Formatted Birth Date]) < "180000", "Y", "N")
        Field Type: DTYPE_TEXT

Siebel Hierarchical Pick list by using List Of Values Dynamic (REL)

2011-11-06T13:53:00.003+05:30

1.Create Pick List for Field1

Name: Pick List Field1 Demo
BusComp: PickList Generic
Type Value: FIELD1_DEMO

2. Create Pick List for Field2

Name: Pick List Field2 Demo
BusComp: List Of Values Dynamic (REL)

"List Of Values Dynamic (REL)" business component has fields named "Parent Value" and "Parent Type".

Search Specification: [Parent Type] = ' FIELD1_DEMO'
Type Value: FIELD2_DEMO

3. Configure Siebel FIELD1 on business component

Name: FIELD1
Immediate Post Change: TRUE
This property needs to be set to TRUE for parent field.
Picklist: Pick List Field1 Demo
PickMap:

Field: Field1
Picklist Field: Value

Field: Field2
PickList Field: NULL (leave this field as blank).

(This pick map is configured to set the Field2 to NULL Field1 is changed)

4. Configure Field2 on business component

Name: Field2
Picklist: Pick List Field2 Demo
PickMap:

Field: Field1
Constrain: TRUE
This property is set to constrain Filed2 by Field1.
Picklist Field: Parent Value

Field: Field2
Picklist Field: Value

5. Compile the changes

6. Set up the Parent/Child List of Value (LOV) relationship between field1 and field2 at the client level. Without setting the Parent/Child relationship properly, the hierarchical Pick List does not work as expected. Please refer above image.

OPA - Oracle Policy Automation / Siebel

2011-09-02T16:10:00.001+05:30

Step to create OPA/Siebel Project :

Assumption : OPA determination server, Siebel server & Siebel Connector installation is already done with all seed data. Currently OPA 10.2 version is for siebel.

Steps :
1. Create mapping in Siebel
2. Export Siebel Mapping
3. Create project in OPA
4. Import Siebel Mapping in OPA-Project
5. Create Rules in DOC/EXCEL
6. Build
7. Test it on integrated Oracle web Determination
8. Deploy it on Production Server(Tomcat/Weblogic Server)
9. Create port in siebel (Outbound Web Service)

10. Test

RunTime Event & WorkFlow

2011-05-06T10:01:00.005+05:30

Recently, I came across a situation where I need to call a WF on some BC fields value conditions, I prefer Workflow policies for Siebel Integration only, not always for Config. Hence, I would have only two options Scripting or Runtime.BC has already a lot of scripting and no place remains for new script.

Condition Sub-Status = "Dis Approved" + ... on SR BC.

So, I implemented this by using RunTime Events. If you have to call a WF from Runtime Event do't go for Administration -> RunTime, Use WF process events and use conditions inside WF process. Attached image is property window of start branch of WF. This process will be called at PreWriteRecord of SR.

Siebel automatically creates record in Admin->Runtime with Row_id of WF. And don't forget to click Reload runtime from Administration -> RunTime.

Boolean Values in Siebel Expressions

2011-05-06T09:55:00.002+05:30

In Siebel expressions,

Bool has three values NULL, Y & N. Hence, If you are using bool in any expression, make sure you are taking care all three values."Y" & "N' does not work every time.

Publish Post

Current Record Refresh

2010-09-28T13:12:00.002+05:30

Current Record Refresh

Sometime we do some scripting and update current record but updated value does not reflect immediate, we need to do again query and go.

We can solve this issue by using following scrip at the end.

TheApplication().GetService("FINS Teller UI Navigation").InvokeMethod("RefreshCurrentApplet",TheApplication().NewPropertySet(), TheApplication().NewPropertySet());

The SRF file specified is not compatible with this version of the application.(SBL-DAT-00145)

2010-09-28T13:08:00.002+05:30

The SRF file specified is not compatible with this version of the application.(SBL-DAT-00145)

Application version and tool version should be in sync. This issue comes when we do incremental compilation and tool version is different then client.

check version

C:\Program Files\Siebel\8.0\web client\UPGRADE\base.txt

C:\Program Files\Siebel\8.0\tool\UPGRADE\base.txt

Siebel Tool : unable to load dictionary

2010-09-28T13:06:00.001+05:30

Disable Antivirus and try again.

Siebel Remote Flow/ Details

2010-08-31T11:54:00.006+05:30

Siebel Remote Flow/ Details

Hi,

Following Oracle links are very useful to understand Siebel remote flow , that describes all used processes as well.

Master Transaction Log
Transaction Processor
Transaction Router
Inbox / Outbox
DX files (.dx)
TOC files (.toc)
Remote clients process transactions in their local database
synchronization process
Transaction Merger

Siebel Remote data flow Digrame / Siebel Remote processes details

Remote up flow diagram

Remote Downflow Diagram

You can not continue to work on this page because the state of this page can not be restored on server

2010-08-18T13:33:00.002+05:30

if you create a new record in Siebel eService, populat newly record and saved, Moved to next page.

Now you want to do some update on newly created record, you might come back by Using BACK Button of browser. The moment you will click Back button, you will find following error message.

I have implemented and fixed this by two ways.

1.By using cookies(javaScript) : You can set cookies the way that the moment it goes to defaulter page it should redirect to some other page.

2.Delete History : After saving newly created record, user will go to next page, the moment user click Next Page, bu Using delete History u can delete defaulter page from cache.

Thanks

The selected record has been modified by another user since it was retrieved. Please continue.(SBL-DAT-00523)

2010-08-18T13:15:00.005+05:30

While working with eService-Standard Interactivity,

User needs to populate all detail on one page then needs to proceed next page .(eg: On first Page populates Contact Details, Next Page Populates Income Details.)

if user wants to come back on previous page(eg: contact) then he can use BACK button of browser.

But when he does some changes on previous page (eg: on Contact) and click save button, a error message prompts as follow,

The selected record has been modified by another user since it was retrieved. Please continue.(SBL-DAT-00523)

Solution :

What I did , Goto browser script of applet, Write following script

function Edit__0__Control__WriteRecord__onclick (applet, id)
{
Top().SWECount = Top().SWEServerCount;
}

SWECount is page count & SWEServerCount is server request count.

Thanks

Profile Attribute

2010-03-31T09:51:00.003+05:30

Profile Attribute :

You can find out value of any profile attribute by just using following code in URL of Siebel Application.

javascript: alert(theApplication().GetProfileAttr("Is Anonymous"));

Danish

Siebel Audit Trail : Basics

2010-03-22T11:36:00.007+05:30

Audit Trail :

1. Can keep tracks of Read,Update,Delete,new and export on BC.
2. Internally it uses "Audit Trail Engine" BS. Hence BS user property : Enable should be TRUE.
3. Audit trail works on BC having class "CSSBCBase" or inharited by this class.

Enabling Audit Trail :

EnableAuditing system preference should be TRUE.
EnablEimAuditing system preference to TRUE for EIM purposes.

Create a new record in Administrator -> Audit Trail
Significant of property are as follow :

1. Assoc : Specify parent Child relationship Audit

2. Delete : Audit for Deletion.

3. End Date : end date for audition.

4. New : Audit for new operation

5. Restriction Type :Specify condition that determine which should be audited.

6.Update : Audit for update operation.

7.Export : Audit for Export Operation.

Create a record in Field on child Applet, that has to be audited.

1.Read Field Value : Field that you want to store at the time of record reading.
2.Reading : check if you want to audit read operation.

Table Apply Activate issue in Siebel Tool

2010-02-27T20:16:00.007+05:30

Table Apply Activation Issue in Siebel Tool :

Some time when we do Table Apply Activate, Siebel tool hangs and required restart.
Few times, It hangs each and every time.

So you can use following approach to avoid it.

1. Do spool and check which column(Column_Name) is not present in underline database.

2. Find out table(Table_Name).

3. Simply run following sql statement with DBO privilege.
Alter Table Siebel.Table_Name
Add Column_Name DATA_TYPE

Data_Type could be Varchar, Date etc. Take data_type as per requirement.
It works fine.
As per my understanding above is good approach to avoid siebel hang on Table Apply.

Your feed back would be appreciable.

Adding Custom View to Vanilla Responsibility

2010-02-23T11:30:00.003+05:30

Currently, I came across a requirement, where I needed to add a custom View in Vanilla Responsibility.
It is not possible through UI. Vanilla Responsibility never allows to add any custom views.

But you can add custom view in Vanilla responsibility by using following parameter(/editseeddata) in command line, As;

/U Username /P Password /s c:\spool.txt /editseeddata

Siebel thick Client URL Issue - FQDN

2010-01-29T13:16:00.007+05:30

Siebel thick Client URL Issue:

Whenever, we open siebel thick client(local) it takes URL automatically as

http://(machine name)/start.swe

but when we move from local network to Client network by using VPN or whenever we change port or IP. Siebel thick client disconnected and we get message 'Page not found' and need to restart thick client again.This can be avoided by using following two parameters of cfg file under section [Siebel]

EnableFQDN = TRUE
FQDN = localhost

Command Line for Siebel Application

2010-01-14T21:43:00.006+05:30

Command Line Parameter for Siebel Application.

/c : Configuration file

/h : Debugger mode

/d : Default database.

/s : Spool

/u : UserId

/p : Password

Note: For Spooling in WF simulator process, Need to pass /s before /h in debug arguments in Siebel tool.

Siebel Client / Tool / system Performance

2010-01-08T13:14:00.006+05:30

Siebel Client / Tool / System Performance

Siebel Tool and Client should run smoothly otherwise it irritates a lot on work.
As per my understanding, Apart from my previous post, For improving performance of Siebel Tool / Client And System, you need to regularly delete all *.log ,*.txt and *.dmp and spool.txt of Siebel Log directory on your local.

Also delete all temporary files of your local system, That resides in TEMP Folder.You can check your temp file directory.
Go to Run and Type %TEMP%
Delete all file of this dir, but don't delete structure. Means don't delete any folder only files should be deleted.You can use Dos CMD for same.
I have written following bat file that regularly delete all temp file as well as all siebel logs after a time interval.

log.bat

REM*****************************

REM Delete Log and temp file

REM*******************************

cls

cd C:\Program Files\Siebel\8.0\web client\LOG

del /F *.txt

del /F *.log

del /F *.dmp

cd\

cd C:\Program Files\Siebel\8.0\Tools\LOG

del /F *.log

del /F *.dmp

cd\

DEL /F /S /Q %TEMP%

On Production Server,You can use environment variable SIEBEL_LOG_ARCHIVES = 3, It will keep only recent 3 copy of a log and will delete old.

You can use window scheduler to schedule this after a regular time interval(Like reboot).

Dataexp / Dataimp utilities

2010-01-07T18:12:00.006+05:30

Repository:
--------------
As per my understanding, Siebel repository resides in around 148 tables.For better access,there is also a binary form of repository called SRF,compiled and stored on all siebel servers.

1.Seed data
2.Repository Data
3.User Data

Siebel database utilities
----------------------------
Dataexp/Dataimp utilities :
As per my understanding, This utility is very nice for importing data from one db to other.but this utility has not been documented anywhere.So before doing any migration, take proper backup.It needs to be used on siebel instruction only.But It works very well all time.No matter what is source database and what is destination data base.you can import data base from production to local, local to prod .Before import, Truncate table that removes all old records and sync with new.
Close thick client and tool as well.
Cmd syntax:
C:\Program Files\Siebel\8.0\Tools\BIN\Dataexp /U USERNAME /P PASSWORD /C "ODBC NAME" /D SIEBEL TABLE OWNER /F C:\export.dat /L c:\log.txt
It imports table by table and continuously prompt for table name.
Same for import.

Siebel Tool / Client Performance / Hangs

2010-01-04T19:51:00.006+05:30

Siebel Tool / Client Performance/ Hangs

1.Always Close siebel tool/client from file->Exit, Because improper close of siebel tool, Kept log of all transaction and don't delete all after tool close. When you close tool from file->Exit, it removes/ deletes all transaction log saved in S_DOCK_TXN_LOG

2.Truncate table S_DOCK_TXN_LOG .It will delete all transaction log that has not been deleted automatically because of improper exit of siebel tool.
S_DOCK_TXN_LOG : Keep tracks of all DB changes(field level) through application.
3.Make AutoStopDB = TRUE in tool.cfg and client.cfg

4.Don't remove server name from odbc,that is readyment server.

5.Remove additional parameter of local ConnectString

ConnectString = C:\PROGRA~1\Siebel\8.0\Tools\LOCAL\sse_data.dbf -q -m -x NONE

6.In ODBC, Supply user id and password of SIEBEL.

Workflow Policy Conditions

2009-12-28T16:03:00.008+05:30

Policy Condition
IS ADDED :
If a new row is added for workflow policy component, then trigger this workflow policy to be examined.
If it is used in conjunction with standard comparisons, IS ADDED can also be triggered when a record is updated.

IS DELETED :
When specify a child workflow policy component in the Condition field, and nothing is specified in the Condition value.
A child workflow policy component is a workflow policy component that is associated with a parent workflow policy component in Siebel.

Above both comparison don't work on field/column level

IS UPDATED:
When IS UPDATED is not present, the Workflow Monitor Agent only invokes the policy if conditions defined in the policy are violated. However, if an IS UPDATED comparison is included as criteria on a field, then other fields in the Policy conditions are never be present on trigger.sql. But at run time workmon checks other condition of policies.

Ref : Siebel Bookself

Anonymous said...: As per my understanding, All Above Comparison uses OR, not AND, Opposite to common behavior of policies.

Query LOV

2009-12-22T22:39:00.004+05:30

Hi ,

There is a vanilla Function for querying LOV.

TheApplication.InvokeMethod("LookupValue", type, lang_inde_cd);
it returns 'Value' .

var LOV_Val=TheApplication().InvokeMethod("LookupValue","SR_SUBAREA","WASIN");

So don't query on LOV BC, use this vanilla BS.

List Of Value

2009-12-22T18:11:00.003+05:30

In List Of Vaue , Dispaly Value(Value) and name (Language Independen Code) should be unique.

You can use Description,ORder or High and Low for data saving but (Name and Value) should be unique.

Currently, I have to save Postal Code and Area Name and need to fetch Area name on basis of Zip code but more then one zip code can have same Area name.hence ,I can't Use (name,Value) Pair instead i have used Descriptioon Field.

high and low column in 'LSt Of val' is also useful for saving values.

Siebel Tool / thick Clien Installation Problem

2009-12-11T16:20:00.004+05:30

Some time when we install Siebel Tool/Application, Siebel installation hangs when it reaches to language pack installation.

This happens because of default web Browser.

Simple set default web browser as IE. Restart System.

Control Panel -> Add remove Program -> Set Program Access and Defaults

OS : Window

It will work.
Danish