Posts

Siebel Log File Analyzer

Image
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.

Siebel Open UI - Reload CSS without Page Refresh

Image
For all the Siebel Open UI developers here is a must have chrome extension for reloading CSS with out refreshing the page.  Once the extension is installed right click on the page and select Reload CSS. All the CSS from web server would loaded with out page refresh. Enjoy Development !!!!

Siebel Problem with isNAN eScript

Recently I was working with a requirement where the field needs to be validated to accept only numeric values. This requirement looked to be a simple one. Adding a validation on the PreSetFieldValue of the Business Component solved the problem. Below is the code added ............................... ........... if(isNaN(FieldValue){            TheApplication().RaiseErrorText("Sorry, invalid number, please enter numbers alone."); } ....... Thats it.... Now when testing all looked fine until accidentally I entered 123123e. There was no error thrown and the value was accepted. How ever this is not what the code is suppose to be doing. So thought of getting in deeper, tested with 88779e no error thrown, then with 2341209d error thrown. So "e" at the end was the killer. Some how a number ending with e is considered as a infinite number (not sure if I am correct). As an alternative and get rid of this scenario changed the code as below and it...

Edit Web layout with IE 9, IE 10 and IE 11

I recently upgraded from IE 8 to IE 10 and I was no able to do edit web layout for the Applet and View. Only way to get them working was to rollback. But I wanted to use IE 10, so found this particular patch that would solve the issue  8.1.1.10 QF0002052,   this resolved the issue and was able to do edit web layout. Also for 8.1.1.11 patch set 9 helps. Note: the patch needs to be applied on the Tools.

Siebel 8.1.1.10 Controls Overlapping in Chrome 32 and Higher Version - Workaround

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.

Siebl Open UI - Theme Changes 8.1.1.11

Image
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 ...

Siebl Open UI - Theme Changes 8.1.1.10

Image
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...

Google Map Integration in Siebel Open UI

Image
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...

Siebel Open UI 8.1.1.11 Released

Siebel as promised have delivered Siebel 8.1.1.11  version and is available on e-delivery for download. I got a chance to go through the bookshelf and its good to see that the bookshelf has been made quite explanatory and is vast almost 600 pages. And the manifest_extension.map and custom_manifest.xml have found no place in this release but this feature has been moved to Manifest Administration screen part of Application Administration. This screen would be used to map all the mapping and manage files.  All the existing files would need to be modified as there is a new line of code that needs to be added to alll js files from 8.1.1.11. All the details has been included in the bookshelf with example. Steps to download 1. Go to https://edelivery.oracle.com  and login 2. Accept the terms and conditions and click continue 3. Select Siebel CRM as product pack and platform required 4. Select  Siebel Industry Applications Innovation Pack 2013 Release ...

Siebel Business Service Part-4

Image
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

Image
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

Image
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

Image
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...

Siebel - DeleteRecord Method in eScript

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...