Siebel Open UI is released ...!!!

Hi Guys,

The most awaited feature of Siebel, called Open UI is released. This new feature Open UI is available in new Siebel patch 8.1.1.9. The new patch is available for download on e-delivery.

I have downloaded it and the features are simply awesome. Below are some of the features of OpenUI.

1. Runs on most of the browsers IE, Chrome, Mozilla..
2. Partial refresh of the web page.
3. Task Based UI and Smartscript Players are very well designed.
4. eConfigurator UI is now shown in Full screen and the User Interface look and feel is good.
5. It has new feature to show the screen Navigator in Tab and Tree mode.
6. Inline query mode is pretty useful and can be used instead of regular query.
and the list goes on....

The below links are helpful for finding more details on open ui.

Bookshelf Link for Open UI.

Open UI Configuration link from Oracle support. You should have Oracle Login.

So guys, enjoy and explore open ui......

How to convert .Doc to .PDF files from Siebel Proposal documents?

I have got some requirement in which we need to generate the PDF documents instead of the regular word documents. In Siebel, document server uses the Microsoft Office features to create.doc files, but how can we create the pdf dcoument from the .doc file?

 The Idea is to use in-built pdf converter which comes with Microsoft Office 2007 software. The step by step instructions are given below to convert the .doc file which is generated by document server to .pdf file.

Step1: Create a custom button on any of the Proposal Applet.

Step2: Add below script behind the button. This script will be executed only when the document generation is completed.

  var oWord = COMCreateObject("Word.Application");

  oWord.Documents.Open(sFile);

  oWord.ActiveDocument.Save();

  var sNewFile = sFile.substr(0,sFile.lastIndexOf("\\")+1);

  sNewFile = sNewFile+sDocName+".PDF";

 oWord.ActiveDocument.SaveAs (sNewFile,17); // 17 is used for WdFormatPDF literal

  oWord.ActiveDocument.Close();

  oWord.Application.Quit();

  RetValue = InvokeMethod("PutFile",sNewFile,"PPSLFileName");

  PpslBC.SetFieldValue("PPSLFileExt","PDF"); 

  Ppsl.WriteRecord();

  Clib.remove(sFile);

  Clib.remove(sNewFile); //Remove files from temp location

Compile above changes to the applet and run below steps to see the changes are affected.

Create a record in Proposal applet,select a template and click on generate document. Once the document is generated then click on custom button to convert the actual .doc file to .pdf file.

This script will work only if Word 2007 is installed on machine where application is running.

Creating EIM Table Mapping for Standalone Table (No User Keys)

Requirement: Load data from flat file to a custom standalone table using siebel EIM.This Table should not allow duplicate records and has unique records based on col1,col2,col3(It just an example).

Solution: Follow below steps to create EIM mapping to an existing EIM table.

1. Create new standalone table CX_TSET_TBL using new Table wizard in siebel tools. This wizard creates  seven system columns by default.
2. Create new columns COL1, COL2, COL3, COL4 with Type = Varchar (30).
3. Create a New Index with below propeties.
•  Name = CX_TEST_TBL_U1
• Type = "User Key"
• Unique = "Y" (This Property makes the user to enter unique data  through UI)
• User Primary Key = "Y" The Property is used by EIM to enforce uniqueness on this index.
4. Add columns COL1,COL2,COL3 to the index created in step3. This is part of the requirement to enforce EIM to find unique records in Target table. This is equivalent to the user keys of the base table.
5. Run the EIM mapping to standalone table created in step1 to the sutiable EIM table with steps mentioned in bookshelf. It will create columns in EIM table and maps those columns to the target standalone table. It also create a user key on EIM table with the 3 columns(COL1,COL2,COL3) and IF_ROW_BATCH_NUM.
6. Write EIM scripts to load data.

Once you complete above steps, you can run EIM job on custom table. EIM will take care of the uniqueness of records and loads the data. It supports INSERT,UPDATE and DELETE operations.

Dynamic SQL Tracing in Application

While debugging we might want to know the SQL generated for the particular event. So we increase the log level to 5 OR we enable sql spooling.
In both cases, it is difficult to find the sql's generated only for the particular event. The following configuration will help you out to turn on/off sql spooling and there by analysing the sql generated only for the events.

Set/Get Profile Attributes at runtime

To set Profile attributes we normally write script code in an object and then compile it. But to set/get profile attibutes dynamically i.e, while the application is running we make use javascript prompt at IE addressbar.

To set profile attributes, type the following line in IE address bar and press enter key.
javascript:alert(theApplication().SetProfileAttr("ProfileAttrTest","SiebelForum"))


To get profile attribute which is set in above step, type the following line in IE address bar and press enter key.
javascript:alert(theApplication().GetProfileAttr("ProfileAttrTest"))


This will display the popup message with the Profile attribute set previously.

Message Popup in Siebel e-Script

While debugging in siebel escript some times we may want to know value for a variable. Instead of using script debugger we can just write a code to popup the variable. If we use TheApplication().RaiseErrorText() in e-script it will stop the execution of code, but if we want to know the values for the variables and continue with code execution then the following code will help.

var WshShell = COMCreateObject("WScript.Shell");

WshShell.Popup("In Applet Load Method",0,"Siebel");

WshShell = null;

How to test Siebel Inbound Web Service in Mobile/Developer Client

Most of us who worked on siebel EAI especially on web services are aware that Siebel server set-up is required to test in bound web services. As EAI Component should be required to receive the inbound SOAP requests which internally call web services.