Siebel Knowledge

I have developed a jsfiddle that can be used to analyze the Siebel OM log files. This tool can be used online http://jsfiddle.net/Yajneshp/3owvw7qv/embedded/result/ The tool can analyze User View Navigation, Applet Actions, Workflow steps, Task Steps, Business service Execution, Task Navigation, Errors, SQL performance and Search a pattern. A Sample can be seen as bellow. Use it if this helps and leave a comment if its usefull.

Few days back I upgraded my chrome version and when I open Siebel Open UI application I saw all the contorls overlapping each other and I was shocked to see this. Then I started  to search the Oracle Support web and I found one article that says   Open UI - Applets Not Displaying Correctly In Updated Chrome Browser (Doc ID 1615924.1) I went through the document and the document says it a bug and is fixed in 8.1.1.11.4 QF. Now I am still 8..1.1.10 I cannot use that QF. So I found one more article in the document which says How to Fix Form Applet Issue in Chrome 32 . This document showed the details steps of to fix it with a workaround. But I saw the code and felt thats too much of code to executed. So I did some inspect element and found this solution. if(window.chrome){ $(".GridBack").attr("border","1").css("border-color","transparent"); } Added the above code in postload file and it worked like a charm.

The best thing in Siebel Open UI is, it supports  Javascript  and  JQuery . In this particular post I will do few of the changes in the application UI. To do the Theme Changes in 8.1.1.10 click here Below is the screen shot showing the vanilla application. After the changes the application would look something as below Steps to be followed 1.   Create a css file Dashboard.css (save the css file in files/custom/dashboard/ path) this would help to easily maintain the CSS changes. 2.  Include the theme.js file  as below (note : OOTB would provide a theme.js file in custom folder) a. Create a record in SiteMap->Application Administration->Manifest Files          siebel/custom/theme.js                       b. Update the Manifest Administration Screen as below . 3.  Open theme.js file and add the below piece of code ...

The best thing in Siebel Open UI is, it supports Javascript and JQuery . In this particular post I will do few of the changes in the application UI. To do the Theme Changes in 8.1.1.11 click here Below is the screen shot showing the vanilla application. After the changes the application would look something as below Steps to be followed 1.  Create a css file Dashboard.css (save the css file in files/custom/dashboard/ path) this would help to easily maintain the CSS changes. 2. Include the theme.js file in the custom manifest common section file as below (note : OOTB would provide a theme.js file in custom folder) siebel/custom/theme.js                   3. Open theme.js file and add the below piece of code   SiebelApp.ThemeManager.addResource(     "GRAY_TAB",     {        css : {                  "DashboardCS...

In this post I am going to show how Google map can be intgrated in Siebel Open UI. There is a white paper available at Oracle support you can also refer to that. But his one below is much simpler and can be integrated easily. I am going to show the Google map on hover of "Show Map" (custom control). Steps to be followed. 1. Identify the Applet on which we need to take the address and show it.      View:   All Accounts across Organizations      Applet: SIS Account Entry Apple t 2. First Add the Custom Control hover on which will show the Google Map.  In the above image " Show Map " in red is a custom control. On Hover of which Google Map would be shown. 3. Create PR File as below if( typeof( SiebelAppFacade.SISAccountEntryAppletPR ) === "undefined" ){ SiebelJS.Namespace( "SiebelAppFacade.SISAccountEntryAppletPR" ); SiebelApp.S_App.RegisterConstructorAgainstKey( "SISAccountEntryAppletPR", "SiebelAppF...

In this post I will discuss on how to create a business service. How to create a BS in Siebel Tools • Lock the project on which BS should be based on • Select the Business Services object in the Tools Object Explorer. • Right-click , and then choose New Record .( Ctrl+N ) • Type a name of the BS in the Name field of the new business service and Select the Project. • Choose the appropriate class Data transformation – CSSEAIDTEScriptService class. Other business services - CSSService class . Defining a Method for BS • With the business service selected in Siebel Tools, expand the Business Service tree in the Object Explorer, and then select Business Service Method. • Right-click , and then choose New Record. • Type the name of the method in the Name field of the new method. Defining Method Arguments… • With your business service method selected in Siebel Tools, expand the Business Service Method tree in the Object Explorer, and then select ...

Siebel Business Service Part-3 In the previous post we discussed on different types of Business Services based on where they are created. Let us now discuss what are basic building blocks of Siebel BS. A Siebel BS mainly consists of  Methods  and  PropertySets . Methods  : one or more operations in BS. For our better understanding we can compare this as any C++/Java program where we have multiple functions defined in it. Based what function is called the functionality of the program would depend on. We will understand this in better way when we see a BS in detail. At this point this should give us a rough idea. PropertySets : used to pass input/output arguments. As Methods may require Inputs/Outputs these are formed by PropertySets in Siebel. A Property set is a  data structure. Methods take arguments that can be passed into the object programmatically or, in the case of Siebel EAI, declaratively by way of workflows. We will discuss on th...

Siebel Business Service Part-2 In the previous post , a brief description on Siebel Business Service was discussed. Before we actually move onto the details on how we would implement the Business service, let us know more about BS We have mainly two types of Business Services based on the type of configuration selected. In other words a Siebel configurator can configure a Business Service either in Siebel tools or Siebel application. So based on this we can classify the Siebel Business service as      Repository – Stored Business Service      Client – Stored Business Service Repository – Stored Business Service : These BS are stored in S_SERVICE Table and when used the SRF needs to be complied for the same. Client – Stored Business Service : These BS are stored in S_RT_SVC Table and when used no need of SRF compile. Administration->Business Service Screen we can see all the Business services created at Application l...

Siebel Business Service Part-1 In Simple terms, Siebel Business Service (BS) can be defined as below      A Siebel Business Service is an object that encapsulates and simplifies the use of some set of Business functionality.      It is a unit of Business functionality which is reusable and globally accessible.      It enables business logic which can be executed repeatedly in multiple different contexts. BS are not tied to specific objects, but rather operate or act upon objects to achieve a particular goal. Example a Business component is tied to a table and an Applet is tied to a Business Component. But a Business service is accessible Globally in Siebel. All the Siebel Vanilla BS is written in C++ and cannot be customized by the user. But these BS will help to accomplish     most of the Business Requirement specially EAI BS. All the Custom Business Serv...

Let me take this opportunity to share a unique issue that I faced during one small requirement development. Requirement: Contacts with a specific roles are created due a configuration miss in the EAI. As the product is live the fix can be put only after the root cause is found and change window is available. Till then these records needs to be deleted. As the number of records is huge deleting these records manually is a time consuming task and no back end deletion is allowed as the product is live. As a work around a client side BS would be developed to over come the problem. Siebel  Version : 7.7 Below is the pseudo code BusCom = "TechLabHelp" With BusCom                clear Query()                Search for Contact with Role "TECHLABS"                FirstRec = FirstRecord                Wh...

I was working on a requirement where I had to call a Siebel Business Service from PM/PR files. Oracle Support gave a pretty simple steps to the same. But for each of the Business service to be called had to register it as a user property in the Siebel Application user property. This would need a SRF change every time and was not that easily feasible. So came up with the below practice which avoided the SRF change. Below are the steps to create call a Business Service from the Siebel PM/PR file. 1. Add the below Application User Property ClientBusinessServiceN = Business Service Name Here " N " would be the value in sequence of the application user property ClientBusinessService and Business Service Name is the name of the Business Service to be called. 2. In the PM/PR file add the below code to call the Business Service // Get the Object for the Business Service. Get the Business Service by passing the Business Service Name var sBusService = SiebelApp.S_App.GetSe...