Rene Schmidt

After much anticipation, it finally happened, we got a project where the client wanted to use Siebel version 18 (aka IP 2018), which meant that this project was going to be done primarily utilizing the Composer rather than Siebel Tools. When I started the project, I tried to find a brief introduction to the Composer […]

There is a better way to get help in Siebel Tools! Suppose you are trying to get help about a business component field property (for example, force active):   You could navigate to the help menu and choose Contents:   Siebel Tools will return a list of all places in which “Force Active” is referenced. […]

Recently, we had a requirement to create an installation of Siebel Tools that would run against the server database and be READ_ONLY with no ability to change the user that had WRITE privileges. The users of this machine knew the password for SADMIN, and also had the ability to create a new user that had […]

A colleague of mine recently informed me that there are hidden properties in Siebel Tools. This post will share how to make these properties available. In your Tools.cfg file set this value: ClientConfigurationMode = All The complete list of object types can be found here. Some of the more interesting object types include: Applet | […]

Recently, I had a Siebel Clinical Trial Management System (CTMS) client requirement to load data into the database, clearly the purview of Siebel Enterprise Integration Manager (EIM). The client sent me the data in a spreadsheet, and it looked something like this: Site_Number Contact_ID Role 800,1,300,500 1-2ASW Pharmacist 6,7,2 1-4RSW Doctor 1,2,4,6,7,8 1-5E33 Lead CRA […]

In Siebel IP2016, the Sybase database was replaced with Oracle’s own XE database. The switch has presented some advantages and some drawbacks. One of the advantages is that you can have multiple instances. In my case, I have one instance for each IP2016 project that I am working on. This is the blog that I […]

A new utility was provided with Siebel version 16.0 (i.e., IP2016) that is quite useful. OracleXEConfig allows you, as a developer, to have multiple Oracle XE instances on your computer and enables you to quickly switch to one that is active. It also allows you to create empty local databases. This is extremely useful if […]

I recently started working on a project where I am using Siebel IP2016. IP2016 uses Oracle XE for local development and requires a lot of free disk space to create and initialize the local database. I use Oracle’s excellent (and free!) VirtualBox version 5.2.8. The specific virtual machine that I was using was a Windows […]

By default, Siebel out-of-the-box does not allow you to change the Primary Flag in MVG applets. This includes Clinical Site, Accounts, Protocols, etc. Here is an example: On the Site Management screen, press the icon for the Team MVG: This opens the Pick Team MVG Applet. Note that the Primary Flag field is read-only. Now, […]

Recently, a client running Siebel 8.1.1.4 had developed a complex report. If the report were run for a small-to-medium set of data (controlled by querying the data in the user interface (UI)), the report would complete successfully. However, if the report were run for the entire set of data, the report would fail after a […]

A common requirement in Siebel is to configure constrained picklists. First, let’s define what a constrained pick list means. A constrained picklist is a list of values (LOV), in which the values are dependent on another field. Say we have an applet that has two fields: medical type and medical product. These are the values […]

In Siebel, we often find ourselves creating new extension columns and reusing unused business component fields for different purposes. But, how do you manage a situation in which an existing field has been created with a column text length that is larger than what you want? Let us look at an example. In this scenario, […]